Search Results for “log shipping”

  1. Home
  2. Search Results
  3. (Page 4)
Office Hours Podcast

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

Videos
0
This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper management, differential backups in AlwaysOn Availability environment, replication, Troubleshooting THREADPOOL Waits, an acceptable amount of preemptive waits, Postgres, and the technologies Richie is working with these days. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…
Read More
Failover Clustered Instances

[Video] Office Hours 2018/4/11 (With Transcriptions) with Special Guest Edwin M Sarmiento

This week @EdwinMSarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-premises server to Amazon’s RDS, AlwaysON Availability Groups, auto-growth issues, rebuilding vs dropping/re-creating indexes, log shipping, using Service Broker with Always On Availability Groups, updating stats issues, VLF counts, measuring transaction log usage, upgrading versions, and much more.…
Read More

[Video] Office Hours 2018/4/4 with Special Guest Pinal Dave

Videos
0
This week, Pinal Dave joins Brent, Tara, and Richie to discuss replication latency, partitioning tables, transactional replication, troubleshooting 3-rd party application performance, SQL ConstantCare® update, SQL Server errors, copying data over from a database with read-only access, reducing blocking timeouts, backups to the cloud, and more replication questions! Here’s the video on YouTube: You can…
Read More

[Video] Office Hours 2018/3/21 (With Transcriptions)

This week, Brent, Erik, and Richie discuss replication, SQL Source Control with Git, installing service packs in cumulative updates in SQL Server, query tuning, write errors, log backups, Azure-managed instances, 3-rd party backup software, and DBA porn. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to…
Read More

2.4 How to Fix Blocking Waits (LCK%)

In the blocking, locking, and deadlocking modules in Mastering Index Tuning and Mastering Query Tuning, I covered how to fix those problems with index & query changes. Another solution is to make database-level changes like the default isolation level or offloading reads to another server with techniques like log shipping, replication, or Availability Groups.

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
Read More

[Video] Office Hours 2018/1/17 (With Transcriptions)

This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, stringing multiple CTEs, Meltdown and Spectre, instance stacking, organizing DBA teams, DBCC checks, moving local databases to Amazon RDS, CTEs vs temp tables, and backups and restores. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More
Office Hours Podcast

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

SQL Server, Videos
0
This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. 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/12/20 (With Transcriptions)

Videos
0
This week Brent, Erik, and Richie discuss truncating & repopulating, failed logins, their choice for high availability, PowerBI, read committed isolation, parameter sniffing, database mirroring, extended events and failing queries and re-indexing large tables. 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

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

Videos
1 Comment
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…
Read More
Pocket Square

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

Videos
2 Comments
This week Brent, Erik, and Richie discuss filestream waits, what to use instead of filestream, Availability Groups & clusters, implicit data conversion, using snapshot backups, MERGE statement bugs, deadlocks, the future of on-prem servers, Erik’s new sp_Blitz lock, and if the SQL Server knowledge base “Virtual Assistant” can answer DBA interview questions. Here’s the video…
Read More

Running SQL Server in the Cloud: 2017 Edition

Cloud Computing
25 Comments
You have two basic options: Infrastructure as a Service (IaaS) is just VMs running in someone else’s data center – be it Amazon, Google, or Microsoft. Job duties for a DBA are the same as on-premises virtual machines: you manage HA, DR, patching, backups, and performance tuning. It’s just that you may have slightly different…
Read More

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

Videos
4 Comments
This week, Richie and Tara discuss Richie’s current projects, Availability Groups, offloading reads and backups, applying service packs, whether production should ship agent jobs to production recovery server, security checks and scans in SQL Server, CPU performance issues upgrading to SQL Server 2016 and 2017, database backups and restores, whether there’s currently a DBA shortage,…
Read More

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

Videos
0
This week, Brent, Erik, and Richie discuss the new Extended Events Profiler, using SQL audit vs a trigger to log what people do, log shipping, migrating from on-prem to cloud, best practice for a database owner, SQL Server performance improvement, the difference between simple, bulk-logged, and full recovery models and when to use them, tools…
Read More
Menu