Wayne Sheffield

My blog about SQL Server

Browsing Posts in SQL

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev Nambi (blog | twitter) is hosting the party, and he has decided that the topic is to be on Assumptions. Specifically, he wants us to write about: A big assumption you encounter at work, one […]

You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means that the mirroring configuration includes having a witness server to ensure that the system can automatically switch over to the partner in the event of a failure of the principal. Under this scenario, if the […]

After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error occurred:  A required privilege is not held by the client.” when trying to start the service. Examining http://msdn.microsoft.com/en-us/library/ms175371.aspx shows that the only security privilege needed for the SSAS service account is the “Log on as […]

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 […]