THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Powershell SMO   (RSS)
  • Excited to be speaking at #SQLSATATL next weekend

    I will be on for speaking next week at SQL Saturday #220 #SQLSATATL. My sessions will be on SQL Server TDE and SMO Internals for High Performance PowerShell. Both are great fun to present and good information to have. Hope to see you there in Alpharetta, GA.  
    Posted to Ben Miller (Weblog) by dbaduck on May 12, 2013
  • Powershell, SMO and Database Files

    In response to some questions about renaming a physical file for a database, I have 2 versions of Powershell scripts that do this for you, including taking the database offline and then online to make the physical change match the meta-data. First, there is an article about this at http://msdn.microsoft.com/en-us/library/ms345483.aspx.  This ...
    Posted to Ben Miller (Weblog) by dbaduck on February 14, 2011
  • Final DB Scripter using Powershell

    I decided to finish the scripter even though I could not get the Add-Content to work without giving me a multitude of ??? in the file.  I decided that I could script out the Tables, Views and DB and also output the contents of the INSERT statements into 2 files instead of 1, then concat the files together or just use one ...
    Posted to Ben Miller (Weblog) by dbaduck on November 27, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement