SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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.
The Strategic Role of the DBA
I’m the non-technical marketing guy at SSG. In order to help the team actually market our services, I’ve had to educate myself a little…okay, a
How to improve SQL Server’s IO performance by up to 40%
In my last article, I started off talking about checking various settings that make a performance difference prior to jumping into query tuning. This article