Showing archive results for 2010

  Summary: Microsoft Scripting Guy Ed Wilson shows how to clean up your Windows PowerShell ISE profile by creating a module.   Microsoft Scripting Guy Ed Wilson here, it is getting cold here in the Deep South. It is nearly 50 degrees Fahrenheit (10 degrees Celsius). The smell of hot chocolate permeates the early morning atmosphere in our ...

  Summary: Learn how to use Windows PowerShell to add a group of users to a SQL Server database.   Today is the final day of SQL guest blogger week. It was great to enter the SQL side of life. Sean McCown is our guest blogger for today. Sean McCown holds a double MCITP in SQL Server 2008 for both Administration and Development. He is also...

  Summary: Learn how to use Windows PowerShell to automate creation of SQL Database objects such as tables, stored procedures, and functions.   Hey, Scripting Guy! How can I use Windows PowerShell to script out SQL Server database objects? -- AA   Hello AA, Microsoft Scripting Guy Ed Wilson here. Today we have one final blog post fro...

  Summary: Learn how to use Windows PowerShell to change SQL Server service accounts.   Hey, Scripting Guy! How can I use PowerShell to change SQL Server service accounts? -- NM   Hello NM, Microsoft Scripting Guy Ed Wilson here. This week I am hosting guest bloggers from the SQL side of life. This is in honor of the SQL PASS Summit ...

   Summary: Learn how to use Windows PowerShell to obtain SQL Server database information.   Hey, Scripting Guy! Is there an easy way to obtain database size information by using Windows PowerShell? -- NA   Hello NA, Microsoft Scripting Guy Ed Wilson here. As I mentioned yesterday, this week we are hosting guest bloggers from th...