THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » PowerShell   (RSS)
Showing page 4 of 16 (151 total posts)
  • Scanning the Error Log with PowerShell

    One of the most important things you can do as a DBA is to keep tabs on the errors reported in the error log, but there's a lot of information there and sometimes it's hard to find the 'good stuff'. You can open the errorlog file directly in a text editor and search for errors but that gets tedious, and string searches generally return just the ...
    Posted to Allen White (Weblog) by AllenMWhite on September 25, 2012
  • 24 Hours of PASS - PowerShell 101 for the SQL Server DBA

    Thanks to everyone who came out for the session today.  It was a lot of fun and I hope you had a great experience as well.  I've attached the demo scripts and slide deck to this post, and I look forward to seeing you in November at the PASS Summit! Allen
    Posted to Allen White (Weblog) by AllenMWhite on September 20, 2012
  • Speaking - 24 Hours of PASS, Summit Preview Edition

    There's so much to learn to be effective with SQL Server, and you have an opportunity to immerse yourselves in 24 hours of free technical training this week from PASS, via the 24 Hours of PASS event. I'll be presenting an introductory session on PowerShell called PowerShell 101 for the SQL Server DBA. Here's the abstract: The more you have to ...
    Posted to Allen White (Weblog) by AllenMWhite on September 18, 2012
  • PowerShell - grabbing values out of the registry and running them

    So I closed an application that runs when Windows starts up, but it doesn’t have a Start Menu entry, and I was trying to find it. Ok, I could’ve run regedit.exe, navigated through the tree and found the list of things that run when Windows starts up, but I thought I’d use PowerShell instead. PowerShell presents the registry as if it’s a volume ...
    Posted to Rob Farley (Weblog) by rob_farley on June 12, 2012
  • SQL Rally Presentations

    As I drove to Dallas for this year's SQL Rally conference (yes, I like to drive) I got a call asking if I could step in for another presenter who had to cancel at the last minute.  Life happens, and it's best to be flexible, and I said sure, I can do that. Which presentation would you like me to do? (I'd submitted a few presentations, so it ...
    Posted to Allen White (Weblog) by AllenMWhite on May 11, 2012
  • Script and Migrate Agent Jobs between Servers using PowerShell

    I'm nearing the end of a SQL Server upgrade project, migrating from SQL Server 2000 to SQL Server 2008 R2. The company uses SQL Server Agent to run about 150 jobs which execute DTS packages to do the work of moving data around. Now, there are any number of ways to move these jobs from one server to the other, but I wanted to be able to exclude ...
    Posted to Allen White (Weblog) by AllenMWhite on May 2, 2012
  • Microsoft Delivers Full Suite of SQL Server PowerShell Cmdlets

    We’ve all been waiting several years for this, and finally it’s here! Coinciding (approximately) with the release of SQL Server 2012, a new Feature Pack has appeared on the Microsoft web site that adds a full suite of PowerShell cmdlets for DDL and other functions. This means that, at last, we can do things like fully-featured SQL deployment ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 1, 2012
  • System Inventory and Performance Gathering SQL Connections Session

    Yesterday I delivered a session on maintaining a system inventory and gathering performance data with PowerShell.  The session went well and I had great questions and I'd like to thank everyone who attended the session.  I've attached the slides and demo scripts from the session for your use. Allen
    Posted to Allen White (Weblog) by AllenMWhite on March 29, 2012
  • The Expert's Conference (TEC) - For AD, SharePoint, Exchange, PowerShell and Other Admins

    What is TEC? The Expert's Conference (TEC) is a multi-day event featuring five co-located Microsoft educational conferences at the San Diego Marriott Marquis & Marina April 29-May 2. It's pretty - see! The event includes advanced 400-level training on Microsoft Directory & Identity (including Active Directory), Exchange Server, ...
    Posted to Kevin Kline (Weblog) by KKline on March 19, 2012
  • Speaking About SQL Server

    There's a lot of excitement in the SQL Server world right now, with the RTM (Release to Manufacturing) release of SQL Server 2012, and the availability of SQL Server Data Tools (SSDT). My personal speaking schedule has exploded as well. Just this past Saturday I presented a session called Gather SQL Server Performance Data with PowerShell. There ...
    Posted to Allen White (Weblog) by AllenMWhite on March 12, 2012
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement