VSTSC's Community Server

April 2009 - Posts

• Creating a Reporting Services rdl from PowerShell

  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... Posted Wednesday, April 29, 2009 5:54 PM by timbenninghoff | 0 Comments Filed under: PowerShell, SQL Server Reporting Services

• Object Limit and SQL PowerShell Provider Answered

  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 Read More... Posted Wednesday, April 22, 2009 5:59 PM by timbenninghoff | 0 Comments Filed under: SQL Server, PowerShell

• SQL Quiz, WHAT?

  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... Posted Sunday, April 19, 2009 7:15 PM by timbenninghoff | 0 Comments Filed under: Leadership

• Any Number You Want As Long As It's 1

  Any customer can have a car painted any colour that he wants so long as it is black. - Henry Ford in his autobiography " My Life and Work " SQL Server has a stored procedure for creating new SQL Agent jobs called sp_add_job , and this stored procedure Read More... Posted Thursday, April 09, 2009 9:29 AM by timbenninghoff | 0 Comments Filed under: SQL Server 2000, Sql Server 2005

• Object Limit And SQL PowerShell Provider?

  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... Posted Wednesday, April 08, 2009 1:35 PM by timbenninghoff | 1 Comments Filed under: PowerShell, Sql Server 2005