Brent Ozar Videos 0 I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 03:15 Mattia Nocerino: I’ve always ignored database t-sql snapshots. What are good use cases, if any? 05...
Since logs don’t grow too often, you really only notice this when you start SQL with a huge default log size on TempDB. Reply Jeremiah Peschka September 4, 2013 4:23 pm IFI is tricky like that, thanks for pointing to Microsoft’s documentation. Reply Brent Ozar September 5, 2013 4...
https://www.BrentOzar.com Help@BrentOzar.com Verified PinnedLoading SQL-Server-First-Responder-KitSQL-Server-First-Responder-KitPublic sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning. ...
Brent Ozar谈如何提高SQL Server的生产力Anand Narayanaswamy
sp_BlitzFirst.sql sp_BlitzIndex.sql sp_BlitzLock.sql sp_BlitzWho.sql sp_DatabaseRestore.sql sp_ineachdb.sql Repository files navigation README Code of conduct License SQL Server First Responder Kit Navigation How to Install the Scripts How to Get Support Common Scripts: sp_Blitz:...
Microsoft Assessment and Planning Toolkit(微软的规划和评估工具)——它是设计用来做微软licensing兼容性检查的,但是它是一个非常好的建立服务器清单的工具。它扫描你的网络,寻找目标程序。不过它只能用于sqlser server。 Quest Discovery Wizard for SQL Server(quest的sqlserver扫描工具)——这是一个图形工具,可以...
学习备份和还原知识,我们推荐下列这些文章: Grant Fritchey's SQL Server Backup and Restore for the Accidental DBA Brent's DBA Nightmare: SQL Down, No Plans Jes's 3 Things You Need to Start Doing to Your Database Server 感谢!我们下周再见!...
Brent Ozar discusses old school DBAs Who became DBAs 5 - 10 years ago? 02:06 Experts from Computer Weekly and Quest discuss a powerful approach to database monitoring Managing multiple diverse database platforms and hybrid environments has become the new norm for DBAs. ...
Brent Ozar, who is a Microsoft SQL Server expert for Quest Software, Microsoft MVP, Editor-in-Chief at SQLServerPedia.com, and coauthor of Professional SQL Server 2008 Internals and Troubleshooting - has written a series of posts related to his SQL MCM training preparation. His posts to date...
Brent Ozar, who is a Microsoft SQL Server expert for Quest Software, Microsoft MVP, Editor-in-Chief at SQLServerPedia.com, and coauthor of Professional SQL Server 2008 Internals and Troubleshooting - has written a series of posts related to his SQL MCM training preparation. His posts to date...