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

Talking of checkpoint

I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine and how to confirm if SQL Server starts to checkpoint the databases on the server – obviously it makes sense … Continue reading

Read more

1 comments, 63 reads

Posted in All About SQL on 25 August 2016

Do YOU Checksum?

I am going to show you why you should be using checksum options on your backups (and restores). I AM ACTUALLY NOT GOING TO WRITE THE CODE TO FORCE THIS CORRUPTION. I am starting to feel bad spreading/writing about the … Continue reading

Read more

0 comments, 65 reads

Posted in All About SQL on 11 August 2016

Fix that page

I am in a fix-it mood so for this blog I am going to corrupt a page and then show you how to recover it using a page restore. So let’s begin. This is a very basic setup just to … Continue reading

Read more

0 comments, 75 reads

Posted in All About SQL on 5 August 2016

Undocumented Commands

There isn’t really a need to do what I am doing in this blog post but I guess one reason for this is if you want to manufacture some sort of “targeted” corruption for a demo – here I will … Continue reading

Read more

1 comments, 79 reads

Posted in All About SQL on 3 August 2016

Migrating SQL Server to Azure

There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show you how to import a BACPAC file and create a new Azure SQL Database, which is Microsoft’s Platform as a … Continue reading

Read more

0 comments, 69 reads

Posted in All About SQL on 2 August 2016