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: Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

    Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction? I do not want you to write it for me, but I would like a hint...
  • Blog Post: How Can I Retrieve a List of the System DSNs on a Computer?

    Hey, Scripting Guy! How can I retrieve a list of the System DSNs on a computer? -- RT Hey, RT. You know, there’s an old Hollywood superstition that suggests that famous movie stars always die in threes: if a famous star dies today, then according to legend two more famous stars are doomed to die in...
  • Blog Post: How Can I Get a List of All the Databases on a SQL Server Computer?

    Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer? -- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do that because the Scripting Editor is on vacation...
  • 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: How Can I Create a Table in a SQL Server Database?

    Hey, Scripting Guy! How can I create a table in a SQL Server database? -- FD Hey, FD. And thanks: you’ve saved the Scripting Guys! Or, at any rate, you’ve saved the Scripting Guy who writes this column. As it turns out, this Scripting Guy is getting ready to leave town and attend his nephew’s wedding...
  • Blog Post: Hey, Scripting Guy! How Can I Back Up a Database’s Data Folder While the Database Is Running?

    Hey, Scripting Guy! I have a problem. I am trying to script the backup of a data folder used by our database application. The problem is that as long as the database service is running, the files that are used are locked, and I am unable to copy them. I have found the service that runs the database,...
  • 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: How Can I Get a List of the ODBC Drivers that are Installed on a Computer?

    Hey, Scripting Guy! How can I get a list of the ODBC drivers that are installed on a computer? -- VV Hey, VV. This is one of those questions that end up driving us crazy. That’s because it: a) seems so simple and, b) appears as though there are a number of ways to get this information. For example...
  • Blog Post: How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

    Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer? -- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for...
  • 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: How Can I List All the Tables in an Access Database?

    Hey, Scripting Guy! How can I list all the tables in an Access database? -- KW Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours, dead-ends, and other frustrations we go through...
  • 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 Document Your SQL Database

    Summary: Learn how to use Windows PowerShell to document your Microsoft SQL Server database Hey, Scripting Guy! Is it possible to use Windows PowerShell to document my Microsoft SQL Server database? -- CR Hello CR, Microsoft Scripting Guy Ed Wilson here. Welcome to day three of guest...
  • Blog Post: Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

    Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it. I am not a real programmer; do you have any tips...
  • 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: Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

    Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on...
  • Blog Post: How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?

    Hey, Scripting Guy! I have a fixed-width text file which includes first name (6 characters), last name (13 characters), and department (9 characters) all on a single line. How do I read that using ADO? -- DW Hey, DW. Well, to be perfectly honest, we don’t think you can read a file like this using...
  • 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...