Browse by Tags

• PowerShell
• Service Broker
• SMO
• Speaking
• User Group Meetings

• Set and Verify the Retention Value for Change Data Capture

  Last summer I set up Change Data Capture for a client to track changes to their application database to apply those changes to their data warehouse. The client had some issues a short while back and felt they needed to increase the retention period from Read More... Posted Wednesday, March 07, 2012 9:14 PM by AllenMWhite | 2 Comments Filed under: Database Administration, SQL Server 2008

• Endpoints Need Privileges Too

  Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment. Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been Read More... Posted Thursday, May 26, 2011 5:16 PM by AllenMWhite | 0 Comments Filed under: Database Administration, Service Broker, SQL Server 2008

• Change SQL Servers Authentication Mode with PowerShell

  Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One of the settings that I normally set and forget at install time is the Authentication Mode setting. Best practices suggest that Read More... Posted Thursday, May 19, 2011 5:22 PM by AllenMWhite | 6 Comments Filed under: Database Administration, PowerShell, SMO, SQL Server 2008

• Discover Facets and Properties in PowerShell

  When you're trying to set up scripts to deploy policies to your servers (because you ALWAYS automate with PowerShell, right?), it can be sometimes difficult to determine exactly what facets are there, and when you do know the facet name, what properties Read More... Posted Monday, September 27, 2010 11:56 AM by AllenMWhite | 3 Comments Filed under: Database Administration, PowerShell, SMO, SQL Server 2008

• PASS PowerShell/SQL Server PreCon

  PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Read More... Posted Thursday, August 19, 2010 4:17 PM by AllenMWhite | 4 Comments Filed under: Database Administration, PowerShell, SMO, Speaking, SQL Server 2008, User Group Meetings

• TechEd 2010 Followup

  Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented: DAT01-INT Administrative Demo-Fest for SQL Server 2008 SQL Server Read More... Posted Sunday, June 13, 2010 3:25 PM by AllenMWhite | 4 Comments Filed under: Database Administration, PowerShell, Speaking, SQL Server 2008 Attachment(s): TechEd2010.zip

• Speaking at SQLSaturday #33 in Charlotte

  I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell . The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft Read More... Posted Thursday, March 04, 2010 11:33 AM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell, Speaking, SQL Server 2008, User Group Meetings

• Service Broker Basics - Part Deux

  Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that allow communication between different servers running Service Broker. Endpoints . There needs to be a channel for the communications Read More... Posted Tuesday, January 12, 2010 11:40 AM by AllenMWhite | 2 Comments Filed under: Database Administration, Service Broker, SQL Server 2008

• Service Broker Basics

  I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not a lot of information out there to help guide you through the process. Here I'd like to walk you through the basics. Message Read More... Posted Wednesday, January 06, 2010 12:59 PM by AllenMWhite | 3 Comments Filed under: Database Administration, Service Broker, SQL Server 2008

• Changing Server Default Collation

  An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the Czech Republic, I have to reset our lab systems server default collation to Czech_CI_AS, and I found it difficult to Read More... Posted Friday, May 29, 2009 4:23 AM by AllenMWhite | 3 Comments Filed under: Database Administration, SQL Server 2008

• Tracking Deprecated Features

  This week I'm in Brno, Czech Republic leading an App Compat seminar for Microsoft clients here, and one of the things we need to look for in their applications is the use of deprecated features. I was poking around the sys.os_performance_counters DMV Read More... Posted Tuesday, May 26, 2009 7:03 AM by AllenMWhite | 5 Comments Filed under: Database Administration, SQL Server 2008

• [Nashville] Presentation: Administering SQL Server 2008

  As many of you know I run marathons. My next one is on Saturday in Nashville, the Country Music Marathon . Timing sometimes is our best asset, and so it is here in that the Nashville SQL Server Users Group is meeting on Friday at noon. They were kind Read More... Posted Thursday, April 23, 2009 11:26 AM by AllenMWhite | 2 Comments Filed under: Database Administration, Speaking, SQL Server 2008, User Group Meetings

• [Ohio] A Day in the Life of the DBA 2008

  We are pleased to invite you to the October 9th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Read More... Posted Monday, October 06, 2008 9:37 AM by AllenMWhite | 1 Comments Filed under: Database Administration, SQL Server 2008, User Group Meetings

• Partition Wizard Makes it Simple

  The partitioned table was one of the great new features of SQL Server 2005. We could now manage data based on some range data, usually a date value, and keep the different ranges in separate physical files, and use rolling range scripts to move old data Read More... Posted Monday, July 28, 2008 9:44 AM by AllenMWhite | 0 Comments Filed under: Database Administration, SQL Server 2008