First Look: SQL Server Denali

First Look: SQL Server Code-named Denali $(document).ready(function () { $(".rmRootLink:contains('subscribe')").attr('href', '/Subscribe/tabid/444/List/1/CategoryID/99/Level/a/Default.aspx?code=WP211XHB '); }); Windows IT Pro For Admins SuperSite For Tech Enthusiasts SQL Server Mag For DBAs DevProConnections For Developers SharePointPro Connections For IT & Dev SQL Server Magazine

The Smart Guide to Building World-Class Applications

About Advertise Subscribe Follow Us RSS Why Join My Account Register Sign in Search InstantDoc IDGO Browse By: Author | Issue

Homenewsblogsbusiness intelligencedatabase administrationdatabase developmentPuzzled by T-SQLSQL SelectSQL Server BISQL Server Questions AnsweredTool TimeT-SQL and PowerShell Scriptingproducts & reviewsawards centralbuyer's guidereviewsnewslettersEventsRegister for DevConnections Conferences & WorkshopseLearning SeminarsRoadshowsVirtual EventsWeb Seminarscommunityfollow usForumsuser group centralresourcesebooksessential guidespodcaststip guidestrials & downloadsvideos & moreweb seminarswhite papersmoreHP MicrosoftConverged ApplicationsConverged Applications BlogMicrosoft UKsubscribe var dartrnum=Math.floor(Math.random() * 100000);document.write(' document.write(' Home » SQL Server » First Look: SQL Server Denali

Browse By Category Business IntelligenceDatabase AdministrationKevin Kline: Thoughts from a SQL Server Old TimerDatabase DevelopmentT-SQL & PowerShell Scripting Doublelick Ads document.write(' March 14, 2011 03:29 PMFirst Look: SQL Server Denali Enhancements raise the bar for enterprise data platforms bookmarkreprintsEmailPrintCommentsRating: (4)Michael OteySQL Server MagazineInstantDoc ID #129291

Ready or not, here it comes! The next release of SQL Server, code-named Denali, is right around the corner. For most companies, Microsoft is churning out new releases way faster than they can roll them out internally. However, each release of SQL Server definitely brings a fuller feature set to the table than ever before. The new enterprise-oriented feature set in SQL Server Denali definitely testifies as to this database software’s maturity. Let’s take a look at some of the enhancements that are expected in the SQL Server Denali release.

 

Support for Windows Server Core

Windows Server Core is designed for infrastructure applications that provide back-end services but don’t really need a graphical UI on the same server. Although SQL Server is such an application, you can’t run previous versions of SQL Server on Windows Server Core. SQL Server Denali’s new support for Windows Server Core will enable leaner and more efficient SQL Server installations. Running SQL Server on Windows Server Core will also reduce the potential attack surface and the need for patching.

It’s important to realize that running SQL Server Denali on Windows Server Core means that you must manage the instance locally using a command-line interface (e.g., Windows PowerShell, the sqlcmd utility) or manage the instance remotely. Most SQL Server instances are managed remotely—and managing this instance remotely shouldn’t be much different than managing most of your other instances remotely.

 

Revamped SSMS

One of the first things you’ll notice about SQL Server Denali is that SQL Server Management Studio (SSMS) has been updated to use the new Windows Presentation Foundation (WPF)–based shell that Microsoft Visual Studio 2010 is built on. SSMS is still the DBA’s best friend. It lets you manage multiple SQL Server systems and create T-SQL scripts and database objects. It also provides several built-in management reports, such as the Server Dashboard report in Figure 1.

Figure 1: Server Dashboard report in Denali

New Development Environment

Another enhancement that’s slated for the Denali release is the new development environment that’s code-named Juneau. Like SSMS, Juneau uses the new WPF-based shell.

Juneau promises to provide a development experience that will be immediately familiar to DBAs who know and love SSMS. However, it goes beyond what SSMS offers. For example, Juneau sports a new graphical table designer with split graphical and T-SQL views that let you make table schema changes in either view and see immediate updates to both views. Juneau is aware of dependencies and can generate a list of errors if you try to drop columns that other database objects use.

Juneau can also analyze a set of changes and generate a script that will update the database and all the objects affected by changes that you make in the development environment. Like Visual Studio, Juneau supports the concept of projects and can be integrated with source control using Team Foundation Server. One of the cooler features is Juneau’s ability to immediately jump to column definitions or show all the references for a given column. One of Juneau’s goals is to make the development environment consistent for both SQL Azure and the on-premises version of SQL Server.

Juneau isn’t included in Community Technology Preview (CTP) 1, but it was demonstrated at PASS Summit 2010. You can view that demonstration here.

 

SQL Server AlwaysOn

Probably the most significant new feature in the upcoming Denali release is the SQL Server AlwaysOn feature. AlwaysOn is essentially the next evolution of database mirroring. AlwaysOn doesn’t replace database mirroring or failover clustering. Instead, it adds a new high-availability option to SQL Server.

Database mirroring is a very important high-availability technology, but it has a few significant limitations. First, it’s limited to a single database. Second, it’s limited to a single mirrored partner, and the mirrored data contained in the secondary site can’t be used while mirroring is active. AlwaysOn, which is also called High Availability and Disaster Recovery (HADR), eliminates these problems and provides some other important benefits as well:

AlwaysOn supports multiple-database failover.AlwaysOn supports up to four active secondary sites, and the data in the mirrored sites can be queried and used for backups.

FirstPrevious12NextLast Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here document.write('Related ResourcesSQL Server Administration for Oracle DBAs
EBook by MicrosoftSpecial Report: Perspectives on SQL Server Sprawl
Essential Guide by PolyServeA Jump Start to SQL Server BI
EBook by MicrosoftMoving SQL Server to the x64 Platform
EBook by AMDMore Copy Paste fails with large result sets.

In SQL 2008 Management Studio. The copy fails on with large result set. I can select and copy small portions and paste in excel, notepad, word ect.......222-96701

More Posts Monitoring encryption keys created by TDE using SQL Audit Query Correlation to Resource Usage - % of X Upgrading from 2008 to 2008 R2 with SSIS document.write(' document.write(' GOOGLE LINKS SPONSORED LINKSdocument.write(' FEATURED LINKSdocument.write(' Downloads

Do you have to create custom code just to determine who has what permissions? Try Security Explorer, an enterprise security management solution for SQL, SharePoint, and more. As SQL expert Robert Davis reports, “DBAs who deal with compliance regulations will find this tool indispensible.”

Tip Guides

Migrating to Windows 7 comes with one major drawback: Win7 “application obsolescence.” This tip guide explains how VMware ThinApp can encapsulate applications in self-contained executables and how you can avoid the ten most common Win7 application migration pitfalls.

Web Seminars

Despite the promise of cloud computing, IT administrators may be hesitant to entrust the performance of their business-critical processes to a 3rd party. View this webinar to learn how you can reap the benefits of cloud computing while maintaining absolute control over your data.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

SQL Server Magazine

DevProConnections ITTV Left-Brain SharePointPro Connections SQL Server Magazine SuperSite for Windows Windows IT Pro © 2011 Penton Media, Inc.

Home About Us Advertise Customer Service Privacy Statement Subscribe/Renew Terms Of Use

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.

function AttachAds() { var midpos = $("#wrapper").offset(); var midwidth = $("#wrapper").width(); var leftwidth = $("#leftad").width(); $("#leftad").css({ "left": (midpos.left - leftwidth) + "px", "top": midpos.top + "px" }); $("#rightad").css({ "left": (midpos.left + midwidth) + "px", "top": midpos.top + "px" }); } $(window).resize(AttachAds); AttachAds(); Sponsored Introduction Continue on (or wait seconds) ×

document.write('

View the original article here