Wayne Sheffield

My blog about SQL Server

Browsing Posts in SQL

There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014 (6pm-8pm), and I’m honored to be presenting there for their kickoff meeting. I’ll be presenting “Table Vars & Temp Tables – What you NEED to Know!” Visit http://lynchburg.sqlpass.org/ for more info (abstract, directions) and to […]

I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late September and 6.2 in December ), so I thought I would highlight some of the new features available in it. So lets start off with a table to show the new features and what version […]

I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through the SQL logs showed that the server had restarted earlier that morning, and that this instance is running on a cluster. Assuming that this is probably just a timing issue, I decided to try to […]

I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into it. Things like: It’s a wonderful time of the year. Lot’s of places I’m going to with #sqllearning potential. There’s a lot of resolutions I need to work on. Considering how well I did with […]

Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that I ask when I am the candidate. (Remember that interviews are two way – you are interviewing the company to see if you want to work for them just as much as they are interviewing […]

Now, why in the world would I be asking a question like this? Well, in BOL (BACKUP) is this little blurb: CHECKSUM Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup. This is the default behavior for a […]

I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the history of the job, to see why it failed: Okay, this is interesting. The job did fail, but the only step to run succeeded. Hmm, let me look at what the job is doing: The […]

For those of you that know me, you know that I enjoy learning, and passing on what I have learned to others. As it turns out, this whole presenting thing has been an interesting path for me. (You can read more about the early disastrous presentations in my life here.) As I have started to […]

Sometimes it’s the small things that count. I just noticed two small enhancements to SQL Server 2014′s BOL, and I can tell they are going to make my life easier. How many times have you been developing a script, and you’re trying to make it work with multiple versions of SQL Server? Since I handle […]

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will get an 18456 error. This error is deliberately obfuscated in SQL Server so that the user can’t tell why the error failed (and thus try to crack into the server). All the user will get […]