SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.
You can contact him at jason@statisticsio.com or 469.569.5965
Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless
Before I waste your time, this post will be full of rumor and speculation. I can not confirm a single word in this post as being true. If you are looking for some actual technical content, please see my google reader shared items. If you want to gossip like to high school juniors the day after prom, stick around.
The Bombshell(s) at PDC
I caught this video on Channel 9 with the MSFT VP of cloud, infrastructure and services. His name is Amitabh Srivastava. He states that PDC with be the “coming out party” for his group. We have already talked here about SSDS and cloud databases. BrentO wrote up a nice review on Data Mining in the cloud. Looking at the sessions at PDC, we can see that it will be very cloud intensive. Here are a few sessions of interest to this post:
A Day in the Life of a Cloud Service Developer This session goes beyond the "Hello World" development experience and explores common tasks for serious service developers. These tasks include logging, debugging, deployment, management, and maintenance of individual services. A Lap around Cloud Services Hear about key problems that cloud computing is solving and how these services fit into the Microsoft cloud computing initiatives. Learn about the pillars of the platform, its service lifecycle, and see how they fit with both Microsoft and non-Microsoft technologies. Also, hear about the services roadmap over the next few years.Architecting Services for the CloudFrom design to implementation, building a scalable, available web service is different from building other kinds of applications. This session discusses the impact that designing for the cloud has on all stages of the service lifecycle, and how the Microsoft cloud platform works for you to meet the scaling and availability goals of your service. Also learn how the cloud services platform is architected to isolate and protect your service.
A Day in the Life of a Cloud Service Developer
This session goes beyond the "Hello World" development experience and explores common tasks for serious service developers. These tasks include logging, debugging, deployment, management, and maintenance of individual services.
A Lap around Cloud Services
Hear about key problems that cloud computing is solving and how these services fit into the Microsoft cloud computing initiatives. Learn about the pillars of the platform, its service lifecycle, and see how they fit with both Microsoft and non-Microsoft technologies. Also, hear about the services roadmap over the next few years.
Architecting Services for the Cloud
From design to implementation, building a scalable, available web service is different from building other kinds of applications. This session discusses the impact that designing for the cloud has on all stages of the service lifecycle, and how the Microsoft cloud platform works for you to meet the scaling and availability goals of your service. Also learn how the cloud services platform is architected to isolate and protect your service.
On top of that, there are tons of sessions on live services, Mesh, and, most relevant to us, SSDS.
The Missing Link
What is missing? Surely, Microsoft doesn’t expect developers to write a web app\service and connect to SSDS over the tubes even with SSL. The missing link is a cloud based application development platform. This has to be coming and I predict it to be announced at PDC. What remains to be seen is how the infrastructure work. I could see a shared hosting model with Windows Server 2008 VM’s on hyper-v or a “real” cloud platform that is something like .Net as a Service. Your guess is as good as mine unless you already know but are under NDA :) Both Amazon EC2 and Google AppEngine both took the service route.
I am not going to PDC but I will be watching closely. Have you heard anything confirmed or unconfirmed?
P.S. Where is the 2nd largest software vendor in this cloud thingy-ma-bobber?
Edit: an unrelated cloud OS but funny Arrington bash can be found by clicking here.
The podcast from Brian Moran and Bill Bosworth provides good insight into the the deal. Click here.
Here is an excerpt for the forthcoming press release:
Quest Software is announcing its new partnership with Solid Quality Mentors, a global provider of education and solutions for Microsoft data and development platforms. This is not a sales reseller relationship, but a true joining of forces to provide new real value to the SQL Server community. Specifically, our plans are to work together in three specific areas: community outreach, product development and professional services. Community outreach: The companies will work together on joint programs including speaking at Quest and Solid Quality Mentors events, authoring technical briefs and white papers and providing joint webcasts and podcasts for the SQL Server community. Product development: Quest will collaborate with Solid Quality Mentors on product road maps and feature sets, drawing on their combined experience of real-world SQL Server challenges to provide the best solutions possible for SQL Server DBAs and developers. Professional services: Quest customers will benefit from consulting services offered by Solid Quality Mentors to help implement tools and manage complex environments.
Quest Software is announcing its new partnership with Solid Quality Mentors, a global provider of education and solutions for Microsoft data and development platforms.
This is not a sales reseller relationship, but a true joining of forces to provide new real value to the SQL Server community. Specifically, our plans are to work together in three specific areas: community outreach, product development and professional services.
Community outreach: The companies will work together on joint programs including speaking at Quest and Solid Quality Mentors events, authoring technical briefs and white papers and providing joint webcasts and podcasts for the SQL Server community.
Product development: Quest will collaborate with Solid Quality Mentors on product road maps and feature sets, drawing on their combined experience of real-world SQL Server challenges to provide the best solutions possible for SQL Server DBAs and developers.
Professional services: Quest customers will benefit from consulting services offered by Solid Quality Mentors to help implement tools and manage complex environments.
Peep http://quest.com Monday for more details.
My crack investigative journalism skills web surfing has brought me to two more tidbits of info:
Benjamin Figueroa, Microsoft IT Pro Evangelist, is "Preparing contents for SQL Server 2008 RTM launch".
While a tweet is hardly scientific prove, it does give a little more weight to the rumor we heard yesterday.
Also to paraphrase Buck Woody, the SQL team has nothing but time now so expect more blogging. Read the full blog for yourself to judge the accuracy of my translation.
Have a great weekend!
Some of the MSFT employees at TechED told me that SQL Server 2008 RC0 will hit next week. I suspect Tuesday so it can be announced in TechEd ITPro keynote. That is all.
Buck Woody spoke of features not currently in the FEB CTP. A reader pointed this out to him and he responded in this post. So we can infer two things: RC0 is going to pop any time now. There are going to be new features.
I don't expect there to be any huge new features. Anyone have any rumors? I would also guess that they will have an RC1 in late July\early August. If all goes well, RTM in September. This is all speculation, of course. They may go straight to RTM if RC0 is solid. To be honest, FEB CTP has been pretty solid for me. I have not put it under load but I have tried some pretty crazy things with it.
Click here to see the existing public new features in SQL Server 2008: http://www.microsoft.com/sqlserver/2008/en/us/overview.aspx