Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


November 2007

SQL Server 2008: Goodbye, Database; Hello, Data Platform

Microsoft products support Microsoft products
RSS
Subscribe to Windows IT Pro | See More SQL Server and Database Articles Here | Reprints
Or get the Monthly Online Pass—only $5.95 a month!
SideBar    Microsoft System Center Data Protection Manager 2007 Licensing

After attending the annual Professional Association of SQL Server (PASS) conference in September and learning about the new features of Microsoft SQL Server 2008, I recalled a July 2006 blog entry by Kevin Kline (“It Depends on How You Define ‘Whining,’” InstantDoc ID 53930). Kevin bemoaned the fact that SQL Server has become so complex that even experts can’t master all of its vast functionality.

As president of PASS and a columnist for SQL Server Magazine, Kevin knows whereof he speaks. And Microsoft has a big job leveraging the strength of that complexity while it’s also positioning SQL Server 2008 as a “data platform” rather than simply a database engine. At PASS, I talked with Ted Kummert, Microsoft corporate vice president of the Data and Storage Platform Division, about Microsoft’s strategy of positioning SQL Server as a data platform—which, by no coincidence, is similar to how Microsoft Exchange Server is being positioned as a Unified Communications platform and Microsoft Forefront is being positioned as a security platform.

From Database to Data Platform
IT organizations that use Microsoft technologies can’t avoid SQL Server even if they want to. Not only are business applications built to access SQL Server databases, but an ever-growing number of Microsoft products— from Windows Server Update Services (WSUS) to System Center, Forefront, and SharePoint—require it on the back end as well. The advantage of SQL Server as a data platform underlying everything is that once you know SQL Server fundamentals, you can apply them in a variety of scenarios.

When I asked Ted about the thinking behind the shift from database to data platform, he said, “What [customers] want is to get some job done, and if they have to learn less to get that job done, that’s a good thing for them. We think that’s a part of the value proposition of the complete data platform. You deploy it in various workloads: You have it underneath a packaged application; you have it under a custom application; you have it in BI. You have a set of skills and knowledge you can leverage across your organization, and you don’t have to have people learn new things just to get the job done.”

To enable SQL Server to be this all-encompassing platform, you need the tools to manage the databases, and you need those tools to be as familiar as the database engine. To that end, SQL Server 2008 integrates with the System Center management platform model and embraces the Dynamic Systems Initiative (DSI). (For details about DSI, see “Radically Simplify IT,” April 2006, InstantDoc ID 49503, and “System Center Puts DSI into Practice,” March 2007, InstantDoc ID 94969, for my interviews with Kirill Tatarinov, Microsoft corporate vice president of the Windows Enterprise Management Division.)

Ted explained, “Fitting in with System Center, we are delivering all the manageability in SQL Server 2008 as part of that framework. We’ve talked a lot about DSI and that vision. A big part of it is a policy-based administration model for everything in all of our products and infrastructure solutions. We call [SQL Server’s] implementation [of policy-based management] the Declarative Management Framework [DMF]. We’re very focused on delivering solutions that work well with System Center.”

Ted gave an example. “Specifically, you’ll be able to see the state of your systems. You’ll go to Operations Manager and say, ‘These three systems are out of policy,’ and it will call DMF to put them back in state.”

Another example is the freshly released Microsoft System Center Data Protection Manager 2007 (DPM), which supports SQL Server (plus SharePoint, Exchange, Microsoft Virtual Server 2005, Windows XP, and Windows Vista) and which Microsoft’s Jason Buffington demonstrated at PASS. (Jason also explained DPM licensing to me; for details, see the Web-exclusive sidebar “Microsoft System Center Data Protection Manager 2007 Licensing,” www.windowsitpro.com, InstantDoc ID 97230.) Being true to the platform model, DPM not only backs up SQL Server, but it also incorporates a free instance of SQL Server 2005 under the covers for reporting.

