PASS Summit 2013 Keynote, Day 1

Today is the first full day of the PASS Summit 2013 conference. This year I’m again joining the blogger table and will be live blogging throughout the opening ceremonies and the keynote. This year I’m sitting between Colin Stasiuk and Andy Warren.

I’ll be updating this post periodically through the keynote.

7:59 am: Found my seat and got wired up. It appears that coffee will not be served until after the keynote. In related news, most of the room is already asleep. I’ve appealed to Twitter in hopes that someone might kindly bring me some Starbucks.

8:28 am: Giving some love to SQL Saturday via a brief video presentation. Showing the locations of SQL Saturday events around the world using Power Map, which really drives home how much reach these events really have.

8:42 am: Interesting analogy. Quentin asserts that the relationship between on-prem storage/processing and the cloud as being similar to the relationship between brick-and-mortar stores and online retailers. E-commerce did not end retail stores, and similarly, the cloud will not eliminate the need for on-prem data.

8:51 am: Tracy Daugherty takes the stage to demonstrate in-memory capabilities of SQL Server 2014. He demonstrates an implementation of in-memory technology on a fictional online store, showing the before-and-after query times when adding memory optimization to a key table. Queries taking several seconds occur almost instantaneously.

9:02 am: On-prem database backup to Azure? I’m interested. Tracy shows the new UI feature where you can select URL as a destination for a backup. Also, new encryption options available in 2014. Also, automatic log backups on SQL Azure? Tracy also shows the new feature (available via free download) that allows you to backup databases in older versions of SQL Server to Azure.

9:09 am: Oops. Network failure during the demo is a perfect example of why you can’t wholly rely on the cloud for the success of your business.

9:28 am: After 20 minutes of mostly marketing hype, it looks like we’re going to see more demos. A little dose of Power BI – using Power Query to bring together disconnected sets of data into a unified view, a function that can be performed by non-technical business users. Brief glimpse of Power BI on mobile devices, even fruity ones.

9:40 am: Impressive… querying a database using plain English. “Show number of calls per capita by country” yields a valid set of data. Adding “as map” changes the output from bar chart to map. We’re breezing over the details of how this works, but if it really works as shown, this is going to be a game changer for self-service BI. Hopefully not just a rehash of English Query. Go to PowerBI.com to sign up and use this.

9:48 am: That’s a wrap. Nothing earth-shattering here. Most interesting to the general populous is the release of SQL Server 2014 CTP2. A few cool things with Power BI as well, which I’ve still yet to explore.