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… Read more
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:
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. Read more
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… Read more
The rough part of the ride started off earlier in the week. A freak spring snowstorm rolled through… Read more
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
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
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
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
- 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.
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
Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:
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.…
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
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
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
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…
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
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
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
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