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

SSMS Presenter Mode

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended for production use. There are many enhancements which you can read here: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms-release-candidate but there is one feature I … Continue reading

Read more

1 comments, 264 reads

Posted in All About SQL on 22 February 2017

SQL Server vNext: sys.dm_db_stats_histogram

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack … Continue reading

Read more

1 comments, 196 reads

Posted in All About SQL on 21 February 2017

Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to off-load to Azure.  For this post I will be going through the … Continue reading

Read more

2 comments, 209 reads

Posted in All About SQL on 20 February 2017

True story: Encryption in progress stuck

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library/bb677274.aspx) My … Continue reading

Read more

1 comments, 204 reads

Posted in All About SQL on 16 February 2017

Azure Advisor Recommendations

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features in preview mode. With that being said Azure Advisor Recommendations is what I will be writing about today. What is … Continue reading

Read more

1 comments, 188 reads

Posted in All About SQL on 15 February 2017

Lightweight Statistics Profiling (with a potential bug)

The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading

Read more

3 comments, 256 reads

Posted in All About SQL on 13 February 2017

Using Extended Events in Azure

Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the Azure … Continue reading

Read more

2 comments, 882 reads

Posted in All About SQL on 6 February 2017

SQL Server vNext

I have been pretty busy recently working with Joe Sack from Microsoft and  getting my hands dirty with SQL Server vNext accessing some cool stuff (which obviously I can’t talk about – under NDA) and believe me it is pretty … Continue reading

Read more

4 comments, 512 reads

Posted in All About SQL on 3 February 2017

Compare Execution Plans

Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the software (SQL 2016 onward https://msdn.microsoft.com/en-us/library/mt238290.aspx) you can. Lets dive in. Once you have an execution plan ready right click on it … Continue reading

Read more

0 comments, 281 reads

Posted in All About SQL on 2 February 2017

My backup and SLEEP_BPOOL_FLUSH

I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more specifically Physical disk:Avg sec/read(orange/yellow line) and Physical disk:Avg sec/write(blue line), yes it was very busy, much busier than normal. Waits … Continue reading

Read more

1 comments, 222 reads

Posted in All About SQL on 1 February 2017