Browse by Tags

• Database Administration
• PASS Summit
• Service Broker
• SMO
• Speaking
• SQL Server 2008
• T-SQL Tuesday
• User Group Meetings

• 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 Read More... Posted Friday, March 02, 2012 5:34 PM by AllenMWhite | 6 Comments Filed under: Database Administration, PowerShell, SMO

• 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. Read More... Posted Thursday, March 01, 2012 10:03 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, SMO

• 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 Read More... Posted Friday, February 17, 2012 9:50 PM by AllenMWhite | 4 Comments Filed under: PowerShell, SMO

• [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 Read More... Posted Tuesday, January 17, 2012 1:26 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, Speaking, User Group Meetings

• 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 Read More... Posted Thursday, December 08, 2011 12:37 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, Speaking, User Group Meetings

• 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 Read More... Posted Wednesday, October 26, 2011 4:38 PM by AllenMWhite | 9 Comments Filed under: Database Administration, PowerShell

• 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 Read More... Posted Sunday, October 09, 2011 12:35 AM by AllenMWhite | 3 Comments Filed under: PowerShell, Service Broker, SMO, Speaking Attachment(s): Use PowerShell to Get the Most out of SQL Server.zip

• 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 Read More... Posted Monday, September 19, 2011 11:59 AM by AllenMWhite | 1 Comments Filed under: PowerShell, Service Broker, SMO, Speaking

• [Speaking] Lots of Speaking Engagements in September and October

  As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief list of what's coming up: On Saturday, September 17 I'll be in Kalamazoo, Michigan for SQL Saturday #84 , where I'll be presenting my Automate Policy-Based Read More... Posted Monday, August 22, 2011 9:38 AM by AllenMWhite | 0 Comments Filed under: PowerShell, Service Broker, Speaking, User Group Meetings

• Pull Performance Data from Perfmon Logs with PowerShell

  For the last year and a half or so I've been presenting a session on how to gather perfmon data with PowerShell. Here's a link to my blog after the 2010 Tech Ed conference that has the download scripts. These scripts include the database tables and stored Read More... Posted Sunday, August 21, 2011 8:04 PM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell

• Use PowerShell to Add a Login to a Database Role in all Databases

  Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to assign db_backupoperator for all databases in an instance to a login?" I looked and didn't really have anything that fit, but Read More... Posted Friday, June 03, 2011 2:09 PM by AllenMWhite | 5 Comments Filed under: Database Administration, PowerShell, SMO

• What Encryption Algorithms Are You Using?

  Security is an important consideration when designing a database application. Who can get access to what data? How much damage can someone do if they get at your data? In SQL Server 2005 Microsoft implemented column-based encryption, and in SQL Server Read More... Posted Tuesday, May 31, 2011 1:04 PM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell, SMO

• Monitor your SQL Server Agent Proxies Using PowerShell

  Over time it's easy to lose track of the things you set up to get work done. As a consultant, I have to discover what's set up on a client system. In either case, it's important to know what security settings are in place to know if they're appropriate Read More... Posted Wednesday, May 25, 2011 10:40 AM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell, SMO

• Find your Enabled SQL Server Network Protocols Using PowerShell

  Another quick check I like to do when in 'discovery mode' on a client system is to see what network protocols are enabled. Those of us around in 2003 will remember well the headaches caused by the SQL Slammer virus, and know to shut down Named Pipes unless Read More... Posted Saturday, May 21, 2011 4:38 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, SMO

• Quickly Find Your DDL Triggers with PowerShell

  As a consultant I spend much of the first day or two at a client site discovering everything I can about their servers, before I start planning the engagement. You can find DDL triggers by going into the Object Explorer in Management Studio, open up each Read More... Posted Friday, May 20, 2011 9:55 AM by AllenMWhite | 2 Comments Filed under: PowerShell, SMO