Search Results for “failover cluster”

  1. Home
  2. Search Results
  3. (Page 3)
Pocket Square

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

This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query tuning, deadlocks, drawbacks of RCSI, triggers, replication, Always On Availability Groups, and forest fires. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on…
Read More

[Video] Office Hours 2017/06/28 (With Transcriptions)

This week, Erik, Tara, and Richie discuss performance and load testing tools, sysadmin update SQL server restart, defragmenting column store indexes, Amazon Redshift, installing Microsoft updates, Always On Availability Groups, Redgate SQL Clone, as well as their thoughts on the current DBA job market. Here’s the video on YouTube: You can register to attend next week’s Office…
Read More
Pocket Square

[Video] Office Hours 2017/06/21 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss cross-database transactions in AGs, agent job owners, column store indexes, linked servers, migrating SQL Server databases to AWS cloud, synchronous readable secondary, rebuilding indexes, backups using SANs, licensing, Always On Availability Groups on CDC, Azure Cosmo DB, compression, and encryption. Here’s the video on YouTube: You can…
Read More

New Class: Always On Availability Groups: The Senior DBA’s Field Guide

Availability Groups are all the rage right now, especially since they’re included with SQL Server 2016 Standard Edition. Our Availability Groups blog post category is one of the most popular on the site, and in my 4-day Senior DBA class, people have always been asking for more in-depth coverage of clustering and AGs. Let’s get together for a…
Read More

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

This week, Tara and Richie discuss increasing the size of tempdb, splitting database across several files, tracking DML changes to a table, upgrading different versions of service packs, recommendations for improving T-SQL skills, trace flags, replication, Always On Availability Groups, compatibility level of databases,  and more… Here’s the video on YouTube: You can register to…
Read More

[Video] Office Hours 2017/03/26 (With Transcriptions)

This week, Erik and Richie discuss truncating log files, reindexing, using sp_rename, query tuning, columnstore indexes, debugging parameter sniffing issues, query processing internals, and troubleshooting query performance issues. 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…
Read More

[Video] Office Hours 2017/03/08 (With Transcriptions)

This week, Erik and Richie discuss creating/updating statistics, tools for viewing large flat file tables, the worst code they have ever seen, high disk queue length, dealing with databases that store blobs, reindexing jobs, transparent data encryption, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…
Read More

[Video] Office Hours 2017/03/01 (With Transcriptions)

This week, Brent and Tara discuss Always On failure scenarios, partitioning without consulting vendors, multi-subnet clustering with AGs, licensing, long running queries, replication, improving index maintenance, avoiding deadlocks, index space usage, and much 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…
Read More
Pocket Square

[Video] Office Hours 2017/02/08 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss compatibility levels, SQL server SPN problems, Always On Availability Groups, failover clustering, capturing DML stuff, disc defragmentation, replication snapshots and reindexing, load testing, PowerShell, and whether you should pursue the path of a DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or…
Read More

[Video] Office Hours 2017/02/1 (With Transcriptions)

This week, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, why servers “page wildly” when copying mid to large-size files from one SQL server to another, their favorite high availability solutions, and much more! Here’s the video on YouTube: You can register to attend next week’s Office…
Read More

[Video] Office Hours 2017/01/18 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss sp_Blitz capabilities, what’s best to use for resolving SQL performance issues, CDC, tools for capturing wait stats, their favorite monitoring tools, temp tables vs table variables, partitioning with constraints, and whether you should get any certifications. Here’s the video on YouTube: You can register to attend next week’s Office…
Read More

Build Me A Build: What’s Your Hardware Budget?

Hardware
51 Comments
UPDATED 12/15/2016 Spending Brent’s Money Reason number infinity spacetime + 1000 why working here rules is having a generous annual tax writeoff hardware budget. The first time around, I basically blew it all on working from home essentials. This time around I’m building a cool toy: a big beefy desktop. Why, in the age of…
Read More

[Video] Office Hours 2016/11/16 (With Transcriptions)

This week Richie, Tara, and Erik discuss replication, mirroring, memory grants, sp_BlitzCache, failover cluster instances, VLFs, restoring databases, qualifying schema and object names, multiple instances, and table variables. 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…
Read More

[Video] Office Hours 2016/10/19 (With Transcriptions)

This week, Brent (and only Brent) answers your questions about table partitioning, best practices for VMware configuration, rebuilding indexes, transitioning from physical SQL failover cluster to VMware or Hyper-V, database backups, security issues with cross-database chaining, and why you should never use vague adjectives when describing database sizes. Here’s the video on YouTube: You can…
Read More

Updated First Responder Kit: sp_Blitz markdown output, sp_BlitzIndex statistics checks

In addition to lots of bug fixes and tweaks, my favorite option is: sp_Blitz @OutputType = ‘markdown’ sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1, @CheckUserDatabaseObjects = 1 See, recently I’ve spent a lot of time looking at Stack questions going, “Man, if I just had the output of sp_Blitz, I bet I could answer that question…
Read More

[Video] Office Hours 2016/09/28 (With Transcriptions)

This week, Brent, Richie, Tara, and Erik, discuss non-clustered indexes, dynamic SQL, replication, setups for servers dedicated to reporting services and warehouse databases, cross-cluster migrations, employment opportunities in the current market, and much, much 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…
Read More
Tara Kizer

Asynchronous Database Mirroring vs. Asynchronous Availability Groups

When Database Mirroring came out in SQL Server 2005 Service Pack 1, we quickly dropped Log Shipping as our Disaster Recovery solution. Log Shipping is a good feature, but I can failover with Asynchronous Database Mirroring faster than I can with Log Shipping. When Always On Availability Groups (AG) came out in SQL Server 2012,…
Read More
Menu