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

Volunteers Needed For PASS SUMMIT

Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.

Not know what PASS is? head over to the website and check it out. You can also get involved on twitter I love the bio "Connect, Share, Learn". This is in essence what PASS…

Read more

0 comments, 1,027 reads

Posted in SQL Server 365 on 22 January 2014

2013 - The Year of Community Speaking

So, the end of 2013 is upon us and what a year it has been. The SQL Server 365 blog saw the number of site hits double from last year, which I am thrilled with. The biggest personal achievement this year was popping my speaking cherry at the Leeds SQL…

Read more

0 comments, 971 reads

Posted in SQL Server 365 on 31 December 2013

PASS Summit

It's that time of year again, the annual PASS Summit is under way in Charlotte, NC!

For those of you who don't know, PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more than that, it’s your conference –…

Read more

0 comments, 916 reads

Posted in SQL Server 365 on 17 October 2013

Encryption Decryption Routine

In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL Server and just how easy it is to set-up and maintain.  SQL Server encrypts data with a hierarchical encryption and key management infrastructure.  Each layer encrypts the layer below it…

Read more

0 comments, 3,477 reads

Posted in SQL Server 365 on 11 September 2013

Free Tools For The DBA

In this post we will look at 5 free tools that I use on a daily basis, I'll give a little bit of detail about them, why I find them useful and the links for you to download them.

1 - Maintenance Scripts - Ola Hallengren

What can I say…

Read more

0 comments, 950 reads

Posted in SQL Server 365 on 5 September 2013

Bank Holiday Fun - DDL Trigger

Following on from my previous post on triggers, I had made a mental note to make sure I did a post about a DDL trigger I use.  As a DBA I am a gatekeeper to the companies SQL Server estate, I would love to say that every instance is…

Read more

0 comments, 2,314 reads

Posted in SQL Server 365 on 26 August 2013

Trigger Status

Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger?  I know I have and on more than one occasion!  This little script can be added to a SQL Agent Job and scheduled as you require to email an operator with a…

Read more

0 comments, 1,061 reads

Posted in SQL Server 365 on 20 August 2013

Windows Failover Cluster Monitor

Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as a DBA better in so many ways.  Can they though, sometimes be too good?  I have had SQL Server instances failover between cluster nodes in the past that none of…

Read more

0 comments, 2,605 reads

Posted in SQL Server 365 on 9 August 2013

Disaster Recovery - Part 1 - Possibly Almost Everything But the Kit

Over the years I have been fortunate or unfortunate enough, depending on who you are to have experienced several disasters along with a couple of very near misses.  In this post I am going to explore some of the areas of DR that are not related to the physical kit.…

Read more

0 comments, 958 reads

Posted in SQL Server 365 on 26 July 2013

First Time Speaker

So this week was another first for me, I finally bit the bullet and gave a talk at the Leeds SQL Server User Group and it was great, I thoroughly enjoyed it!

Public speaking is something that I have wanted to do for a while now but have put off…

Read more

0 comments, 662 reads

Posted in SQL Server 365 on 25 July 2013

Baseline SQL Server with SQL Sentry Performance Advisor

Baselines can be any set of metrics that have been recorded to give you an understanding of what is the norm.  Having a baseline gives you another piece to the puzzle when troubleshooting performance issues.  It is the “base” that is used as a comparison to highlight areas of performance…

Read more

0 comments, 2,582 reads

Posted in SQL Server 365 on 24 June 2013

Dedicated Administrator Connection (DAC)

We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources that no further connections can be made.  Although extreme and a situation I have never been in there is a saving grace, one last chance before opting for measures that…

Read more

0 comments, 2,785 reads

Posted in SQL Server 365 on 23 May 2013

Object Qualification

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience they do a pretty mediocre job at best and at times can be absolutely horrific.  The issue was that the statements being fired at an instance of SQL Server from…

Read more

0 comments, 2,518 reads

Posted in SQL Server 365 on 15 May 2013

DTA and Hypothetical Indexes

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools menu in Management Studio.  This tool was first introduced in SQL Server 2005 and has been a much used tool by DBA’s and Developers alike in most of the companies…

Read more

1 comments, 7,969 reads

Posted in SQL Server 365 on 9 May 2013

SQL Server Hardware and Acronyms

Over the weekend I finished reading yet another Red Gate book, this one was SQL Server Hardware by Glenn Berry (t - b).  Having earned my crust as a Windows Engineer before honing my SQL Server Skills and becoming a DBA, I have had this book on my…

Read more

0 comments, 817 reads

Posted in SQL Server 365 on 7 May 2013

Index Tuning

This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments.  Using SQL Sentry Performance Advisor I highlighted four or five procedures to start with.  I was able to get a couple of quick wins which was a result, then…

Read more

5 comments, 3,475 reads

Posted in SQL Server 365 on 14 March 2013

Cost Threshold for Parallelism

Parallelism, where to start?  Well let’s start right at the beginning shall we with the question, what is parallelism?  Simply put it is a feature of SQL Server which allows queries to utilize more threads in order to complete quicker.  There are several ways to influence SQL Servers decision whether…

Read more

0 comments, 2,589 reads

Posted in SQL Server 365 on 26 February 2013

Fun with dates

Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it is a long weekend where we camp close to the airfield and get to take in three full days (if you include Friday practice  of utterly breath-taking aerobatic displays from…

Read more

0 comments, 708 reads

Posted in SQL Server 365 on 17 February 2013

T-SQL Gotcha

I came across an interesting issue a few days ago that I thought I would blog about.  The issue is replacing NUL characters from values in SQL Server, more specifically using REPLACE().  Take the below TSQL which runs but will never complete;


Read more

0 comments, 1,386 reads

Posted in SQL Server 365 on 15 February 2013

Script Replication with PowerShell

I promised you some PowerShell scripts this year and this post is the first one.  I can see the value PowerShell can bring, but find it equally frustrating.  I don’t know the syntax very well or all the command lets and personally for 99.9% of my daily tasks I can…

Read more

0 comments, 4,424 reads

Posted in SQL Server 365 on 14 February 2013

Older posts