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
Tag: #SQLYog
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
ArithAbort and SQL Agent Failures
A mystery staring arithabort. I was coding along one day, working on rolling out some monitoring for a client—monitoring that
August 5, 2014
Moving Databases to New Drives: A Real-world Case Study Involving 120 Databases
Moving databases is a common enough task for the DBA, and there are multiple ways to move physical database files
July 29, 2014
The DBA is Resurrected
Do a Google search for “the DBA” and one of the top auto-fill results will be “…is dead.” In recent months
July 22, 2014
SQL Go Fast button
When investigating a performance issue, the desired end result is already known… you need to make the queries run faster.
July 15, 2014