Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...

Building The SQLSaturday Orlando Marketing Plan-Part 29

Received an email from LinkedIn that the ad was approved and so far we’ve spent a whopping 83 cents! Not...

Building the SQLSaturday Orlando Marketing Plan-Part 28

Today at lunch I looked at LinkedIn advertising. I only capture the last part to share here, but you put...

Reblog: July 25 to July 31

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

Speaker of the Month: August 2014

Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...

Friday Followup For August 1, 2014

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

Website Pulse

Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...

An error occurred while executing batch. Error message is: Arithmetic Overflow

Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...

Log Shipping - Exclusive access could not be obtained because the database is in use

This story began as they almost always do - with a page at 4am local time...

--

'Alert: SQL Failed Jobs on InstanceName...

Please open this page in the Admin panel only

I am taking a slight deviation from the usual type of posts that I share.  This time, I just want to share a quick and easy fix that I...