VSTSC's Community Server

''I suppose you could say that everyone has an El Guapo.''  Lucky Day, The Three Amigos  As the title of my blog post says, I've got an El Guapo, a nemesis, an antagonist.  It's a mental monkey trap.  I cannot seem to figure out how the 'Limit size of job history log' setting for the SQL Server Agent would be useful to me in ...

In a previous blog post I talked about being puzzled as to why I wasn't able to get, in my mind, accurate table counts for a database in SQL Server 2005 that had over 50,000 tables.  I kept getting only 1,000.  With the help of Chad Miller, I've figured it out. To reiterate, when I had navigated to the PSDrive for the tables within one ...

Chad Miller, one of my favorite bloggers on SQL Server and PowerShell, has just announced the release of version 1.5 of SQLPSX.  SQLPSX is a collection of functions, cmdlets, and scripts that make accessing SQL Server via PowerShell extremely easy. For example, normally, without even considering error handling, you'd have to write the ...

When I start to learn a new technology, I find I learn best if I jump right in, get my hands dirty, and play around with it for a while.  After a couple initial ah-HA moments and early successes, I inevitably hit a wall where I can't seem to solve a particular problem.  By that time, I've built up quite a list of questions, and I'm ready ...

A request came in from one of the developers asking if there was a way to script out all of the triggers for a list of tables in a database on SQL Server 2005.  This database has around 60k tables, and navigating to each of the 40 some tables that the developer needed triggers for in SQL Server Management Studio (SSMS) was becoming quite a ...

If your company is like mine, you are largely at the mercy of your software vendors as to when you'll be upgrading to SQL Server 2008.  But, if you're like me, you want to start taking advantage of the features of the SQLPS mini-shell in your regular PowerShell today, particularly with administering your SQL Server 2005 instances.  The ...

Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. She had a few questions so I opened the package and began poking around some to answer ...

I received the news today: Microsoft has awarded me SQL Server MVP again this year. How cool! Thanks Microsoft! :{> Andy

When installing SQL Server 2005 on Vista Ultimate, you will receive the following warning from the Program Compatibility Assistant. You will receive this warning several times. This is normal. Click the ''Run program'' button to proceed.   If you haven't configured IIS for Reporting Services you will receive a warning at the ...