SQL Azure Point-in-Time Restore

SQL Azure Point-in-Time RestoreOCTOBER 26, 2014As a strategic direction, many companies have decided to start moving their SQL Server databases...

Friday Followup For December 5, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

How Functions function

If you are going to use functions first you should understand how functions work as they are often over used...

PASS BI VC recording is available now

The recording of the webinar I did for the PASS BI virtual chapter is live!

(Quick reminder: it was the same...

Reblog: November 28 to December 4

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

Speaker of the Month: November 2014

I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...

SSIS Parent-Child Architecture in Catalog Deployment Mode

This is the third in a series of posts about SSIS parent-child architecture.  You can find the index page here.
In...

Azure SQL Server Database

SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure.  However, if you have...

Book Review – Query Tuning & Optimization

Via Twitter in October Benjamin Nevarez@BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning...

Book Review – Query Tuning & Optimization

Via Twitter in October Benjamin Nevarez @BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning & Optimization” I jumped at this opportunity as...