Brent Ozar T-SQL 10Comments SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, '2017-06-01'); 1 SELECT DATETRUNC(year, '2017-06-01'); Truncates everything in that date other than the year, so it returns ...
If you’re migrating from SQL Server 2014 or earlier, you don’t have access to Query Store yet. That’s okay: you can still do the migration, but just make sure that Query Store is the first thing you turn on after you go live on 2022. (You might have heard that Query Store is...
Brent Ozar谈如何提高SQL Server的生产力Anand Narayanaswamy
sp_Blitz.sql sp_BlitzAnalysis.sql sp_BlitzBackups.sql sp_BlitzCache.sql sp_BlitzFirst.sql sp_BlitzIndex.sql sp_BlitzLock.sql sp_BlitzWho.sql sp_DatabaseRestore.sql sp_ineachdb.sql Breadcrumbs SQL-Server-First-Responder-Kit / SqlServerVersions.sql Latest commit BrentOzar 2024-07-01 Releas...
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning. - BrentOzarULTD/SQL-Server-First-Responder-Kit
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...
Microsoft Assessment and Planning Toolkit(微软的规划和评估工具)——它是设计用来做微软licensing兼容性检查的,但是它是一个非常好的建立服务器清单的工具。它扫描你的网络,寻找目标程序。不过它只能用于sqlser server。 Quest Discovery Wizard for SQL Server(quest的sqlserver扫描工具)——这是一个图形工具,可以...
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...
Budgeting 101 for SQL Server database administrators by Brent Ozar leave a comment » This is another good article from Brent Ozar, I hope you like it. It’s that beautiful time of year when everybody watches the colors. No, not the changing browns and reds of the foliage, but the ...
学习备份和还原知识,我们推荐下列这些文章: 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 感谢!我们下周再见!...