-->
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: May 2017

Find when your SQL Server database grew

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it. I went down the extended events route using sqlserver.database_file_size_change event. By the way … Continue reading

Read more

2 comments, 216 reads

Posted in All About SQL on 25 May 2017

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

3 comments, 270 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, 287 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, 278 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, 248 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, 245 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, 203 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, 222 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, 302 reads

Posted in All About SQL on 2 May 2017