• SQL Server
  • Log Shipping Tricks Demo
  • SQLCruise Alaska 2012 Pics
SQLSoldier News From the Frontlines

Tag Archives: Denali

SQL Server Denali (SQL 11)

Multi-subnet Failover Clusters

January 1, 2011 4:46 pm / 3 Comments / SQLSoldier

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. … Read More →

Posted in: SQL Server / Tagged: Clustering, Denali, Disaster Recovery, High Availability

Custom Server Roles in SQL Server Denali

November 15, 2010 5:28 pm / 4 Comments / SQLSoldier

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 … Read More →

Posted in: SQL Server / Tagged: Denali, T-SQL, Tips & Tricks

You Got Your Integration Services in My Database Engine

November 13, 2010 10:40 pm / Leave a Comment / SQLSoldier

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 … Read More →

Posted in: SQL Server / Tagged: Denali, SSIS, SSMS
<

Remote DBA Services
- serious SQL Server expertise for less than a full-time DBA
My Articles
 
My Book
Check out my interview on

Extreme Data Recovery (with Argenis Fernandez)
10 Things all BI System Administrators Should Know
Upcoming Events
    All events shown in Pacific Time

    No events to show

RSS My SQL Server Magazine Articles

  • Database Mirroring for Disaster Recovery September 16, 2011
  • Comparative Review: Database Schema Comparison Tools August 24, 2011
  • 3 Log Shipping Techniques June 22, 2011
  • Hardening SQL Server June 20, 2011
  • Review: ScriptLogic Security Explorer for SQL Server February 8, 2011

Tags

31 Days of Disaster Recovery Architecture Automation CDC & Change Tracking Data Architecture VC Database Mirroring DBCC Denali Disaster Recovery Dynamic Management Views Extended Events Gamers & Geeks General Discussion High Availability How do I ... ? Humor Idera ACE Program Internals MCM Meme Monday Performance & Optimization PowerShell Professional Development Replication Security SQLBits SQL PASS SQL PASS Summit SQLRally SQL Saturday SQL Server Magazine SQL University SSAS & BI SSIS SSMS SSRS T-SQL T-SQL Tuesday tempDB Tips & Tricks Travel Troubleshooting Undocumented Stuff Whitepapers XML in SQL

News

Download my Powershell Scripts

The following scripts can be downloaded as text files. You will need to change the file extension to .ps1 in order to execute them.

Backup a database
Restore a database
Scan a server to find a free port
Query DNS to get the FQDN of a server


To see some examples of my other forms of writing, please visit my page on WritersCafe.org. It is almost exclusively horror fiction, but I sometimes throw other things in there too from time to time. There's one science fiction story, a couple of poems, and quite a few humor pieces as well.


Look for me in the SQL Q&A section of the August, 2007 issue of TechNet Magazine.
August issue of TechNet Magazine's SQL Q&A column

Protect our Heroes

© Copyright 2012 - Robert L Davis
Infinity Theme by DesignCoral / WordPress

Twitter Twitter 
LinkedIn LinkedIn 
TLF TLF RSS RSS 
WritersCafe WritersCafe 
SQLPASS SQLPASS 
Facebook Facebook
grab this