StraightforwardSQL
Blog focused on MS SQL
  • Posts
  • Memes
  • About
  • Rss
What is causing my constraint to be untrusted?

What is causing my constraint to be untrusted?

Tom
2022-06-24
Helping out
5 minutes
Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.
Scary Scalar Functions - Part One: Parallelism

Scary Scalar Functions - Part One: Parallelism

Tom
2022-06-21
Information
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!
1/4 »

Search

Recent Posts

  • What is causing my constraint to be untrusted?
  • Scary Scalar Functions - Part One: Parallelism
  • Coding Standards (T-SQL Tuesday #151)
  • New Extended Events in SQL Server 2022
  • Efficient Cheating at Lego Video Games

Categories

  • Helping out  5
  • How to  4
  • Information  2
  • Non-technical  1
  • Silver bullets  1
  • T-SQL Tuesday  5
  • Wordle  2

Tags

Constraints (1) Debugging (7) Docker (1) Extended Events (9) Internals (1) Parallelism (1) Performance (2) Personal (2) Query Store (2) Rant (1) Real-world (1) RegEx (1) Research (1) Security (1) sqlbits (1) SqlServer2022 (2) TSQL (18) Wordle (2) XML (2)

Social

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