May, 2011

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,...

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...

Summary : Quit using deprecated JET drivers to talk to Microsoft Access and Excel. Learn how to use Windows PowerShell and ACE Drivers. Hey, Scripting Guy! How do I get data out of Microsoft Access and Excel files and into SQL Server by using Windows...

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...

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...

Summary : Microsoft Scripting Guy, Ed Wilson, discusses the use of aliases in Windows PowerShell scripts. He covers the pros and cons in this blog. Weekend Scripter Microsoft Scripting Guy, Ed Wilson, is here. “You can have my aliases when...