-->
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: November 2016

sqlservr.exe

We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing SQL Server 2008R2 to SQL Server 2012 onwards? Let’s look at 2008R2, I navigate to the BINN folder i.e. Program Files\Microsoft … Continue reading

Read more

1 comments, 534 reads

Posted in All About SQL on 25 November 2016

SQL Server Restore to LSN

For this post I want to show you how I recovered to a LSN where I did do this on a server where I wanted to go back to a time just before a delete occurred. This is my setup. … Continue reading

Read more

1 comments, 455 reads

Posted in All About SQL on 24 November 2016

Task Manager is a liar

I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try and understand how much memory SQL Server is consuming. Why? Well it has the ability to lie, and as you … Continue reading

Read more

3 comments, 390 reads

Posted in All About SQL on 21 November 2016

CHECKDB’s Hidden Snapshot

I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the database snapshot that is used to get to a transactionally-consistent point-in-time is no longer hidden. To understand the behavior prior … Continue reading

Read more

1 comments, 314 reads

Posted in All About SQL on 10 November 2016

SQL Server – RECONFIGURE

When you want to change configuration settings for your SQL Server you would either do it via Management studio (under server properties) or via TSQL calling on sp_configure. For example, I usually change the cost threshold for parallelism from the … Continue reading

Read more

3 comments, 465 reads

Posted in All About SQL on 8 November 2016

Copying your SQL Database

If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the same server I will show you how via a quick method. When connected to your master database execute the following: … Continue reading

Read more

1 comments, 275 reads

Posted in All About SQL on 7 November 2016

Always Encrypted Column Encryption

I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature essentially uses a column encryption key that is used to encrypt data in an encrypted column and a column master key … Continue reading

Read more

2 comments, 369 reads

Posted in All About SQL on 4 November 2016

SQL Server Backup Compression

I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU on my SQL Server when I have backup compression on vs off against my 35GB database. No compression I will … Continue reading

Read more

3 comments, 326 reads

Posted in All About SQL on 3 November 2016

SQL Server DMA v2.0 – Migration Time

In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This time let’s do an actual migration from SQL 2008R2 to SQL 2014. I created a new migration project as … Continue reading

Read more

1 comments, 361 reads

Posted in All About SQL on 2 November 2016

SQL Server DMA – Data Migration Assistant V2.0

One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools being the DMA – Data Migration Assistant (Version 2). It “enables you to upgrade to a modern data platform by … Continue reading

Read more

2 comments, 377 reads

Posted in All About SQL on 1 November 2016