Posts by Brent Ozar Unlimited Team

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

This week, Brent, Richie, Tara, and Erik discuss enhancing queries, database corruption, availability groups, parameter sniffing, sending mail via SQL server, whether SQL 2016 is solid or not, other versions of SQL, physical servers vs virtual servers, and much more! Here’s the video on YouTube: Office Hours Webcast - 2016/09/21Watch this video on YouTube You…

This week, Brent, Richie, and Erik discuss execution plans for table value functions, how to prepare for the Senior DBA course, source control software, generating fragmentation, backups, and the new TV shows the team is looking forward to this season. Here’s the video on YouTube: Office Hours Webcast - 2016/09/14Watch this video on YouTube You…

This week, Brent, Richie, Erik, and Tara discuss parameter sniffing, database backups, referential integrity in databases, clustering, creating and using indexes, in-place upgrades, bench marking tools, and more. Here’s the video on YouTube: Office Hours Webcast - 2016/09/07Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to…

This week, Brent, Richie, and Tara discuss corruption, resetting query stats, fixing parameter sniffing issues, how to suggest features for our scripts, and why Brent is sporting an Oracle sweatshirt. Here’s the video on YouTube: Office Hours Webcast - 2016/08/31Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our…

This week, Richie and Erik discuss in-place instance upgrades, availability groups, the cloud, job security, business intelligence and user adoption, and much more! Here’s the video on YouTube: Office Hours Webcast - 2016/08/24Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office…

This week, Brent, Richie, Erik, and Tara get together in Round Rock, TX, for Dell DBA Days, to talk through your SQL questions and answers. They discuss what they are working on at Dell during the event, as well as Windows Kerberos and NTLM Authentication, Always On Availability Groups, Microsoft’s Document DB, automating restore databases…

This week, Richie, Erik, and Tara discuss availability groups, sharding databases, using DNS entries to mask DB server names, and Erik’s passion for internet buttons. Here’s the video on YouTube: Office Hours Webcast - 2016/08/03Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the…

This week, Brent, Richie, Erik, and Tara discuss speeding up performance, how to make SSRS highly available, what to do with SSIS packages when making upgrades, Windows Core, and how to hide data from DBAs when they have SA access. Here’s the video on YouTube: Office Hours Webcast - 2016/07/27Watch this video on YouTube You…

This week, Brent, Richie, Erik, and Tara discuss new Microsoft certs for data science, index rebuilds, replication, patching SQL server, and what to say to a manager that says he needs an active/active HA solution but has no idea what that means. Here’s the video on YouTube: Office Hours Webcast - 2016/07/20Watch this video on…

This week, Erik, Tara, Jessica, Doug, and Angie discuss queries, installing multiple instances of SQL server on a Windows VM, using DENY Database rules, migrating databases to Amazon RDS, availability groups, using filtered indexes, and more! Here’s the video on YouTube: Office Hours Webcast - 2016/07/13Watch this video on YouTube You can register to attend next week’s…

This week, Brent, Richie, Doug, and Tara discuss Growing databases, most useful SQL certifications, replication issues, group discounts, backup software and more. Here’s the video on YouTube: Office Hours Webcast - 2016/06/22Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours…

This week, Brent, Angie, and Tara talk through your questions about monitoring tools, transactional replication, configuration management, source control software suggestions and much more! Here’s the video on YouTube: Office Hours Webcast - 2016/06/15Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go.…

This week, Brent, Angie, Erik, Tara, Jessica, and Richie discuss SSMS issues, security auditing, snapshot replication, SSIS Cache Connection Manager, AlwaysON Availability Groups, deadlocks, and Jessica’s trip to Mexico. Here’s the video on YouTube: Office Hours Webcast - 2016/06/1Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to…

This week, Angie, Erik, Doug, Jessica, and Richie discuss DB migration, rebuilding large indexes, recommendation for SQL dev ops tools, best practices for disabling SA accounts, compression, and more! Here’s the video on YouTube: Office Hours Webcast - 2016/06/08Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast…

This week, Angie, Erik, Tara, and Richie discuss Veeam, replication, setting up alerts, using multiple instances, and much more. Here’s the video on YouTube: Office Hours Webcast - 2016/05/25Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours Webcast – 2016-05-25 Does…

This week, Brent, Angie, Erik, Jessica, Richie, and Tara discuss backups, failover events, tempdb errors, errors, other errors… oh, did we mention errors? Here’s the video on YouTube: Office Hours Webcast - 2016/05/11Watch this video on YouTube You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. How…