Browse by Tags

Tagged Content List
  • Blog Post: Weekend Scripter: Easily Back Up All SQL Server Databases by Using PowerShell

    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...
  • Blog Post: 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...
  • Blog Post: Use PowerShell to Clean-up SQL Server Jobs

    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...
  • Blog Post: Use PowerShell to Administer SQL Server 2008

    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...
  • Blog Post: Use PowerShell to Get the SQL Server Error Log

    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...
  • Blog Post: Use PowerShell to Examine Dirty and Expensive SQL Server Properties

    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...
  • Blog Post: Use PowerShell to Parse SQL Server 2012 Error Logs

    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...
  • Blog Post: Use PowerShell to Script SQL Database Objects

    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...
  • Blog Post: Monitor an AlwaysOn Availability Group with PowerShell

    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...
  • Blog Post: Use PowerShell to obtain SQL Server database sizes

    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...
  • Blog Post: Use PowerShell to Monitor Your SQL Server Performance

    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...
  • Blog Post: Use PowerShell to Discover, Diagnose, and Document SQL Server

    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...
  • Blog Post: Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (12/18/09)

    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...
  • Blog Post: Set Up an AlwaysOn Availability Group with PowerShell

    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...
  • Blog Post: Use PowerShell to Report SQL Server Backup Status

    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...
  • Blog Post: 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...
  • Blog Post: Capture Performance Counter Data and Write to SQL Server

    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...
  • Blog Post: Use PowerShell to Automatically Create Tempdb Files in SQL Server

    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...
  • Blog Post: Introduction to the SQL Server 2012 PowerShell Provider

    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...
  • Blog Post: Using PowerShell to Add a Group of Users to a SQL Database

    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...
  • Blog Post: BATCHman Uses PowerShell to Import a CSV File into His SQL Server

    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...
  • Blog Post: 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...
  • Blog Post: Troubleshooting an AlwaysOn Availability Group with PowerShell

    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...
  • Blog Post: Use PowerShell to Security Test SQL Server and SharePoint

    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...
  • Blog Post: Hey, Scripting Guy! How Can I Use the SQL Server Mini-Shell Version of Windows PowerShell?

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