Today’s keynote with Quentin Clark starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s keynote (“a demo-packed adventure across SQL Server solutions that span traditional boxed software, appliances and cloud”) see the SQLPASS.org page on Keynotes.
8:15 Short series of videos promoting various events, clinics, and more here at the Summit. Remember the live streamed Women in Technology Luncheon at 11:30PT today!
8:17 Bill Graziano got big cheers for his kilt, and that’s what he started off about….SQL Kilt Day! They’ve thoughtfully provided a face cutout tableau of three men in kilts, so non-kilt wearers can get their picture taken.
LadyRuna on Twitter: “Saw @midnightDBA – both of them – in a #sqlkilt on the live broadcast :)”
8:20 Recognizing volunteers, asked them to stand for applause. In particular recognized Tim Radny (speaker, mentor, SQL Saturday planner, regional mentor, Summit abstract review team) and Jack Corbett (SQLRally sponsorship and programming, chapter leader, sumit program committee, nomination committee, and SQL Saturday leader). Time for the PASSion award – Lori Edwards!!! Program committee, Served on Election review committee, hard working volunteer!
8:22 And now the Governance and Financials section. I’ll let you follow along on the stream for this.
8:26 Series of short videos about what Summit attendees are excited about for the upcoming SQL Server 2012 (codename “Denali”).
8:29 Quentin Clark, corporate VP of Microsoft, walks in to a snippet of “Livin on the Edge”. We’re talking SQL 2012 today, and that’s exactly what we want to hear about.
There are four server cabinets running up on the stage…in the pauses, you can hear the low roar they’re putting out. Quentin starts “The fantastic 12 of SQL2012”.
8:37 Introduces Bob Erickson, Exec VP of Interlink Transport tech. The entire blogger table instantly starts checking email, twitter, and Google+. It’s nothing personal, Bob. Basic message: “We have a big business. Outages are bad.”
Brent Ozar on Twitter: “Attendees: think of this #sqlpass guest speaker as your boss’s boss’s boss. He’s talking abotu why he wants SQL 2012. That’s cool.”
[Good way to put it.]
Demo (someone help me with this presenter’s name!) of AlwaysOn. Showing us Availability Groups in AlwaysOn. Cheers from the blogger’s table when completed. “The great thing about this is when something goes wrong, it’s right in your face.”
8:48 “2. Blazing Fast Performance” Performance enhancements – RDBMSs, SSAS, SSIS; and ColumnStore Index. THIS is good stuff. No demos, but that’s cool.
“3. Rapid Data Exloration” … Power View + PowerPivot; Administrtion from SharePoint; Reporting Alerts. I particulary like the reporting alerts, this is something I’ve seen a need for in my org.
“5. Credible, consistent Data”
8:53 Lara Rubbelke (@SQLgal) up on stage to demonstrate SQL 2012. First demonstrating a report that takes a very long time. Brought COlumnstore into the enegine in SQL 2012, so we can create a new kind of index: COlumnstore index. Allows us to have blazing fast perofrmance on data warehouse workloads…in the end my datawarehouse query’s going to scream. She’s creating it with T-SQL (big cheers from bloggers). Lara gave on-server and in-cloud options. Again, I really like the emphasis they’re placing on options, in stead of their historical “YOU MUST USE CLOUD OR DIE JOBLESS” feel of the message.
After setting this up, she ran her query, and it was indeed lightning fast…brought it from 45 to .31 seconds using the colmnstore index. <applause> We like fast, we like T-SQL, we like indexes, and we certainly like Lara.
9:00 Data alerts – Just like any other alert, define what you want to be alerted on, and how you want to be alerted.
“6. Organizational Compliance.” Sean will be paying attention to this one, he’s in a high-compliance field. Expanded audit, user-defined server roles…INteresting!
“7. Peace of Mind” Production simulated app testing (THANK YOU for putting an emphasis on this, so companies know they shoud do it!!), system center advisor and management packs, and expanded support – premiere mission critical.
9:08 “8. scalable data warehousing”. “SQL Server Appliances”, configured for their internal cloud New presenter on SQL Server Appliances (they won’t keep the name up long enough!)
@SQLChicken: “Fantastic 8 of 12: Herrrrre’s appliances! This is exciting stuff. I’ll be working appliences Pod after keynote, come by!”
Showing us a Business Data Warehouse appliance onstage, and a “Business Decision Appliance”.
@Datachick: “Both DELL and HP announce Parallel Data Warehouse appliances today.”
@SQLChicken: “20 minutes from boot time to loading data using BDW appliance. Telling you, this stuff is slick.”
@GarethSwan: “We had one of those in the office to play with…NICE stuff.”
9:15 Enterprise Database Consolidation Appliance – appears to be one of the server racks. Quote onscreen: “As the appliance is pre-built, pre-assembled, pre-tested, this has the potential to help us deploy in days versus weeks or months.” brian knight, pragmatic works
@SQLBalls: Private Cloud Appliance for OLTP Dtabases just announced at #sqlpass
Onscreen: “As the appliance is pre-built, pre-assembled, pre-tested, this has the potential to help us deploy in days versus weeks or months.” Brian Knight, Pragmatic Works
9:20 “10. Extend any data, anywhere” ANNOUNCING ODBC Drivers for Linux
<surprise applause> <clickety clicketyCLICKETYCLICKETYCLICKETYCLICKETYCLICKETY>
Sean: “For a lot of shops, what he’s talking about is a BIG DEAL.”
Beyond Relational: FileTable, 2d spatial, semantic search.
9:22 Michael Rys – “Deep Insights Beyond” T-SQL demo of Semantic Search. Good demo…again, we like T-SQL and COOL NEW SQL THINGS!
Side Note: This is the year of Zoomit – if you use it, you’re in. If you don’t, you’re enemy #1.
9:29: 11. Optimized Productivity: SQL Server Data Tools (“Juneau”), Unified across DB and BI, Deployment and Targeting Freedom. “Express LocalDB is a fully embeddable version of the engine that you can deploy as part of your application.” Don’t we already have that? I’ll be interested to see how this differs.
New presenter: Nicholas Dritsas – Cloud Possibilities (SQL Server + SQL Azure). He’s already playing the crowd, pointing out his use of Zoomit. We cheerfully applaud.
Sean: “This presenter needs to be held.”
@BrentO: “This integration between developer tooling, on-premise services, and cloud services is a big edge for Microsoft.
[Yeah, that’s what I said. But you said it better.]@SQLChicken: “As much as we jest about #cloud, it is pretty coll being able to extend to cloud from on-premises and back fairly easily”
9:40 For SQL Azure Federation, Introducting Sr Program Manager Lead Cihan Biyikoglu. With Federations, you can power this environment and administrators can [fiddle with the dials to] repartition the database tier without any downtime.”
@retracement “Now Federations is one cloud technology that I think is totally AWESOME!”
9:47: Announcing next SQL Azure SR, coming end of year:
- sql azure federation
- new management experience
- db size increased to 150Gb
New CTPs available today:
- SQL Azure Reporting CTP
- SQL Azure Datay Sync CTP
@JDanton: Execution plans in Azure. Nice.
Wrapup time.
Thanks for coming, all! Be SURE you don’t miss tomorrow’s keynote with Dr. DeWitt!
-Jen McCown, http://www.MidnightDBA.com/Jen
Golly, I like you guys too!