Capture the Flag – Trace Flags
One of the things that would be nice to know is around the trace flags that can be enabled in
November 11, 2014
Tag: #SQLServeronLinux
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
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