Scripting Blog

A place to learn about PowerShell and share stories of automation

May 2011 - Page 6 of 7 - Scripting Blog

Use PowerShell to Copy a Table Between Two SQL Server Instances

May 6, 2011 May 6, 2011 05/6/11
ScriptingGuy1
Summary: Learn how to use Windows PowerShell to quickly and efficiently copy a table between two SQL Server instances.   Hey, Scripting Guy! How can I copy a table between two SQL Server instances? —PY Hello PY, Microsoft Scripting Guy, Ed Wilson, is here. Today is the last day for this week’s SQL Guest Blogger series. Today ...

Use PowerShell to Automatically Create Tempdb Files in SQL Server

May 5, 2011 May 5, 2011 05/5/11
ScriptingGuy1
Summary: Learn how to use Windows PowerShell to automatically create Tempdb files in your SQL Server instance.   Hey, Scripting Guy! How can I easily create multiple tempdb data files in my SQL Server instance? —WM Hello WM, Microsoft Scripting Guy, Ed Wilson, is here. What a great week of SQL guest bloggers, and we have Michael ...

Use PowerShell to Perform SQL Data Mining

May 3, 2011 May 3, 2011 05/3/11
ScriptingGuy1
Summary: Learn how to use Windows PowerShell to perform SQL Server data mining. Microsoft Scripting Guy, Ed Wilson, is here. Today I continue the week about SQL in honor of next week’s SQLRally in Orlando. I have the honor of introducing Mark Tabladillo, who will talk to us about data mining. Mark Tabladillo Ph.D. is a business ...

Use PowerShell to Report SQL Server Backup Status

May 2, 2011 May 2, 2011 05/2/11
ScriptingGuy1
Summary: Learn how to use Windows PowerShell to automatically email a report on SQL Server backup status. Hey, Scripting Guy! —CN Hello CN, Microsoft Scripting Guy, Ed Wilson, here. The time is near for SQLRally in Orlando. I will be making a presentation about Windows PowerShell and I wanted to support the rally. I thought the best ...