SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Dodging Phantom Reads
October… the month of Halloween. Spooky events. SQL Server has all kinds of Halloween-ish themed activities like Split Brains, Zombies, Ghosts, Phantoms, and of course
Database Ghost Records
Yes Virginia, there are ghosts in your database. More specifically, there are SQL Server database ghost records. They are not there to haunt you. They
A new MVP on the team: TJay Belt recognized by Microsoft
Last week we recognized Jason Brimhall for being named a SQL Server MVP. This week, it’s TJay Belt‘s turn. TJay is the third SSG consultant
Above and Beyond: Jason Brimhall named SQL Server MVP
Here at SQL Solutions Group we strive for excellence with our consultants. We also encourage our consultants to be mindful and involved of the SQL
Query Optimizer Tips and Tricks Part 1: Trusted vs. Non-Trusted Constraints
Query Optimizer Part 1 It may come as a surprise to you to find out that at its core, the SQL Server Query Optimizer is like
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest encrypting a database. In SQL Server, we have the ability to