SQL Server 'Denali' highlights
On Wednesday at the two Adelaide sessions of the PDC Roadshow I gave the world’s fastest overview of interesting things coming in the next version of SQL Server – codenamed ‘Denali’.
I’d even whipped up some PowerPoint slides, but due to time constraints didn’t get to share them with everyone, so I’ve summarised the main points here:
- SQL Server 2008 R2 Parallel Data Warehouse
- Microsoft Critical Advantage Program
- SQL Azure Reporting
- SQL Azure
- Windows Azure Marketplace DataMarket
Areas unchanged in CTP1
- Analysis Services
- Data Quality Services
- Reporting Services
- Service Broker
SQL Server Engine
- SMSS uses VS2010 shell
- Transact-SQL debugging and IntelliSense
- Transact-SQL Snippets
- Contained databases
- SEQUENCE objects
- Circular arc segment (spatial)
- User-defined server roles
SQL Server Integration Services
- “Biggest change since 2005”
- New deployment model
- Object Impact and Data Lineage Analysis
- Dependency Designer
- Merge and Merge Join memory improvements
- Designer enhancements
- Edit disconnected components
- Data correction component
- Runs on your SQL Server system Uploading information to cloud service
- Performance, etc
- Browse using a dashboard
- Give access to Microsoft Support
- Web-based reporting experience that offers rich visualization to let you project the story about your data to end users and other business users
Microsoft Certified Masters
- Just sit the exams (don’t have to do all the training)
- No testing centres in Australia yet
If you’re interested in finding out about these features (and more), Roger Noble and Rob Farley will be talking all about ‘Denali’ at this month’s Adelaide SQL User Group (Tuesday 23rd November).
Microsoft SQL Server code-named 'Denali' - CTP1
Wednesday morning I’ll be giving a quick summary of all the new announcements from the 2010 PASS Summit in Seattle (courtesy of LobsterPot’s on-the-spot reporters Rob and Roger) to the Adelaide leg of the PDC10 Roadshow.
In preparation for that, I did a quick search for any Denali titbits, and discovered the CTP is now publicly available. I’m downloading as we speak/type. Annoyingly, the Release Notes link is broken at the moment. Hopefully that gets fixed soon.
My top predictions for new features (seeing as I haven’t got it installed yet to find out)
- Failover cluster support for Windows Phone 7
- Query optimiser support for X-Box 360 Kinect
Ha.. though actually I can see some possible use of Kinect with reporting and data mining in the future.. That would be cool.
Maybe they’d have to call that “Minority Report-ing Services” 😀
Take your partner by the hand..
If LobsterPot Solutions had a theme song, one pretty obvious choice would be Rock Lobster by The B52s.
It looks like we now have another option!
First Microsoft Partner with Gold Competency in Australia - Well done Rob, Ben, Roger, Ashley (and me!).
Also a big welcome to Ashley, our most recent Lobster to jump in the pot 😀