SQL Server

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

SQL Server, Videos
0
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…
Read More

sp_AllNightLog: Poll Vaulting

Carry on It turns out that the only thing harder than checking for new databases restored to a SQL Server, is checking a folder for a backup of a database that doesn’t exist on another SQL Server. These are both part of what sp_AllNightLog has to do. The other components, which use workers and a…
Read More

SQL Server 2017 Release Date: October 19, 2017?

SQL Server 2017
5 Comments
Eagle-eyed @NikoNeugebauer (who you should definitely be following on Twitter) noticed something interesting in one of Lenovo’s recent TPC-H benchmark results. In the #TPCH document, the availability of the system with #SQLServer 2017 is listed for 19th of October 2017 🙂https://t.co/Y3VNQt9buZ — Niko Neugebauer (@NikoNeugebauer) July 18, 2017 The benchmark PDF shows: Possible SQL Server 2017 release…
Read More
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/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
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/05/17 (With Transcriptions)

This week, Erik, Tara, and Richie discuss enforcing password expiration for SA logins, keeping things in sync between servers, development/prototyping missions of on-premise vs. cloud, ways of backing up 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 the go. Enjoy…
Read More
Menu