Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Saturday RVA recap

Wow, what a month. On March 22, 2014, the SQL Saturday train came into Richmond VA (RVA). I was one of the organizers of the event, and what a ride we had.

The rough part of the ride started off earlier in the week. A freak spring snowstorm rolled through… Read more

0 comments, 67 reads

Posted in A Discussion of SQL Server-Related Topics on 28 March 2014

Presenting at the kickoff Lynchburg Va SQL User Group meeting

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… Read more

0 comments, 26 reads

Posted in A Discussion of SQL Server-Related Topics on 17 February 2014

T-SQL Tuesday #51: Is this a bet worth making?

On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known as T-SQL Tuesday and started by Adam Machanic (Blog | @AdamMachanic), this month’s T-SQL Tuesday topic is hosted by friend and fellow MCM Jason Brimhall (@sqlrnnr)… Read more

2 comments, 1,094 reads

Posted in A Discussion of SQL Server-Related Topics on 11 February 2014

SQL Prompt – new features in version 6.x

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… Read more

0 comments, 1,212 reads

Posted in A Discussion of SQL Server-Related Topics on 27 January 2014

Assumptions and clusters – the double whammy

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,… Read more

0 comments, 89 reads

Posted in A Discussion of SQL Server-Related Topics on 20 January 2014

TSQL Tuesday #50 – Automation – Verifying the Backup Chain

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…

Read more

0 comments, 102 reads

Posted in A Discussion of SQL Server-Related Topics on 14 January 2014

Interview Questions – what to ask the company interviewing you

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… Read more

2 comments, 2,789 reads

Posted in A Discussion of SQL Server-Related Topics on 6 January 2014

Are CHECKSUMs being performed with a Compressed Backup?

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

Read more

3 comments, 1,159 reads

Posted in A Discussion of SQL Server-Related Topics on 30 December 2013

T-SQL Tuesday #48 – My take on the cloud

So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday activity – the SQL world-wide blogging party know as T-SQL Tuesday. The brainchild of Adam Machanic, this is an event where for 24 hours, SQL bloggers will blog about a… Read more

0 comments, 124 reads

Posted in A Discussion of SQL Server-Related Topics on 13 November 2013

The Failed Job

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… Read more

2 comments, 942 reads

Posted in A Discussion of SQL Server-Related Topics on 7 November 2013

Murder They Wrote

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 Read more

0 comments, 160 reads

Posted in A Discussion of SQL Server-Related Topics on 6 November 2013

Retiring of the MCM Certifications, Part II

Image acquired from Twitter

In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a Microsoft Connect item that Jen Stirrup started (https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs) to keep the MCM/MCSM/MCA program alive. A few hours after my post, Tim Sneath from Microsoft responded…

Read more

10 comments, 344 reads

Posted in A Discussion of SQL Server-Related Topics on 3 September 2013

Retiring of the MCM Certifications

The MCM is dead. Long live the MCM.

The small, exclusive club of SQL Server Microsoft Certified Masters is going to remain small and exclusive. This club, with less than 200 members world-wide, includes some of the biggest and brightest names in the SQL Server community. And Microsoft has decided… Read more

1 comments, 750 reads

Posted in A Discussion of SQL Server-Related Topics on 31 August 2013

It’s the small things that count

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… Read more

0 comments, 255 reads

Posted in A Discussion of SQL Server-Related Topics on 14 August 2013

T-SQL Tuesday #43 – Plan Operators

This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!). As this month’s host, Rob has selected the topic of this month’s world-wide T-SQL Tuesday blogging party to be about Plan Operators. Specifically, one or more Plan… Read more

2 comments, 969 reads

Posted in A Discussion of SQL Server-Related Topics on 11 June 2013

Getting the lowdown on 18456 errors

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).… Read more

1 comments, 1,242 reads

Posted in A Discussion of SQL Server-Related Topics on 18 April 2013

The Bucket List – Item #1 is (finally) finished

We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the bucket. Perhaps you want to ski the Swiss Alps. Learn a foreign language. Learn to play a musical instrument. Surf the Hawaiian swells. Visit far-away places. Get romanced by… Read more

10 comments, 232 reads

Posted in A Discussion of SQL Server-Related Topics on 16 April 2013

T-SQL Tuesday #41 – Presenting and Loving it!

It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation by selecting the topic, and he would like to know how we came to love presenting. Being the inquisitive type, Bob would like to know things like what was the… Read more

1 comments, 235 reads

Posted in A Discussion of SQL Server-Related Topics on 9 April 2013

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

During… Read more

0 comments, 597 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2013

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

One of the tasks that… Read more

1 comments, 1,793 reads

Posted in A Discussion of SQL Server-Related Topics on 27 February 2013

Older posts