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...

How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75

 
When you do  SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...

How Functions function

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

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...

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...

Video – Identifying large queries using Extended Events

A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...

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...

SQL in the City 2014 – Washington DC

I’m off today, traveling to SQL in the City 2014 – Washington DC to meet Grant and deliver another database delivery...

Deciding On a Presentation Topic for 2015

I’m spending some time this week and the next few weeks thinking about what I want to talk about next...