Editorials

Why Tools Can Help You Do Your Job

Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]

2019-05-18

87 reads

The Impediments to Change

SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]

2019-05-10

215 reads

Blogs

Learning Containers

By

I find that I’m using containers more and more to get things done with...

Bad Idea Cowboy Hat: Using a foreign key to prevent updates

By

When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series...

Inspector V1.4 now available

By

The SQL Installation script can be found here The Inspector sample report has been...

Read the latest Blogs

Forums

Lock Request Timeout period Exceeded Error 1222

By homebrew01

A long running job is doing a SELECT INTO a table, so the table...

Primary Keys

By cbrammer1219

What is a good way to determine which combinations of fields should make up...

Net Earned in Triangles without a Triangular Join?

By Thom A

Something I've been trying to figure today is can I achieve a figure for...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers