Steve Jones

Sweeping Up The Slackers

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.

5 (1)


5,062 reads


Did you know we have another SQL Server book coming out?


SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

SQLpassion Online Training about Intelligent Query Processing


(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs


Is a durable key always necessary in a dim?

By imani_technology

I want to use a Type 2 SCD SSIS transform on a dimension table...

Unable to shrink the log file


I have this on going issue where the log file of one of the...

Generating factsheet for system installation

By shp.shftr

Hello there, I've come to quite a frustrating decision. Up until now used a...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers