Iain Kick

Iain Kick is a senior technical consultant at Computacenter for SQL Server. He has more than 10 years of experience working with SQL Server. He blogs at www.iainkick.com.

Articles by Iain Kick
Step-by-Step Approach to Differential Backup and Recovery
DBAs have been reluctant to use differential backups in the past, but it’s a practice that DBAs need to understand and implement as databases grow larger.
Determining How Much Data Has Changed
If you’re not sure whether the data in your database changes a lot or a little, you can use the undocumented (and therefore unsupported) DBCC PAGE command to retrieve information from the differential bitmap page and display it in a readable format. The command’s syntax is:
DBCC PAGE ( {'dbname' | dbid}, filenum,

  pagenum [, printopt={0|1|2|3} ])

IT/Dev Connections

Register now to get the best rate available!

From the Blogs
Man with mustache at computer
Apr 23, 2014
blog

SQL Server Management Studio 2014: Notes from the Field 1

SQL Server Management Studio is a complex application that does a ton of wonderful things and, with SSMS 2014, there are still a couple of quirks or issues that I hope that Microsoft addresses or corrects someday....More
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups 1

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws 2

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×