SQL Server

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: Office Hours Webcast - 2017/07/19Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the…

sp_AllNightLog: Poll Vaulting

Last Updated July 12, 2017

Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Log Shipping, SQL Server

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…

SQL Server 2017 Release Date: October 19, 2017?

Last Updated September 25, 2017

Brent Ozar

SQL Server 2017

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…

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

Last Updated July 17, 2017

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: Office Hours Webcast - 2017/07/12Watch this video on YouTube You can register to attend next week’s Office…

Sliding Scale Parallelism: Why Stop At DOP?

Last Updated July 7, 2017

SQL Server

This is a thought experiment Just fair warning, you’re probably not going to learn anything new here. This also isn’t hidden in a CTP of SQL Server 2017, and as far as I know, it’s not a consideration outside of this post. Seriously, lawyers, I know nothing. I was just thinking (while sober, mind you),…

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

Last Updated July 11, 2017

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: Office Hours Webcast - 2017/07/05Watch this…

A Better Way To Select Star

Last Updated November 20, 2018

Development, Execution Plans, Indexing, SQL Server

Mindless Self Promotion I liked writing this blog post so much that I wrote an entire presentation on it. If you’d like to see it at GroupBy, click the link and vote. Update: You can watch the video for this session here. Much has been written about this It’s probably one of the lowest hanging…

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

Last Updated July 2, 2017

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: Office Hours Webcast - 2017/06/28Watch this…

Why Is Tracking Restores So Hard?

Last Updated June 21, 2017

Backup and Recovery, SQL Server

Phantom of the Nopera Let’s say you have a server. Let’s go one step further and say SQL Server is running on it. Crazy, I know. But hey, we specialize in crazy, here. If you want to track CREATE, ALTER, or DROP DATABASE commands, that’s easy enough with DDL triggers. But guess what? None of…

There’s Something Funny About Variable Assignment

Last Updated June 21, 2017

Humor, SQL Server

Guess who I’m going to give you three queries, and you have to guess what the output will be before you run them. Here they are: Transact-SQL DECLARE @DatabaseName NVARCHAR(256) = N'' SELECT @DatabaseName = d.name FROM sys.databases d WHERE d.name = 'master' AND compatibility_level = 130 ORDER BY d.database_id PRINT @DatabaseName SELECT @DatabaseName =…

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

Last Updated June 25, 2017

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: Office Hours…

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

Last Updated June 19, 2017

This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent’s pre-con for this year’s PASS Summit, and more. Here’s the video on YouTube: Office Hours Webcast - 2017/06/14Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe…

Query Plans: Trivial Optimization vs Simple Parameterization

Last Updated June 16, 2017

Execution Plans, Indexing, SQL Server

Facemaking You know when you think you know something, and the obviousness of it makes you all the more confident that you know it? That’s usually the first sign that there’s a giant gotcha waiting for you. And that’s what happened to me over the weekend. The setup I answered a question. And after I…

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

Last Updated June 11, 2017

This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and learning Azure and AWS. The audio’s kinda rough this week because Brent & Erik were…

Hyper-V: Getting Your Host And Guest Connected

Last Updated June 3, 2017

SQL Server, Virtualization

Because I always forget stuff like this I have a confession to make, dear readers: I am a horrible VM admin. I’m also not great at networking. When I go to set up a VM to do something like install SQL vNext, I want to be able to talk to it. Why bother? Well, SSMS…

Automated Tuning And The Future Of Performance Tuners

Last Updated June 7, 2017

Consulting, SQL Server

Before you get too excited This isn’t a dive into any of the new automated tuning features of SQL Server 2017. I’m interested in them because Microsoft thinks they can put us out of business with them, but… Fat chance. See, a lot of the automated performance tuning features assume you EVER HAD GOOD PERFORMANCE…

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

Last Updated June 3, 2017

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: Office Hours Webcast - 2017/05/31Watch…

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

Last Updated May 29, 2017

This week, Brent, Erik, and Richie discuss disabling telemetry in SQL Server 2016, proper place for log files, Availability Groups, measuring data returned from a single query, whether CHECKDB should be done on tempdb, limiting tempdb usage for each session, transferring large amounts of data from on-prem to the cloud, and Iron Chef spoilers. Here’s…

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

Last Updated May 21, 2017