Getting Excited: SQLBits is Coming!

• by Allen White

• Allen White

Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...

2011-09-19

849 reads

Check the Default Database Setting for your Admin Accounts

• by Allen White

• Allen White

Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...

2011-08-31

1,768 reads

[Speaking] Lots of Speaking Engagements in September and October

• by Allen White

• Allen White

As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...

2011-08-22

750 reads

Pull Performance Data from Perfmon Logs with PowerShell

• by Allen White

• Allen White

For the last year and a half or so I've been presenting a session on how to gather perfmon data...

2011-08-21

2,049 reads

[OT] On Community

• by Allen White

• Allen White

Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...

2011-08-11

610 reads

[Speaking] Presenting at AITP Region 18 IT Con

• by Allen White

• Allen White

The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an...

2011-06-16

756 reads

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

• by Allen White

• Allen White

Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...

2011-06-03

4,383 reads

What Encryption Algorithms Are You Using?

• by Allen White

• Allen White

Security is an important consideration when designing a database application. Who can get access to what data? How much damage...

2011-05-31

2,088 reads

Endpoints Need Privileges Too

• by Allen White

• Allen White

Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...

2011-05-26

1,248 reads

Monitor your SQL Server Agent Proxies Using PowerShell

• by Allen White

• Allen White

Over time it's easy to lose track of the things you set up to get work done. As a consultant,...

2011-05-25

1,104 reads