What the FK? Your Foreign Keys May Not Be Performing Like They Should
Query Optimizer Tips and Tricks Part 2 This is the second installment in a continuing series of articles on
November 4, 2014
Tag: #SQLYog
Dodging Phantom Reads
October… the month of Halloween. Spooky events. SQL Server has all kinds of Halloween-ish themed activities like Split Brains, Zombies,
October 29, 2014
Database Ghost Records
Yes Virginia, there are ghosts in your database. More specifically, there are SQL Server database ghost records. They are not
October 15, 2014
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
October 8, 2014
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
October 1, 2014
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
September 23, 2014
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,
September 2, 2014
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
August 26, 2014
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
August 19, 2014
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
August 12, 2014