SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2016

SQL Agent Job Schedules

Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You can read all about that here.

In a very similar fashion, today I want to share how easy it is to turn the internal schedules for SQL Agent jobs… Read more

2 comments, 2,458 reads

Posted in SQL RNNR on 29 March 2016

Index Cannot Be Reorganized…

Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview.

As a part of this maintenance you have scripted solutions to intelligently manage and maintain the fragmentation levels for each of the indexes within each database on each instance. Read more

0 comments, 513 reads

Posted in SQL RNNR on 16 March 2016

The Virginia Tour 2016

Long Time Coming

With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.

This is not just a one day event for me. No no! I will be presenting for three consecutive days on many things SQL Server related. The Virginia… Read more

0 comments, 504 reads

Posted in SQL RNNR on 11 March 2016

SQL Server Locks – Back to Basics

Prelude in SQL Minor

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more

0 comments, 3,207 reads

Posted in SQL RNNR on 1 March 2016