Author Archives: Allen White

Almost three years ago I left my last employer and embarked on a journey that’s been both wonderful and scary. In the course of three years I’ve helped companies both big and small, and have learned much along the way. … Continue reading

Posted in UpSearchBI | Leave a comment

This year will be my tenth year attending the annual PASS Summit. It’s in Seattle again this year, which to me is important because of the proximity to the Microsoft offices and the people on the SQL Server dev team, … Continue reading

Posted in UpSearchBI | Tagged | Leave a comment

You’d think that providing in-depth SQL Server training on a cruise ship would be an excuse for a vacation disguised as a business trip, but you’d be wrong. This past week I traveled with the founders of SQLCruise, Tim Ford … Continue reading

Posted in UpSearchBI | Leave a comment

There’s a lot of excitement in the SQL Server world right now, with the RTM (Release to Manufacturing) release of SQL Server 2012, and the availability of SQL Server Data Tools (SSDT). My personal speaking schedule has exploded as well. … Continue reading

Posted in Technology Solutions, UpSearchBI, UpSearchSQL | Tagged , , , , , , , , , , | Leave a comment

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 … Continue reading

Posted in UpSearchSQL | Tagged , , | Leave a comment

Yesterday Microsoft released RC0, Release Candidate 0, for download. I downloaded and installed it in a virtual machine, and today started poking around. I haven’t had much time to play with the various CTPs released so far, so I’m not … Continue reading

Posted in UpSearchSQL | Tagged , , | Leave a comment

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 … Continue reading

Posted in UpSearchSQL | Leave a comment

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 … Continue reading

Posted in Technology Solutions, UpSearchSQL | Leave a comment

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 … Continue reading

Posted in Technology Solutions, UpSearchSQL | Leave a comment

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, … Continue reading

Posted in Technology Solutions, UpSearchSQL | Tagged , , , , , , | Leave a comment