Browse by Tags

Summary : SQL Server MVP, Kendal VanDyke, talks about using Windows PowerShell to discover, diagnose, and document all your computers running SQL Server. Microsoft Scripting Guy, Ed Wilson, is here. Kendal VanDyke is with us today to wrap up SQL Server Week. Kendal VanDyke is a practiced IT professional...

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

Summary : SQL Server MVP, Sean McCown, shows how to use Windows PowerShell to clean-up SQL Server jobs. Microsoft Scripting Guy, Ed Wilson, is here. Today we wrap up the weekend with the last of three blogs by guest blogger, Sean McCown. You can read more about Sean and his previous guest blogs on...

Summary : SQL MVP, Sean McCown, talks about using Windows PowerShell to examine Dirty and Expensive SQL Server properties. Microsoft Scripting Guy, Ed Wilson, is here. Here is blog two of three in a series from guest blogger, Sean McCown. Yesterday, we published Use PowerShell to Work with SQL Server...

Summary : SQL Server MVP, Sean McCown, talks about using Windows PowerShell to work with SQL Server instance-level properties. Microsoft Scripting Guy, Ed Wilson, is here. Today is the first of three blogs written by guest blogger, Sean McCown. You can read more about Sean and his previous guest blogs...

Summary : Guest blogger, Tom Stringer, illustrates how to troubleshoot an AlwaysOn availability group by using Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. We welcome back guest blogger, Thomas Stringer, for Part 3 of this three-part series. To catch up, read: Part 1: Set Up...

Summary : Guest blogger, Tom Stringer, illustrates how to monitor an AlwaysOn Availability Group by using Windows PowerShell to ensure high availability functionality in an environment. Microsoft Scripting Guy, Ed Wilson, is here. Today we have another blog in our SQL Server Week series from Microsoft...

Summary : Microsoft SQL Server PFE, Thomas Stringer, talks about using Windows PowerShell to set up an AlwaysOn availability group. Microsoft Scripting Guy, Ed Wilson, is here. Today we kick off SQL Server Windows PowerShell Week. Our first blog of the series is a guest blog written by SQL Server...

Summary : Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell to parse SQL Server 2012 error logs. Microsoft Scripting Guy, Ed Wilson, is here. The Scripting Wife and I have been in a number of email threads with Mark Schill, the leader of the Atlanta Windows PowerShell User Group...

Summary : Microsoft Scripting Guy, Ed Wilson, shows how to use the SQL Server 2012 provider for Windows PowerShell to easily back up all databases on an instance. Microsoft Scripting Guy, Ed Wilson, is here. I am still playing around with SQL Server 2012, and, today, I want to check on my backups...

Summary : Ed Wilson, the Microsoft Scripting Guy, shows you how to use the SQL Server 2012 provider for Windows PowerShell to work with database objects. Microsoft Scripting Guy, Ed Wilson, is here. Today I want to continue my series of articles that explore the SQL Server 2012 provider for Windows...

Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to examine the SQL Server object. Microsoft Scripting Guy, Ed Wilson, is here. Today I want to continue exploring the SQL Server provider for Windows PowerShell. We will dive into the named instance node of SQL Server...

Summary : Microsoft Scripting Guy, Ed Wilson, provides an introduction to the SQL Server 2012 provider for Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. One of the really cool things about SQL Server 2012 is the SQL Server provider for Windows PowerShell. By using the SQL Server...

Summary : Guest blogger, Niklas Goude, talks about using Windows PowerShell to perform brute force security testing on SQL Server and SharePoint. Microsoft Scripting Guy, Ed Wilson, is here. Today we have Niklas Goude back with Part 2 of his Security Week series. Niklas Goude is a Security Consultant...

Summary : Guest blogger, Laerte Junior, discusses using Windows PowerShell to troubleshoot SQL Server by parsing the SQL error log. Microsoft Scripting Guy, Ed Wilson, is here. Today we have another guest blogger, Laerte Junior. Here is a little bit about Laerte. Laerte Junior is a SQL Server...

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