Search results matching tags 'PASS' and 'keynotes'

Blogging from the PASS Keynote : 2010-11-09

AaronBertrand — Tue, 09 Nov 2010 17:15:00 GMT

The keynote starts off with a tine Turner impersonator (or maybe it really was Tina?):

Rushabh Mehta (donning the Tina wig) delivers the first segment of the keynote, telling the SQL Server community that we are "simply the best." He then introduces the Board of Directors and founding partners. He tells us the Board of Directors will be available for chatting at the Meet & Greet on Thursday from 5:30 - 7:30 PM, and that PASS is eager to hear about our ideas for how to improve the organization and its events.

This Summit has 3,807 attendees from 48 countries. And there are over 4,500 registrants from 49 countries for the streaming keynotes and WIT event. There are 191 speakers, 44 of them MVPs, and 111 out of the 168 sessions are 300+ level. And for the first time, the DVDs will include all 168 sessions *AND* the pre- and post-con recordings. (And probably David DeWitt's keynote again, if history is any indication.)

Exhibitors are an important part of PASS, obviously. Visit the Exhibit Hall (which sold out for the first time ever). The hours are Tuesday from 10:45 to 4:00 and Wednesday from 10:45 to 5:00. Also all attendees are welcome to the Exhibit Hall Reception tonight from 6 - 8.

Mark Souza comes on stage and talks about Ask the Experts, SQL Clinic, and several ways you can interact with the MVPs and Microsoft employees that are here at PASS. One of the giveaways each day will be an XBox Kinect. They give away an Alienware laptop after placing an envelope under a random chair in the crowd.

Before Ted Kummert takes the stage, there is an entertaining video about the evolution of SQL Server - from breaking out of the Sybase code ($100 million/yr) to SQL Server 2008 R2 ($3 billion/yr). Ted comes on stage and exclaims that this is the largest PASS ever. He talks about the focus of SQL Server over the years, and more importantly, the future. He explains that SQL Server 2008 R2 Parallel Data Warehouse (formerly "Project Madison") is available now, and will be shipping on appliance servers in December.

Jesse Fountain (Principal Program Manager, CAT) comes on stage and shows off two nice racks loaded up with PDW, and then explains a new CREATE TABLE statement that incorporates the CLUSTERED INDEX, HASHING KEY and PARTITION boundaries all in the WITH clause - looks like very simplified syntax compared to setting up partitioning today. Then he demonstrates an 800 billion row query that runs in 19 seconds.

Paulo Resende, Chief Architect, Bank of America comes on stage and talks about he implemented SQL Server solutions to reduce costs, improve performance, and be more agile.

Dave Mariani, VP Development at Yahoo, talks about ad distribution for 600 million users (3.5 billion events, amounting to 1.2 TB of data per day). He discusses using a 12 TB cube in Analysis Services for data mining to deliver relevant ads and optimize the revenue of their advertising customers.

Ted announces updates to support & service offerings such as Premier Mission Critical, and the new Microsoft Critical Advantage Program - end-to-end support and service starting with Parallel Data Warehouse appliances.

Then Ted talks about the beta for Codename "Atlanta" - an agent that runs on your server and uploads various performance and health metrics (not actual data) about your SQL Server 2008 and SQL Server 2008 R2 to a secure service in the cloud. You can log in to the portal to view various metrics about your servers, but it also assesses best practices and configurations to provides guidance on preventing incidents, and better enables support to analyze your systems in case you do have an incident.

Bob Ward comes on stage and demonstrates troubleshooting the dreaded "Cannot generate SSPI Context" error message. He says that Atlanta is all about preventing problems, being proactive, and minimizing downtime. He shows that the Atlanta user interface has pointed out an issue in Kerberos configuration and actually guides him to a KB article that solves the problem.

You can sign up for Microsoft Atlanta at http://www.microsoftatlanta.com/ (requires a Windows Live ID, and Silverlight once signed in).

If you're at PASS and you want to learn more about Atlanta, you can attend the following spots:

Breakout Session (DBA226M) Tue 10:15 AM in room 612
SQL Clinic

o   Come talk to the product team and the guys behind the rules
o   Product team (Paul Mestemaker, Tim Ng, Lorenzo Rizzi)
o   Knowledge v-team (Bob Ward, Suresh Kandoth, Adam Saxton)

2 Product Pavilion Showcase Theater Demos

o Tue 6:00pm – 6:30pm
o Wed 1:30pm – 2:00pm

2 Focus Groups (please attend to influence our Wave 3 planning!)

o   FG#1 – Room 305 – Wed 3:00pm – 4:30pm
o   FG#2 – Room 305 – Thu 4:30pm – 6:00pm
o   If you know you’d like to come, RSVP to TimNg@microsoft.com. If you have some free time and want to stop by, we’ll allow you in if there is room. We are targeting about ~8-10 people per focus group.

Next, Ted talks about the cloud, and Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS). He says the key benefits to SQL Azure in terms of PaaS are that it is self-managed, has elastic scale, and is both agile and familiar. He talks about the new CTPs that were announced at PDC : Web Admin, Reporting, and Data Sync. He talks about Windows Azure Marketplace DataMarket - where you can get both public domain and commercial data sets to pull into your own applications. Adam Wilson (SQL Azure PM) demonstrates this feature for a fictional bike store, which pulls sales data and correlates it to weather data pulled from the Marketplace.

Finally, Ted talks about what we're all waiting for: SQL Server Codename "Denali" - the next version of SQL Server. The press release is available here:

http://www.microsoft.com/Presspass/press/2010/nov10/11-09PASS10PR.mspx

Quentin Clark et. al. will be providing much more detailed information about Denali in tomorrow's keynote, but we are getting some high-level information from Ted today. He talks about Mission Critical, Productivity, and Pervasive Insight.

Amir Netz comes on stage to discuss enhancements in PowerPivot for Denali, and shows off Excel browsing 100 million rows of data. It's very fast and impressive, though I'm curious what type of machine that is really running on. I think a lot of business users are stuck on decrepit hardware that may not exhibit such smooth performance.

Then Amir shows how Visual Studio, Management Studio and BIDS have been combined into a single, unified interface, and how when looking at data on a server, the interface can sort and filter 2 billion rows "in a flash." Again, quite impressive, and garnered a separate round of applause. Then he shows updating reports in real time, representing scanning a trillion rows per minute. Then he talks about a new columnar storage mechanism in Denali. Yes, you heard that right, we're getting vertipaq technologies in the next version of SQL Server.

Next, they talk about Codename "Crescent" - data visualization feature that allows you to represent data in a report in many different ways, including animated charts that can show, for example, the evolution of movie sales over time. Another round of applause here for the animated chart, and what he called "instant replay" - which allows him to slow-motion the chart animation. Then he shows live data being updated inside a PowerPoint presentation - I don't think I'll be able to pull this off using Keynote. I can't really describe this for you, I'm just going to have to figure it out and build out a demo.

The big tech sites already had prepared articles waiting for the press release announcement, where you can read about some of the key features:

ZDNet
The Register

You can download the CTP here, or wait for DVDs available after the keynote tomorrow:

http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx

PASS Keynote, Wednesday: "Delivering on Our Data Platform Vision"

AaronBertrand — Wed, 19 Nov 2008 18:37:00 GMT

The keynote today was delivered by Ted Kummert, Corporate VP, Data and Storage Platform Division at Microsoft.

Before Ted started, Wayne Snyder showed up on stage, sitting on a hog and surrounded by smoke or dry ice or something. He talked about how PASS has grown over the past year in several areas:

chapters (136)
membership (32,000+)
summit + pre-con registrations (60% over last year)

He also talked about the launch of the new sqlpass.org web site, and the fact that membership is now free.

When Wayne was introducing him, he mentioned that Ted once worked at Apple, and that it was a big deal that Microsoft forgave him for that. It struck me as funny, because Apple is not the competitor that Microsoft should fear the most, IMHO.

Ted came on and gave kudos to PASS. He explained how product team members are here for us, and this is much easier to do obviously when the conference is here in Seattle.

How SQL Server 2008 Has "Delivered"

Then he started talking about how SQL Server 2008 has delivered on its four "pillars" in the company's vision for SQL Server and its surrounding technologies.

Enterprise Data Platform
transparent data encryption
policy-based management

Beyond Relational
spatial / geography
filestream
Developer Productivity
entity framework
IntelliSense
Pervasive Insight - data warehouse scale
query processor (star joins)
data compression
partition table parallelism
change data capture
resource governor

