StraightforwardSQL
Blog focused on MS SQL
  • Posts
  • Memes
  • About
  • Rss
Scary Scalar Functions - Part One: Parallelism

Scary Scalar Functions - Part One: Parallelism

Tom
2022-06-21
Scary Scalar Functions
6 minutes
Consultants hate me for this one weird trick. Because I’ll be uncovering all the mess Scalar functions can cause in a series of articles.
Coding Standards (T-SQL Tuesday #151)

Coding Standards (T-SQL Tuesday #151)

Tom
2022-06-14
T-SQL Tuesday
4 minutes
This month’s invitation is from Mala Mahadevan. I’ll be covering several of my favourite code standards.
New Extended Events in SQL Server 2022

New Extended Events in SQL Server 2022

Tom
2022-05-24
Information
2 minutes
The SQL Server 2022 CTP has dropped, and I took a look at the new Extended Events that are available.
Efficient Cheating at Lego Video Games

Efficient Cheating at Lego Video Games

Tom
2022-05-21
How to
7 minutes
Entering cheats in Lego Video games is incredibly time-consuming. So I’ve used the power of SQL to save a few keystrokes and optimize my cheating experience.
Cross DB Access With Module Signing

Cross DB Access With Module Signing

Tom
2022-05-12
How to
8 minutes
I’m reminding myself how to set up secure CrossDB access. This blog post includes a nifty diagram and follow-along example.
Why my way of writing SQL is superior

Why my way of writing SQL is superior

Tom
2022-04-13
How to
5 minutes
Aaron Bertrand has thrown a gauntlet on Twitter. Instead of commenting on how you do stuff differently, blog about it yourself. Well, challenge accepted!
Query Hash and Query Plan Hash Mapping

Query Hash and Query Plan Hash Mapping

Tom
2022-04-11
How to
8 minutes
If you ever had a problem mapping the binary hash from DMVs to the numeric one in Extended Events - this is the blog post for you.
« 3/6 »

Search

Recent Posts

  • Misleading SSMS Connection
  • Advent of Code 2022
  • Default event_file path for Extended Events
  • T-SQL Tuesday #156 - Wrap Up
  • Testing the code (T-SQL Tuesday #156)

Categories

  • AdventOfCode  1
  • Helping out  6
  • How to  5
  • Information  2
  • My Toolbox  2
  • Non-technical  1
  • Scary Scalar Functions  4
  • Silver bullets  1
  • T-SQL Tuesday  9
  • Wordle  2

Tags

Bug (1) Constraints (1) Debugging (9) Docker (3) Extended Events (10) Indexed View (2) Internals (1) KQL (1) Locking (1) Parallelism (3) Performance (5) Personal (2) Productivity (2) Query Store (2) Rant (2) Real-world (1) RegEx (2) Research (1) Security (1) sqlbits (1) SqlServer2022 (2) Testing (1) Toolbox (2) TSQL (23) Wordle (2) XML (2)

Social

Twitter
LinkedIn
GitHub
[email protected]
DBA Stack Exchange
About | Changelog
© 2023 StraightforwardSQL. Generated with Hugo and Mainroad theme.