SQL Server Pain Relief: Office Hours

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.

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."

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.

This week Brent, Erik, and Richie discuss whether you need to know T-SQL to be a Senior DBA, if you should use SQL Server 2017 for production, monitoring tools, C# vs Powershell, IO_COMPLETION waits, DBA jobs, and SQL Operations Studio.

This week, Brent and Richie discuss the new Power BI Dashboard, designing a new backup structure, creating SSRS reports, the difference between row and page compression, using EMC Avamar SQL agent for backing up databases, SQL Server and other books to check out, Veeam Backup for SQL Server, and how to best manage monitor over 20 SQL servers.

This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different locations, SAN Replication, reducing the size of a database, patching Availability Groups, getting rid of failover cluster instances, long-term backup storage options, VLF numbers, and more.

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, and Richie's favorite board game.

This week, Brent, Erik, and Richie discuss database corruption, multi-instance clusters, career advice, whether you should transition from contract work to full time, VMware VMotion, reducing failover time with AGs, query tuning, and more.

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 for transferring databases from one server to another, VSS Snapshot backups, encryption and more.

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shipping, and their next company retreat location.