SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
There’s something about GUIDs
There is a popular practice among developers to use globally unique identifiers (GUIDs) as primary keys. At first glance, it seems like a great solution.