-->
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.

AD Authentication and Azure SQL Database

Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into issues but once rectified it felt great using AD authentication in Azure rather than just SQL logins. If you look … Continue reading

Read more

1 comments, 92 reads

Posted in All About SQL on 22 May 2017

Setting SQL Server Max Memory Dangerously Low

Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By default it will be the value 2147483647 which is not a random number but the 8th Mersenne prime! In a … Continue reading

Read more

0 comments, 152 reads

Posted in All About SQL on 18 May 2017

Creating Azure Database for MySQL and using Azure Cloud Shell

After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is really easy to build a MySQL database and I have a feeling that this might be the start of an … Continue reading

Read more

1 comments, 144 reads

Posted in All About SQL on 15 May 2017

SQL Server Wait Types Library – UPGRADED!

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding? I was online and noticed a tweet from the main man himself – Paul Randal where he did a blog … Continue reading

Read more

0 comments, 163 reads

Posted in All About SQL on 11 May 2017

Extended Events – I am dangerous (sometimes)

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following … Continue reading

Read more

2 comments, 147 reads

Posted in All About SQL on 9 May 2017

SQL Server Recovering Data via a Hex Editor

I got bored (really bored) one weekend I decided to challenge myself.  I had corruption within a specific table (localised within a page) with no backups handy only an old image of the data files. The challenge being salvage data … Continue reading

Read more

2 comments, 116 reads

Posted in All About SQL on 8 May 2017

Comparing Plans via Query Store

A small but nice little feature I have been using recently can be found within Query Store. Let’s say you have 2 Plan IDs for a query, naturally you want to view the execution plan for the different plans. In … Continue reading

Read more

0 comments, 137 reads

Posted in All About SQL on 4 May 2017

Adaptive Query Processing – Interleaved Execution

A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server vNext https://blobeater.blog/2017/02/03/sql-server-vnext/, more specifically around the Adaptive Query Processing feature. Well, Joe Sack recently blogged about a feature called Interleaved … Continue reading

Read more

0 comments, 189 reads

Posted in All About SQL on 2 May 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, 157 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, 131 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, 146 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, 204 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, 164 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

2 comments, 161 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, 147 reads

Posted in All About SQL on 1 April 2017

Azure – SQL Database Premium RS

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never seen before and I became very intrigued. It is called Premium … Continue reading

Read more

2 comments, 189 reads

Posted in All About SQL on 28 March 2017

SQLBits 2017

I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which is just over a week away. The Data Platform has evolved so much and this is the chance to get … Continue reading

Read more

0 comments, 133 reads

Posted in All About SQL on 27 March 2017

Why did my SQL Server database just go offline?

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff … Continue reading

Read more

0 comments, 231 reads

Posted in All About SQL on 24 March 2017

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading

Read more

5 comments, 238 reads

Posted in All About SQL on 22 March 2017

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading

Read more

1 comments, 156 reads

Posted in All About SQL on 20 March 2017

Older posts