2017-01-30 (first published: 2017-01-26)
17,395 reads
sp_msforeachdb
sp_msforeachdb: Improving on an Undocumented Stored Procedure
Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!
2016-04-15 (first published: 2014-12-01)
16,604 reads
2010-09-08 (first published: 2010-09-02)
2,337 reads
2008-08-06 (first published: 2008-06-16)
2,493 reads
Blogs
Redgate Clone Graduating Images
By Steve Jones
I wanted my own custom image in our internal Redgate Clone cluster, so I...
SQL Saturday Syracuse 2024 Recap
By alevyinroc
First Things First Thanks to every who came to my session, Asnwering the Auditor’s...
A New Word: Incidental Contact High
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
executing a proc on another server from a proc on th e1st server
Hi, this is a second post trying to help a friend on a slightly...
Question of the Day
Adding Features During a SQL Server 2022 Upgrade
I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?
See possible answers