SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

Views and Simplification

I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...

Weekly Roundup–SQL Server and Related News

Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on...

#SQLNewBlogger–Adding Local Accounts

 
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...

Complex/Conditional ORDER BYs

Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....

Don't Use Delimiters In Your Object Names!

It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...

Locking sa

When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...

Monday Morning SQL Break – April 4, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...