Browse by Tags

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

Summary : Windows PowerShell superhero BATCHman quickly imports CSV data into his SQL Server. Microsoft Scripting Guy Ed Wilson here. Sean Kearney is back today with Episode 6 of the BATCHman series. Note You can read all gripping, engaging, informative, and downright funny BATCHman episodes...

Summary: Learn how to use Windows PowerShell to capture performance counter information and write the saved data to a SQL Server database. Hey, Scripting Guy! I have been enjoying your PoshMon articles this week, but I have found them to be of limited value. I would love to see how I could store...

Summary : Guest Blogger Kevin Kline talks about using Windows PowerShell to monitor SQL Server performance. Hey, Scripting Guy! I am wondering about using Windows PowerShell to work with SQL performance counters. Is this something that can be done? —SH Hello SH, Microsoft Scripting...

Summary : Learn how to use Windows PowerShell to work with SQL Server policy-based management. Microsoft Scripting Guy, Ed Wilson, here. I am really excited about the idea I had for this week, and I hope you will be too. I asked Candace Gillhoolley at Manning Press about posting some sample works...

Summary : Learn how to search SQL Server error logs to return useful information by using Windows PowerShell to do the heavy lifting. Hey, Scripting Guy! I need to query the SQL Server error log for specific errors. But I am not real good with Windows PowerShell. What is the best way to do this? ...

Summary : Microsoft Scripting Guy, Ed Wilson, talks about different ways to use Windows PowerShell to get the SQL Server error log. Hey, Scripting Guy! I have recently inherited a Microsoft SQL Server 2008 R2 box, and I am concerned about the thing. I am not a DBA, and to be honest the server sort...

Summary : Learn how to use Windows PowerShell to work with Microsoft SQL Server Analysis Service database backups. Microsoft Scripting Guy, Ed Wilson, here. Our guest blogger today is Muthusamy Anantha Kumar, a.k.a. “The MAK.” Muthusamy Anantha Kumar is a Microsoft Certified IT...

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

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

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

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

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

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

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

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

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

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

Summary : Microsoft MVP Sean McCown shows how to use Windows PowerShell to administer remote SQL Servers using easy commands. Hey, Scripting Guy! I am an extremely busy database administrator (DBA), and at a recent SQL Saturday event, I heard several people talking about Windows PowerShell. I did...

In this post : Help Me Make This Code Work! How Can I Copy a Folder from One Computer to Many Other Computers? Addressing Some Unexpected VBScript While...Wend Behavior Can I Display My Hard Drive's Temperature? Help Me Make This Code Work! Hey, Scripting Guy! When I follow...

Hey, Scripting Guy! I have several items I have to check daily on my SQL 2008 servers. I currently have some VBScripts that do many of my tasks, but there are some new things I want to do. I figure that Windows PowerShell would be easier. Do you have any pointers? - SC Hi SC, It is becoming late...

Hey, Scripting Guy! One thing I do not understand is why the SQL Server team wrote its own version of Windows PowerShell. I thought Windows PowerShell was supposed to standardize things. But the SQL Server team has one version of Windows PowerShell, the Exchange team has another, and then of course there...

Hey, Scripting Guy! I am a SQL database administrator, and in the past I have enjoyed using VBScript for many tasks related to my computers that are running SQL Server. What capabilities does Windows PowerShell provide to make working with SQL Server 2008 easier? - OS Hi OS, Ed is neck deep in...

Hey, Scripting Guy! I recently saw that SQL Server 2008 has Windows PowerShell built into it. I looked at, but I am not really impressed. Why should I be interested in using Windows PowerShell with SQL Server 2008? - JJ Hi JJ, For some unknown reason, it has turned cool down here in Charlotte...

Determining if SQL Is Installed; How to Read Paired Information into a Dictionary Object Hey, Scripting Guy! Being an avid reader of your columns for the last several years has been a blast. I wrote you once before but with no success (in terms of a reply, which was expected, and in terms of not seeing...