SQL Automation using PowerShell
Monday, May 14, 2012
Compress XML data
›
Its been while since I've posted anything. Sorry folks. I've done some very cool stuff, will try and post in the coming weeks. 1 ...
Tuesday, July 5, 2011
View Reporting Services subscriptions and run them ad hoc
›
In some Reporting Services environments, subscriptions are extensively used to distribute business data. This results in 10's or even 1...
2 comments:
Wednesday, June 22, 2011
Enable non sysadmins to run a profiler trace for a set period of time and view the results of the trace
›
My customer is a large corporate with a large Microsoft Development team. This team develops and suports numerous in house applications. T...
Friday, June 3, 2011
Post SQL Installation Configuration Script
›
After installing SQL Server and applying the latest or required Service pack, there are always a number of tasks that may be completed in a ...
Saturday, May 29, 2010
Automatically restore a list of databases
›
I recently had a situation at my client where we were troubleshooting a SQL server hanging and one candidate was a faulty RAID array or SCSI...
Monday, May 10, 2010
Check that all databases on all servers have been backed up
›
At the client that I work at, there are over 1500 databases on more than 200 SQL servers, ranging from SQL 2000 to 2008. For me to have a g...
Monday, March 8, 2010
Viewing SQL Agent Job History and Duration visually using floating bars
›
Viewing SQL Agent Job History and Duration visually using floating bars. The title only tells half the story. What this article will descr...
3 comments:
›
Home
View web version