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

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Archives: April 2017

SQLBits Review

I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find it useful (even though it was 2 weeks ago!) To start with I always wanted to go to a SQLBits … Continue reading

Read more

2 comments, 259 reads

Posted in All About SQL on 26 April 2017

Redgate: SQL Search

I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially when your environment has thousands of objects. Upon some research I found a Redgate tool that is free called SQL … Continue reading

Read more

0 comments, 242 reads

Posted in All About SQL on 25 April 2017

I Escaped from a SQL Server Service Pack Nightmare

I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade,  if not you might want to reconsider. Initially I wasn’t going to capture the screen shots during this recovery because my … Continue reading

Read more

2 comments, 229 reads

Posted in All About SQL on 24 April 2017

Getting intimate with Brent Ozar (The First Responder Kit)

Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL Server databases and it is a battle just to keep the lights on.  If this sounds like you then you … Continue reading

Read more

4 comments, 286 reads

Posted in All About SQL on 12 April 2017

Microsoft Data Platform is changing – so am I

This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever changing times within our technology space. Personally I love this new era of cloud computing and do not feel threatened … Continue reading

Read more

0 comments, 221 reads

Posted in All About SQL on 11 April 2017

Azure: SQL Database Elastic Pool and using Elastic Jobs

I want to show you how I went from having multiple single SQL databases in Azure to a database elastic pool within a new dedicated SQL Server. Once setup I create and use elastic jobs. This post is long but … Continue reading

Read more

3 comments, 266 reads

Posted in All About SQL on 4 April 2017

SQL Server DBCC CHECKDB

A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot is no longer hidden then finally how I check that DBCC CHECKDB has ran successfully. Hopefully you find it useful.Filed … Continue reading

Read more

0 comments, 225 reads

Posted in All About SQL on 1 April 2017