SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

SQL Server – Ports used by Database Engine and other SQL Features

Most of us know the default port for SQL Server is 1433, but there are various ports being used by SQL Server...

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

SQL Azure Point-in-Time Restore

SQL Azure Point-in-Time Restore
OCTOBER 26, 2014

As a strategic direction, many companies have decided to start moving their SQL Server databases into the cloud using SQL Azure. This change in...

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