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
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 Allen White, Conferences, PASS, performance, Powershell, SMO, Speaking, SQL Connections, SQL Saturday, SQL Server 2012, SSDT
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
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
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 #sqlhelp, Allen White, MVP, Powershell, SMO, T-SQL, UpSearchSQL
Leave a comment
