Check out our new quiz. Quiz #3: How well do you know security best practices? In case you missed any of our previous quizzes, they can all be found here: All Quizzes.
Year: 2017
SQLBP Monthly #2
Our second issue of our newsletter was delayed due to technical issues. MailChimp support was able to root out the problem this morning, and the newsletter has gone out.. You can view it online and learn more about our featured blogger Nic Cain (@SirSQL). 🎃 SQL Server Best Practices Monthly 👻 Don’t miss out on…
5 Tips for Friday: Availability Groups
It’s Friday again and time for another set of tips. It’s 5 Tips for Friday! This week I want to give you some best practices for managing and administering Availability Groups. Don’t skip past quorum: How always on your Always On* solution is often depends on how you have configured quorum. Quorum is often overlooked,…
The Alpha and the Omega. The BEGIN and the END.
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do a little review. Not to mention that there are always people just starting to learn about a subject. So what is a BEGIN/END block? They are boundaries that define a group of SQL statements. Transact-SQL…
5 Tips for Friday: Upgrades and Migrations
It’s Friday, and I’m out of town on vacation in historic Williamsburg, VA (if any burglars are reading this, I forgot to feed the 5 rabid Rottweilers that I’m fostering so feel free to stop by and visit them). What does that have to do with upgrades and migrations? Nothing. Just making conversation, but that…
I’m the new DBA, and I’m locking down development servers
Many times, I’ve started with a company as one of their first, if not the first DBA. They’ve acquired enough servers now, with enough data moving around, that they just can’t continue as they are. There’s no shortage of developers to can write stored procedures or SSIS packages, or to write a new page for…
5 Tips for Friday: Transaction Log
For this week’s 5 Tips for Friday, I want to talk about some best practices for the transaction log. The transaction log in SQL Server is a critical component of a database, and it can affect performance and recoverability of the database. It warrants special care and maintenance. Back it up often: The goal with…
Do what I say, not what I do
You’ll hear a lot of rules and best practices from senior IT people (not just data folks, all of them). You’ll also then see those same people do what they told you not to. I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, even…
5 Tips for Friday: Query Tuning
Time for another 5 Tips for Friday. Truth be told, I almost forgot that it was Friday so this week’s post is coming late int he day. This week’s fast, fun tips are all about tuning queries. Look at current waits, not total waits: I see it asked time and time again in the forums…
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual SQL Servers – Right to Ludicrous Speed” has a few open slots for this Tuesday session. This topic is near and dear to my heart, and I’m thrilled to be able to present to the…