Search Results for “mirroring”

  1. Home
  2. Search Results
  3. (Page 4)

An Expensive Reason To Avoid AGs In Azure

Cash Rules Most people, when they get through paying for Azure, and SQL Server Enterprise Licensing, are left with a hole in their wallet that could only be filled with something that says “Bugatti”, and has a speedometer with an infinity sign at the end. Recently, while working with a client, I found out that…
Read More

What If Week: What Would You Add?

SQL Server
20 Comments
For this week’s What If series, we’re exploring what would happen if you had access to SQL Server’s source code – like if you got a job at Microsoft, signed a partner NDA, if the code leaked, or if it went open source. Today’s question is, “What would you fix or add?” Erik says: Skipping…
Read More

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

SQL Server, Videos
0
This week, Brent, Erik, Tara, and Richie discuss SQL Server performance monitoring, ASYNC_IO_COMPLETION, AWS SQL Server licensing and fees, rebuilding indexes, licensing model for Blitz scripts, stored procedures, using (or not using) primary key on a table, choosing ORMs and other tools, and more. Here’s the video on YouTube: You can register to attend next week’s Office…
Read More

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

This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and what DBA topics they struggle with the most. Here’s the video on YouTube: You can register to attend next week’s Office…
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
Erik Darling blogs kCura Relativity

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

In our Faux PaaS project, we need a backup plan – or rather, a restore plan. On each SQL Server instance, clients can create as many databases as they want, anytime they want, with no human intervention. We need those databases covered by disaster recovery as quickly as practical. SQL Server’s newer disaster recovery options – Always On Availability Groups and…
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
Pocket Square

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

This week, Brent and Richie discuss sp_Blitz Backups, change history tracking, exams and certifications, using Azure for DR-only, which version of SQL server to use for a new DB, adding additional data files, load balancing, trace flag 2371, dealing with reporting services, and much more. Here’s the video on YouTube: You can register to attend next week’s…
Read More

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

SQL Server, Videos
0
This week, Brent, Tara, Richie, and Erik discuss SQL Server 2017 CTP 2, quorum configuration for a 4-node availability group, database sharding, premature optimization, parameter sniffing, tracking query plans within cursors, and what’s coming up in the new version of Paste The Plan. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…
Read More
Menu