2017-01-30 (first published: 2017-01-26)
13,711 reads
2017-01-30 (first published: 2017-01-26)
13,711 reads
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)
15,747 reads
2010-09-08 (first published: 2010-09-02)
2,322 reads
2008-08-06 (first published: 2008-06-16)
2,164 reads
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...