Why Platforms?
Clearly it’s in Microsoft’s interest to propagate SQL Server in all of its products: It’s hard to switch to a different database and eliminate SQL Server if core technologies such as WSUS require it. But Microsoft sees the idea of its products being “platforms” as a win for its customers, too: The more Microsoft’s products to support each other, the less you have to learn when you implement a Microsoft product or version.

I’d like to hear what you think. How will Microsoft’s platform strategy affect you and your organization?

End of Article



Reader Comments
SQL 2005 took a step backwards with its lack of import tool (not being able to access an Oracle ODBC), the generate SQL script looks like it was written by a kindergarten kid compared to the clean structure of a script from SQL 2000, the query builder is not as good. Neither of them imports with the keys and indexes. For the users that have small installations it is pretty poor. I hope that SQL 2008 will be better.

Kind regards,

Peter

peterfairchild November 16, 2007 (Article Rating: )


A lot of third party applications run on SQL Express. Are these developers going to ba ablt to simply plug their applications into the platform? Should the platform become compromised, so does your data. Too many eggs in one basket, too much integration and reliance on other Microsoft software being in place and to the right release and patch level. But that's Microsoft trying to rebuild a monopoly in the DB space, just like it did in the OS.

ccontessa November 16, 2007 (Article Rating: )


FUYUEP

pascualdeleon November 19, 2007 (Article Rating: )


You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
The Memory-Optimization Hoax

Don't believe the hype. At best, RAM optimizers have no effect. At worst, they seriously degrade performance. ...

How can I uninstall the Microsoft Java Virtual Machine (JVM) from Windows XP?

...

Managing Virtual Sprawl

As some wise person once said, nothing is ever truly free. Such is the case with VMs, which can quickly mutate from a cost-reducing Dr. Jekyll into a time-consuming, profligate nightmare that would do Mr. Hyde proud. ...


Related Articles SQL Server Videos on YouTube

What Does Microsoft's Web Strategy Mean to You?

System Center Puts DSI into Practice

Radically Simplify IT

SQL Server and Database Whitepapers SQL Server® 2005 – 64-Bit Migration Best Practices

It’s What You Make IT

Database Professionals: Experience Profile and Need Gaps in Development and Database Tools

Related Events Check out our list of Free Email Newsletters!

SQL Server and Database eBooks SQL Server Administration for Oracle DBAs

Taking Control: Monitoring the Windows Platform Proactively

A Guide to Windows Performance Tuning

Related SQL Server and Database Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Critical Challenges of ESI & Email Retention
Are you storing too much electronic information? Get expert legal advice and better understanding of what you are required to do as an IT professional.

Become a fan of Windows IT Pro on Facebook!
Join us on Facebook and be a fan of Windows IT Pro!

Sustainable Compliance: Are You Having a Resource Crisis?
Read this white paper to examine trends in compliance and security management and review approaches to reducing the cost and operational burden of compliance.

Rev Up Your IT Know-How with Our Recharged Magazine!
The improved Windows IT Pro provides trusted IT content with an enhanced new look and functionality! Get comprehensive coverage of industry topics, expert advice, and real-world solutions—PLUS access to over 10,000 articles online. Order today!

Get It All with Windows IT Pro VIP
Stock your IT toolbox with every solution ever printed in Windows IT Pro and SQL Server Magazine plus bonus Web-exclusive content on hot topics. Subscribe to receive the VIP CD and a subscription to your choice of Windows IT Pro or SQL Server Magazine!



Order Your Fundamentals CD Today!
Gain an introduction to Exchange, learn server security requirements, and understand how unified communications can play a role in your messaging strategies with this free Exchange CD.
Windows IT Pro Home Register About Us Affiliates / Licensing Media Kit Contact Us/Customer Service  
SQL Connected Home IT Library SuperSite FAQ Wininfo News
Europe Edition Office & SharePoint Pro Windows Dev Pro Windows Excavator 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing