Place the business rules database applications depend on in constraints, procedures, triggers, or application code according to their guarantees.
Learning from People: Conferences, Meetups and Mentors
Learning from people is how a craft travels. Conferences, local meetups and mentors teach what no course can: questions, mistakes and the hallway conversations between sessions. Here is how to get real value from each one.
SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!
My 1900th Post and 31 million views in almost 5 years. To celebrate, a fun FAQ my wife Nupur wrote, like why I started this blog and what it was first called.
Spotting tempdb Contention
Spot tempdb contention through PAGELATCH waits and allocation pages, then review file layout and current server settings before changing files.
Blocking DELETE Without a WHERE Clause Using a Trigger
A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.
A Page of Rows and the Grand Total Count in One Query
One query can give a grid its ten rows and the total for the label. Here is how, plus the empty page trap that catches almost everyone.
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.