Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  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 be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
Battery Life Issues Almost Certainly Not Windows 7's Fault

While Microsoft is still investigating a notebook battery life issue that was supposedly caused by Windows 7, some interesting trends have emerged. ...

Confirmed: Battery Life Issues Not Windows 7's Fault

Microsoft on Monday issued a lengthy statement about the recent Windows 7 battery controversy, echoing my assessment from earlier in the day, but backing it up with hard, cold evidence. Put simply, Windows 7 is not responsible for any battery life issues ...

Getting your iPhone to Sync with Exchange 2003

Follow these steps to use an iPhone with Exchange. ...


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

Related Events SharePointPro 2010 Summit & Expo

Improving Your Data Integration Performance

Is SharePoint 2010 Ready For Enterprise Content Management?

Check out our list of Free Email Newsletters!

SQL Server and Database eBooks Safeguarding Your Windows Servers

SQL Server Administration for Oracle DBAs

Taking Control: Monitoring the Windows Platform Proactively

Related SQL Server and Database Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2010 Penton Media, Inc. Terms of Use | Privacy Statement