Months are funny. Unlike other parts of a date, they vary in length:

• The last second of a minute is always 59.
• The last minute of a hour is always 59.
• The last hour of a day is always 23.

But the last day of a month? Well that depends on what month it is. And the year matters too because a leap year means February …

Read More

I am extremely fortunate to have been named a Friend of Redgate for a fifth year!

If you're not familiar with the Friends of Redgate program, we work with the Redgate development and product teams to provide feedback on existing products, new tools, and feature enhancements. You can also find us doing things like …

Read More

SQL Server Mirroring has had a rough time the past few years. It was deprecated in SQL Server 2016, and now it's more or less being replaced by Basic Availability Groups, (which I love to refer to as "BAGS"). Database Mirroring hasn't gone the way of the Dodo yet though. Perhaps it won't be quite so popular …
Read More

I'm so proud to be speaking at SQLBits – Europe's largest SQL Server conference!

It took me several years of abstract submission before I was accepted to speak at PASS Summit. Once I spoke there, I set my sights on presenting internationally. After some more attempts, I now have the amazing opportunity to present in …

Read More

There's a little more than a month to go until SQL Saturday Chicago 2018!

This year we received 137 abstracts submitted by 60 speakers, and we are very pleased to announce our schedule. Thank you to all who submitted!

I hope to see you on Saturday, March 17, 2018, at Benedictine University in Lisle for what will be …

Read More

While programming, I often need to view different parts of a file at the same time. Consider a long stored procedure: the list of parameters is at the top and it may be helpful to reference them when working elsewhere in the code. I could scroll repeatedly between the top of the file and wherever I am working, but that …
Read More

I very recently had the pleasure of being interviewed by Mohammad Darab. He asked some very insightful questions, and I'm so grateful he decided to ask me!

You can read the full interview here.

He also has a very impressive list of interviews on his site. See the entire list here!

Read More

I am very happy to announce pre-conference sessions for SQL Saturday Chicago 2018. We were fortunate to receive many submissions, and after careful deliberation the following were selected.

• Data Security for the Cloud by Ed Leighton-Dick
• Hands-On Power BI: Monitoring your SQL Server Environment by Aaron Nelson …

Read More

It's no secret that Windows 10 likes to forcibly apply updates, and occasionally these forced updates can occur at very inopportune times. I've heard tales of forced updates ruining demonstrations and presentations not only at SQL Saturdays, but also at this year's PASS Summit.

What most people don't seem to realize is …

Read More

I'm very happy to announce that registration is now open for SQL Saturday Chicago 2018! This year we have a new and larger location! Our event will take place at Benedictine University in Lisle, IL on Saturday, March 17, 2018.

If you’re not familiar with SQL Saturday, it’s a free day of training for data professionals, …

Read More