A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database administrator must spend a large amount of time to set up alerts and configure settings, and even then the […]
Category: sqlserverpedia-syndication
SQL Server 2014 SP1 released, and revoked
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately: The problem is there was a problem with the patch. I can’t go into details until there is something formally announced by Microsoft but the MVPs were alerted […]
SSMS regular expressions: format text into a block
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a RegEx thing in SQL Server Management Studio. Here’s the problem: Sometimes I document an SP in MS Word, then copy-paste the paragraph into a comment block in the SP. Of course, when I do this, the paragraph is in […]