Search Results for &#8220;failover cluster&#8221;

The biggest problem with parameter sniffing isn’t that SQL Server can produce different plans. The real problem is that the plans change unexpectedly, seemingly out of nowhere, with. no advanced warning. However, armed with an understanding of what triggers plans to be evicted from the cache, you can start to predict when these emergencies will…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Fundamentals of Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access or Fundamentals of Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access, or log in if you already shelled out the cash.

DBA Training Plan 21: Building a New SQL Server

Last Updated September 18, 2019

DBA Training Plan, High Availability

I have a secret setup checklist. Oh sure, our free First Responder Kit has a SQL Server setup checklist that walks you through a few things you need to do before you install, plus a few things to do immediately afterwards. That’s good. It’s actually pretty darned good. But it’s not the secret checklist. Gather round and cover your…

Server Power Changed

Last Updated August 26, 2019

“This server is powered by an Etch-a-Sketch, what?” In SQL ConstantCare®, we keep an eye on how much power your SQL Server has: how many CPU cores it has, and how much memory it has. When those numbers change, we alert you because – well, sometimes it’s a good thing, and sometimes it’s a bad…

Why That “DBA” Job Posting Sounds So Terrible

Last Updated June 2, 2019

Professional Development

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or equivalent experience. Experience running and maintaining a 24×7 production computing environment Hands-on experience…

What’s New in SQL Server 2019: 100% Demos

Last Updated December 5, 2019

Want to learn more? Check out my recent SQL Server 2019 posts. You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as…

[Video] Office Hours 2018/12/5 (With Transcriptions)

Last Updated December 8, 2018

This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading server hardware, agent jobs, setting SQL Memory Min and Max to the same value, how to prove CPU pressure to management using the Power BI report using sp_Blitz, corruption, patching, backups, sargability, and more. Here’s…

[Video] Office Hours 2018/10/10 (With Transcriptions)

Last Updated October 12, 2018

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is currently teaching at the client location, SQL Server in containers, heap index maintenance, contained databases, extended events, the difference between a junior and Senior DBA, page file sizing, and more. Here’s the video on YouTube:…

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Last Updated September 24, 2018

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

[Video] Office Hours 2018/7/25 (With Transcriptions)

Last Updated July 28, 2018

This week, Erik and Richie discuss whether it’s relevant to specify data in logs in SQL cloud environment, licensing, using canary tables on Availability Groups, how Entity Framework limits tuning, reusing older databases, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on…

[Video] Office Hours 2018/5/30 (With Transcriptions)

Last Updated June 2, 2018

This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move databases from SQL 2008 R2 to SQL Server 2014, adding Analysis services to a cluster, taking to higher management, deadlocks in a transaction log shipping setup, syncing date between an on-prem and Azure SQL DB server, log backups, renaming…

Building SQL ConstantCare®: The Database

Last Updated December 7, 2019

SQL ConstantCare

I bet, dear reader, that this is the post you’ve been really curious about in my behind-the-scenes posts. Back in the post about the data we collect, you may remember that our initial goal was to analyze high-priority issues like missing backups or corruption check, priority boost on, offline NUMA nodes, etc. To do that,…

Azure SQL Managed Instances and Database Corruption

Last Updated March 18, 2018

Backup and Recovery, Managed Instances

Disclaimer: I love Azure SQL Managed Instances (MIs) so far. They’re really cool, and I’m having a fun time playing with them. I’m about to describe a bug, and I’m sure this bug will be fixed soon, so it shouldn’t stop you from previewing Managed Instances. This post is not “MIs are t3h suxxors” –…

[Video] Office Hours 2017/12/13 (With Transcriptions)

Last Updated December 16, 2017

This week Tara, Erik, and Richie discuss virtualization, replication & mirroring, switching SQL service logins to an AD account, temporal tables, tempdb issues, migrating from SQL 2015, and Richie’s outdoor adventures in “Breath of the Wild.” Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen…

[Video] Office Hours 2017/10/4 (With Transcriptions)

Last Updated October 7, 2017

SQL Server, Videos

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shipping, and their next company retreat location. Here’s the video on YouTube: You can…

[Video] Office Hours 2017/09/13 (With Transcriptions)

Last Updated October 7, 2017

SQL Server, Videos

Note: this is coming to you from the past due to technical difficulties. This week, Brent and Erik discuss Availability Group issues, database diagram tools, AWS vs Azure, diagnosing async io waits, troubleshooting deadlocks, extended events, using same login credentials for everyone in the company, adjusting and more. Here’s the video on YouTube: You can…

New sys.messages Entries in SQL Server 2017

Last Updated October 2, 2017

SQL Server 2017

I’m only showing the English (1033) ones here, message ID and then text. Some of the new messages are very Azure-specific, and while I love to think that we’d get some of these features in the boxed product, I think Microsoft is just getting down to a standard shared list of message IDs. However, some…

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Last Updated July 26, 2017

CHECKDB and Corruption

So far in this series, I’ve shown you how to corrupt a clustered index, then how nonclustered indexes can be corrupted independently. If you haven’t read those, you should start there first. Let’s start again with our 50Ways database, but this time we’re going to be good and make sure that we’ve got checksums enabled,…

[Video] Office Hours 2017/07/19 (With Transcriptions)

Last Updated July 23, 2017

SQL Server, Videos

This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, and more… Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss an episode, subscribe…

Corruption 2: DBCC CHECKDB for VLDBs

Last Updated March 11, 2021