VSTSC's Community Server

Browse by Tags

• SQL Server
• Sql Server 2005
• SQL Server Reporting Services
• WMI

• PowerShell and WMI namespaces

  When I wrote my previous blog post about blogging, I remembered how much of a sucker for the concept of recursion I'd become, even though it still bewilders me, after I'd read Godel, Escher, Bach: An Eternal Golden Braid by Douglas R. Hofstadter . I'd Read More... Posted Tuesday, May 19, 2009 5:31 PM by timbenninghoff | 0 Comments Filed under: PowerShell, WMI

• 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

• 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

• My Plug for SQLPSX

  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 Read More... Posted Saturday, March 28, 2009 12:14 PM by timbenninghoff | 0 Comments Filed under: SQL Server, PowerShell

• Expandable!

  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 Read More... Posted Wednesday, February 18, 2009 6:46 PM by timbenninghoff | 0 Comments Filed under: SQL Server, PowerShell

• Using PowerShell To Script Out Table Triggers In A Database

  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 Read More... Posted Thursday, January 22, 2009 9:43 AM by timbenninghoff | 1 Comments Filed under: SQL Server, PowerShell

• Installing SQL Server 2008 PowerShell snap-ins for SQL Server 2005

  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 Read More... Posted Sunday, December 21, 2008 12:51 PM by timbenninghoff | 3 Comments Filed under: SQL Server, PowerShell