Monthly Archives: May 2009

Create Database Diagrams with Powershell + yUML

Powershell MVP, Doug Finke has an interesting post demonstrating how to create UML class digrams from Powershell using the website yUML. So, I thought it would be a fun exercise to create a UML class diagram of database tables. It … Continue reading

Posted in PowerShell

Sarasota SQL Server User Group Presentation

I presented a one-hour session at the Sarasota SQL Server User Group entitled "Powershell vs T-SQL". The session Description:   "Automating database tasks traditionally has meant creating Transact-SQL code or an SSIS package. While the introduction of Powershell provides another option, DBAs who … Continue reading

Posted in PowerShell | 1 Comment

Using Powershell to Import Excel file into SQL Server

This is a quick script which demonstrates how easy it is to import an Excel file into a SQL Server table using Powershell. The script is posted on PoshCode also:   #Change these settings as needed$filepath = ‘G:PowershellvTSQLbackupset.xlsx’#Comment/Uncomment connection string based on … Continue reading

Posted in PowerShell | 3 Comments

TechEd 2009 SQL + Powershell Sessions

Bill Ramos, Principal Program Manager on the SQL Server Management Studio team, will be delivering several sessions on two of my favorite topics, SQL Server and Powershell. Specifically Bill will be discussing Policy Based Management (PBM) and an interesting CodePlex project … Continue reading

Posted in PowerShell