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 5 of 16 (151 total posts)
  • Load Perfmon Log Data into SQL Server with PowerShell

    In yesterday's post I showed you how I set up performance data gathering in an environment where I can't directly update my analysis database. Today I'll show you how I load that data into SQL Server for the analysis. First, I create tables to contain the performance counters in my analysis database. Here's what they look like: CREATE TABLE ...
    Posted to Allen White (Weblog) by AllenMWhite on March 3, 2012
  • Setup Perfmon with PowerShell and Logman

    In a session yesterday I was reminded of the power of a tool on every server, Logman, to manage performance data gathering. It's a pretty amazing tool, and I'm starting to get to know how much more it can do than I've even considered, but here's a simple example of what I've done so far. First things first, I'm going to leverage the SMO Server ...
    Posted to Allen White (Weblog) by AllenMWhite on March 2, 2012
  • Getting Job History Correctly

    In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem. First, when EnumHistory() is invoked, it runs the sp_help_jobhistory stored procedure. You can ...
    Posted to Allen White (Weblog) by AllenMWhite on March 1, 2012
  • Handle Duration Results from EnumHistory in PowerShell

    Lately I've been very busy with client work, and one of my projects is to capture the history for SQL Agent jobs across all their servers so they can evaluate when to schedule jobs. (Yes, I know SQL Sentry has an excellent product for this, but right now there are budget constraints.) Anyway, I can do this in PowerShell with SMO. Once you ...
    Posted to Allen White (Weblog) by AllenMWhite on February 17, 2012
  • SQL Saturday 108 Redmond PowerShell Session Material

    I am honored to be presenting my first SQL Saturday session in Redmond on the 25th of this month. The session will be a PowerShell basics class, emphasis on helping people who might be starting out with PowerShell, or feel intimidated by PowerShell’s syntax or object-orientation. I have demos and material focused on PowerShell syntax in general, ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on February 10, 2012
  • [Speaking] Manage SQL Server 2012 on Windows Server Core with PowerShell

    This evening I'll be presenting a brand new session on installing and managing SQL Server 2012 with PowerShell. Here's the abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from ...
    Posted to Allen White (Weblog) by AllenMWhite on January 17, 2012
  • Speaking about Performance and PowerShell

    I'll be presenting at the South East Michigan SQL Server User Group (SEMSSUG) tonight. The session will be Gather SQL Server Performance Data with PowerShell. We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always ...
    Posted to Allen White (Weblog) by AllenMWhite on December 8, 2011
  • For Servers the Command Line Rules

    When I first learned to program, back in the fall of 1968, the first 'word' the computer I connected to said to me was 'READY'.  That summed it up neatly. The computer was ready to do work, it was just waiting for me to give it instruction. As I progressed through my knowledge of programming and my focus on providing businesses useful ...
    Posted to Allen White (Weblog) by AllenMWhite on October 26, 2011
  • SQLBits Presentation Materials

    After a week of data recovery (see my blog post here) and travel via train with no internet access, I've finally been able to get my presentation materials together from the Training Day and two regular sessions I did at SQL Bits #9 in Liverpool last week.  I've uploaded the materials here for the training day.  If you were in the room ...
    Posted to Allen White (Weblog) by AllenMWhite on October 8, 2011
  • Getting Excited: SQLBits is Coming

    Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling there next week for SQLBits 9 - Query across the Mersey! My wife and I will be spending a couple of days in London first, and since I'm a descendant of the Howard family from the Tudor period, I'm most interested in ...
    Posted to Allen White (Weblog) by AllenMWhite on September 19, 2011
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement