SQL Intersection!

The best emotion to describe how I'm feeling is 'astounded'.  I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference.  Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection. Check out this list of speakers: Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [blog | twitter] Andrew J. Kelly, Mentor, SolidQ [blog | twitter] Bob Ward, Principal Architect Escalation Engineer, Microsoft [blog | twitter] Brent Ozar, Brent Ozar Unlimited [blog | twitter] Conor Cunningham, Principal … [Read more...]

High-Availability White Papers and Resources for SQL Server

I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress and Conquer written under the nom de plum of Connie Mason. There's lots more good stuff from Paul, just not romantic. This is a 'so-last-version' whitepaper describing  five common high-availability and disaster-recovery architectures deployed by customers, along with a case study of each. Although the white paper is specific to SQL Server 2008 R2 and isn't updated for AlwaysOn features, it's still … [Read more...]

Review the New Migration Guide to SQL Server 2012 Always On

I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall. Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide to SQL Server AlwaysOn. Read it and then pass along any feedback: HERE Enjoy, -Kev -Follow me on Twitter! … [Read more...]

Microsoft SQL Server High-Availability Videos and Q&A Log

You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt.  Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the Quest Software Pain of the Week webcast site. Archives of other videos are here. We're … [Read more...]

DBTA: What’s the Fuss about Data Deduplication?

Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means  to eliminate redundant data, either through hardware or software technologies.  To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input.  That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server.  Through data deduplication … [Read more...]