Why I Love DML Triggers in SQL Server
It’s TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great...
2018-09-11
11 reads
Blog Posts
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
758 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
13 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the...
2018-09-10
12 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...
2018-09-10
2,761 reads
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
645 reads
PASS FY2019 Budget Notes Updated
PASS has updated the notes supporting the FY 2019 budget to answer the questions I raised in my earlier post....
2018-09-10
277 reads
Redgate University is Growing
There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate...
2018-09-10
230 reads
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,150 reads
Remember the Default Window
I ran across a question recently from a user about why they had strange results from a windowing query. This...
2018-09-10 (first published: 2018-08-23)
2,683 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara buka blokir muamalat Din baik dan benar
Cara membuka blokir bank muamalat atau Mobile bengking atau dapat dilakukan melalui WhatsApp resmi...
Alamat Kantor BCA KCU MEDAN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera Utara...
BCA KCP Kampung Baru CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Brigjend Katamso No.680, Kp. Baru, Kec. Medan Maimun, Kota Medan,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers