Author Archives: Allen White
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
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 … Continue reading
Posted in Technology Solutions, UpSearchSQL
Leave a comment
Recently a few people have approached me privately about their careers, and how they can make the changes to allow them to do the kind of work they’d like to do, be it consulting or in a full-time role. (In … Continue reading
Posted in Technology Solutions, UpSearchCoach, UpSearchSQL
Leave a comment
