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

Using SQL Server Diagnostics (Preview)

I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What is it you are asking? It is an extension to SQL Server Management Studio (SSMS) where it gives you the … Continue reading

Read more

1 comments, 119 reads

Posted in All About SQL on 27 June 2017

Blog Series: Cloud “Fear” Busting

I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working with the cloud (Azure) I have come across 4 main “fears” or “concerns” that stand out in my mind that … Continue reading

Read more

0 comments, 192 reads

Posted in All About SQL on 22 June 2017

SQL Server TDE – Is TempDB Encrypted?

A really quick one today, something that made me think for a minute and I thought it might make others think too. So you have enabled TDE  – Transparent Data Encryption (you can see these previous posts here: https://blobeater.blog/?s=tde&submit=Search) on your SQL … Continue reading

Read more

1 comments, 124 reads

Posted in All About SQL on 19 June 2017

WinDbg and SQL Server Fun

I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx (xxx = numerical value). They are located in the following directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ – sound familiar? Have a … Continue reading

Read more

1 comments, 297 reads

Posted in All About SQL on 14 June 2017

How/Why/What is DevOps?

Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps stories. I am not going into specifics of databases but I am going to write about it more generally. What … Continue reading

Read more

1 comments, 230 reads

Posted in All About SQL on 13 June 2017

Unable To Call Into C Compiler !?

Following on from my previous blog post I mentioned that I had to find a solution to the “unable to call into C compiler” message. This meant that the specific SQL Server database in question (that contained in-memory tables) went … Continue reading

Read more

1 comments, 156 reads

Posted in All About SQL on 7 June 2017

SQL Server – Service Terminated

I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was faced with multiple “service terminated unexpectedly” messages. I thought it would make a decent blog post to share with you … Continue reading

Read more

2 comments, 121 reads

Posted in All About SQL on 5 June 2017

SQL Server Memory Metrics

A very quick post for today, recently I have been working on some code to gather metrics around SQL Server memory, more specifically, how much memory is on your server, your total / target memory and PLE. (If you want … Continue reading

Read more

0 comments, 188 reads

Posted in All About SQL on 2 June 2017

Azure Robots – Index Performance Recommendation

They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made. Naturally I became very interested. Within your database (when in the portal) under operations you may notice something similar to … Continue reading

Read more

2 comments, 197 reads

Posted in All About SQL on 1 June 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

1 comments, 154 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

2 comments, 163 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, 212 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, 225 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, 199 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, 189 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, 143 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, 182 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, 246 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, 190 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, 165 reads

Posted in All About SQL on 25 April 2017

Older posts