Multi-subnet Failover Clusters

Multi-subnet Failover Clusters I want to take a closer look at one of the new features in SQL Server Denali. While everyone has been drooling over HADRON, another HA feature has gone mostly unnoticed. I haven’t heard anyone talking about it yet, so this should be an introduction to this new feature, Multi-subnet Failover Clusters. Geographically Dispersed Failover Clusters Multi-subnet failover clusters is an enhancement to an existing technology, geographically dispersed failover clusters. SQL Server 2008 and Windows Server 2008
read more

Custom Server Roles in SQL Server Denali

Custom Server Roles in SQL Server Denali One of the new features in Denali is the ability to create custom server roles. This can be done using the CREATE SERVER ROLE and ALTER SERVER ROLE commands. You can also do it using the GUI. I’m by no means an advocate of doing things with the GUI (quite the contrary), but it is a great way to explore a new feature and see how it can be done via T-SQL. So
read more

You Got Your Integration Services in My Database Engine

You Got Your Integration Services in My Database Engine When I first looked at Object Explorer in SSMS (SQL Server Management Studio) after installing SQL Server Denali CTP1, something looked out of place. I compared Object Explorer in Denali’s SSMS to the same in SQL Server 2008 R2, and it was immediately noticeable. There is a new node called Integration Services between the Management node and the SQL Server Agent node. Click on the images to enlarge them and get
read more