SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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… Read more

0 comments, 817 reads

Posted in Allen White on 19 September 2011

Check the Default Database Setting for your Admin Accounts

Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor venue, Blossom Music Center, a client called with a problem. The databases on his principal production server had failed over to the mirror server, and now he couldn't connect… Read more

1 comments, 1,647 reads

Posted in Allen White on 31 August 2011

[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 Management using PowerShell.… Read more

0 comments, 715 reads

Posted in Allen White on 22 August 2011

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 procedures I use… Read more

1 comments, 1,975 reads

Posted in Allen White on 21 August 2011

[OT] On Community

Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun, sometimes frustrating, but a very rewarding experience.

My first PASS conference was in the fall of 2003, and I've attended every one since then. The PASS community, as I've… Read more

0 comments, 582 reads

Posted in Allen White on 11 August 2011

[Speaking] Presenting at AITP Region 18 IT Con

The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an IT Professional track, a Development track and a Career Development track. I'll be presenting two sessions in the IT Professional track.

Gather SQL Server Performance Data with PowerShell

We all… Read more

0 comments, 715 reads

Posted in Allen White on 16 June 2011

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 felt it'd be useful to understand the SMO process… Read more

0 comments, 3,620 reads

Posted in Allen White on 3 June 2011

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 2008 they added Transparent Data Encryption. Both solutions work… Read more

1 comments, 1,971 reads

Posted in Allen White on 31 May 2011

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 using VM Workstation for my… Read more

0 comments, 1,223 reads

Posted in Allen White on 26 May 2011

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 and… Read more

0 comments, 1,073 reads

Posted in Allen White on 25 May 2011

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 it's absolutely… Read more

0 comments, 1,426 reads

Posted in Allen White on 21 May 2011

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 database, select Programmability, then… Read more

2 comments, 1,255 reads

Posted in Allen White on 20 May 2011

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 you set this to Windows Authentication, but my experience… Read more

1 comments, 2,485 reads

Posted in Allen White on 19 May 2011

PASS Summit Session Selection is Open

This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how well this is received, since it'll be the people who are actively online and aware of the process who'll influence the sessions that are selected.

I've submitted four regular sessions… Read more

0 comments, 818 reads

Posted in Allen White on 11 May 2011

Don't Do This

In working on applications at client sites you tend to come across code that makes you think "what were they thinking"? This week I found one that just made me do the "facepalm": select top 1 @_StateTrueKey = OverEngineeredKey from OverEngineered where...(read more)

Read more

0 comments, 860 reads

Posted in Allen White on 25 June 2010

PowerShell Script to Remove Old Backups

A Twitter user asked for a script to remove old backups, and I had one I built back in February, so here it is (use at your own risk): #rmbackup.ps1 # Removes database and transaction log backups # # Change log: # February 2, 2010: Allen White # Initial...(read…

Read more

0 comments, 1,070 reads

Posted in Allen White on 24 June 2010

Lots of Speaking Engagements Coming Up

SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH - XQuery Basics and Gather SQL Server Performance Data with PowerShell . The event takes place at Goodwill Columbus, 1331 Edgehill...(read more)

Read more

0 comments, 592 reads

Posted in Allen White on 23 June 2010

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)

Read more

0 comments, 697 reads

Posted in Allen White on 13 June 2010

Service Broker Solutions - Don't Forget the Basics

After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it can be to implement and get it really working as expected. First, understand the technology. There are...(read more)

Read more

1 comments, 847 reads

Posted in Allen White on 3 April 2010

Document, Document, Document

A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation. Now, I'm not just talking about documenting the logic, system flow and data and structure changes, I'm also talking about...(read more)

Read more

0 comments, 1,156 reads

Posted in Allen White on 13 March 2010

Older posts