Ayad Shommout, Lead Technical DBA of CareGoup Healthcare Systems in Boston, talked about his environment (2000, 2005 and 2008). He explained that he intends to have all 400+ production databases on SQL Server 2008 in the short term, and was an early adopter (went live December 2007). By upgrading alone, without changing any code, they experienced a 25% performance increase. Top three features for Ayad:

PBM - enforce standards and apply best practices across various vendors and ad hoc users.
TDE - sensitive data is encrypted even if backup is stolen.
Audit - HIPAA compliance and can capture all actions.

Ted talked about ICE, an internal 30+TB data warehouse representing a central repository of all events from sources like Exchange, SQL Server, etc.

He also mentioned that the ad center team has what they believe to be two of the largest analysis services cubes in the world (1.8TB & 1.4TB).

Some of the highlights for SQL Server 2008:

Over 1 million downloads.
Nearly 2,500 partners offering solutions.
Fastest growing relational database worldwide.
Fewest vulnerabilities of any enterprise DB (made fun of the "unbreakable folks").
Leading performance benchmarks - TPC-H, TPC-E, Applications (world record for 1TB ETL load in < 30 minutes).

Upcoming "Stuff"

For the future, he talked about three release vehicles that we will see before the next major release of SQL Server (expected in 2011). These are:

Project "Madison"

This is the Datallegro acquisition you may have read about; expected release H12010. There are significant advances in data warehouse capabilities and scale. Jesse Fountain, Program Manager, talked about "massively parallel processing" (MPP), where multiple instances look to the end user like a single instance, allowing the processing power to be distributed across several database servers (kind of sounded like RAC). The fact data was distributed across multiple instances, and dimension tables were replicated to all. This allows each node to compute its local fact data and then the results are merged at a higher level. The demo showed reports pulling data from a 150+TB data warehouse (over 1 trillion rows), utilizing 24 instances of SQL Server (8 cores, 192 total) on Dell 2950s with EMC2 CX4 and 10GB fiber.

SQL Server "Killimanjaro"

These are new manageability capabilities built around SQL Server, tentatively scheduled for H12010. Dan Jones talked about "down payments" in PBM and data collector that enabled the development of what he called the SQL Server "fabric" - a fabric control point in front of multiple environments, providing a bird's eye view of the environment that represents the fabric (servers/instances/applications). He introduced what they are calling the DAC (data application component, not to be confused with dedicated administrator connection), for developing, deploying and managing database applications. In the demo he showed a new "Fabric Explorer" view built into Management Studio, with a report showing instance / DAC health, over- and under-utilized servers (consolidation or load balancing candidates), and storage. The DAC itself is a new deployment package (similar to MSIs) to deploy schema through Visual Studio. It can be created by pointing to an existing database (2000 and up) via a wizard. Once you have created a DAC, you can import it into the fabric, and along with creating the schema and objects it validates that the fabric's policies are not being violated. His final point was that this architecture allows us to manage at scale, improve integration between the developer and the DBA, and make policy monitoring and enforcement more powerful.

Finally, he talked about "managed self-service for BI" with a pretty funny fairy tale. The moral is that IT can't meet all demands, and that end users should be able to make more decisions. So the intent is to empower them to ask more powerful questions from SQL Server using their existing tools (e.g. Excel). He mentioned Gemini, which includes analytics, reporting, and collaboration.

Donald Farmer, complete with angel wings and a magic wand, came to the stage to demo Gemini using Excel. Gemini is an add-in to Excel, and appears as its own ribbon. He mashed up video store data from the data warehouse (10 million rows!) and box office sales data he downloaded from the web, all on the client machine, and the performance of sorting and filtering was astounding. He mashed the data up, and demonstrated new "slicers" that act like visual filters to slice data up showing sales by geography, month, etc. The report he generated was published to SharePoint, and he showed off some of the "social services for data" features, such as voting and stats on the reports themselves. It seems very powerful for the end user.

SQL Data Services

Somewhere in there, Ted explained that the growing team has been working on "the cloud" for two years. He briefly mentioned SQL data services for application developers, and the new Azure Services Platform which was hyped at PDC. The major announcement here was that the public CTP of Microsoft SQL Data Services is now available - also see this link.

Next Version of SQL Server

Unfortunately, Ted was very vague about the next version of SQL Server, only stating that it should be delivered by August 2011.