Subscribe to this blog
Chad Miller
Archives: July 2010
Making A SQLPS Module
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL Server 2008 provider and cmdlets into a regular PowerShell. Michiel Wories, the creator of SMO and sqlps, provides an initialization script in his blog post SQL Server PowerShell is… Read more
0 comments, 375 reads
Posted in Chad Miller on 10 July 2010
Windows Search Enable Your Script Files
At the July 8th Tampa PowerShell User Group meeting, Ed Wilson (blog|twitter) gave a presentation on “PowerShell Best Practices.” One of the tips Ed mentioned is enabling Windows Search to index the content of PowerShell ps1 files. Although I’ve used grep or in PowerShell, Select-String to… Read more
0 comments, 100 reads
Posted in Chad Miller on 10 July 2010
Scripting Linked Servers
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked servers and linked server logins from SQL Server. The script wasn’t working as expected. I hadn’t seen the code in some time, but looking at it now the fact that… Read more
0 comments, 469 reads
Posted in Chad Miller on 6 July 2010