10 Tips for the SQL Server PowerShell Scripter

Summary: Microsoft PowerShell MVP, Chad Miller shares his top ten tips for the SQL Server Windows PowerShell scripter. Microsoft Scripting Guy, Ed Wilson, is here. Today’s blog is a bit unique. I was throwing around ideas with Chad Miller, and somehow we came up with the idea that he would share some tips for the…


Expert Commentary: 2012 Scripting Games Advanced Event 4

Summary: Microsoft MVP, Chad Miller, provides expert commentary for 2012 Scripting Games Advanced Event 4. Microsoft Scripting Guy, Ed Wilson, is here. Chad Miller is the expert commentator for Advanced Event 4. Chad is a senior manager of database administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999, and he…


Four Easy Ways to Import CSV Files to SQL Server with PowerShell

Summary: Learn four easy ways to use Windows PowerShell to import CSV files into SQL Server. Microsoft Scripting Guy, Ed Wilson, is here.  I was chatting this week with Microsoft PowerShell MVP, Chad Miller, about the series of blogs I recently wrote about using CSV files. He thought a helpful addition to the posts would…


Use ACE Drivers and PowerShell to Talk to Access and Excel

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 PowerShell? —MC Hello MC, Microsoft Scripting Guy, Ed Wilson, is…

7

Use PowerShell to Collect Server Data and Write to SQL

  Summary: Use Windows PowerShell to collect server data and automatically store that information in a Microsoft SQL Server.   Hey, Scripting Guy! How is Windows PowerShell usage by database professionals different from the way that other IT Pros use Windows PowerShell?   — MC   Hello MC, Microsoft Scripting Guy Ed Wilson here. Next…

27