VSTSC's Community Server

It's no small secret that I'm a big fan of using PowerShell to manage SQL Servers. I've gone through all the trouble of loading the SQL Server assemblies and/or configured PowerShell to use the SQL Server provider, and I've jumped into SMO, sometimes Read More...

I was tagged in a blog post making the rounds based on the question, 'Who has been a great leader in your career and what made them a great leader?' I think I'll join the bandwagon on this way and politely decline on talking about great leaders in my Read More...

One of the applications we have from a vendor has a SQL Server 2005 database with over 50,000 tables. I was using the PowerShell provider for SQL Server to search through the tables to find any that had the word 'ROLE' in it using the following command: Read More...