Search results matching tags 'SQL Server 2012', 'High Availability', and 'Administration'

SQLintersection!

KKline — Wed, 27 Mar 2013 13:47:00 GMT

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 Architect, SQL Server, Microsoft [blog]
Grant Fritchey, Product Evangelist, Red Gate Software [blog | twitter]
Jeremiah Peschka, Brent Ozar Unlimited [blog | twitter]
Joseph Sack, Principal Consultant, SQLskills.com [blog | twitter]
Kendra Little, Managing Director, Brent Ozar Unlimited [blog | twitter]
Kevin Kline, Director of Engineering Services, SQL Sentry, Inc. [blog | twitter]
Kimberly L. Tripp, President/Founder, SQLskills.com [blog | twitter]
Mat Young, Senior Director of Products, Fusion-io [blog | twitter]
Paul S. Randal, CEO / Owner, SQLskills.com [blog | twitter]
Paul White, SQL Kiwi Limited [blog | twitter]
Steve Jones, Editor, SQLServerCentral.com [blog | twitter]
Sumeet Bansal, Principal Solutions Architect, Fusion-io [blog | twitter]

Read the list of SQL Server sessions here. On top of the list of outstanding sessions to attend, I'll be giving a keynote on Tuesday afternoon. Witness:

So the only thing between the attendees and the booze in the reception hall is our keynote address?!? Oh yeah, that's going to go down real smooth, isn't it? I'll last about as long as a puny henchman between James Bond and the villain of the movie. Sumeet Bansal, from Fusion-IO, will have to survive until the credits roll. We'll be talking about high performance computing on SQL Server 2012 with an eye towards high availability, AlwaysOn, and Availability Groups.

If you're in Las Vegas, I hope to see you there! If not, you should consider coming to this excellent conference.

-Kevin

-Follow me on Twitter!

Conquer Your Fear of Virtualization with a Free Day of Training at PASS!

KKline — Thu, 18 Oct 2012 16:50:00 GMT

Click this link to register: http://www.houseofbrick.com/education/sqlserverbootcamp/Registration.

Presented by my buddy, David Klee at House of Brick, one of the nations top VMWare consultancies specializing in Oracle and SQL Server deployments.

David has a great write-up of this boot camp at http://www.davidklee.net/2012/10/01/virtualizing-your-business-critical-sql-servers-free-boot-camp-by-house-of-brick/.

High-Availability White Papers and Resources for SQL Server

KKline — Thu, 26 Jul 2012 15:00:00 GMT

In foreground, attendee makes dreaded "shoot myself" hand sign to the speaker.

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 really, really good. It covers:

Failover Clustering for High Availability with Database Mirroring for Disaster Recovery
Database Mirroring for High Availability and Disaster Recovery
Geo-Clustering for High Availability and Disaster Recovery
Failover Clustering for High Availability Combined with SAN-Based Replication for Disaster Recovery
Peer-to-Peer Replication for High Availability and Disaster Recovery

You can get it from this link. Not everything is transferable to new AlwaysOn technologies, but then again AlwaysOn is an Enterprise Edition feature. So the database mirroring recommendation can be upsized, in many if not all cases, to SQL Server 2012, while the SAN and peer-to-peer recommendations continue to hold fast.

In addition, I encourage you to get up to speed on AlwaysOn. There are two great AlwaysOn FAQs that I recommend. The first is Microsoft’s official AlwaysOn FAQ at http://msdn.microsoft.com/en-us/sqlserver/gg508768.aspx. The second comes from my buddy and high-availability expert Allan Hirt (blog | twitter) at http://www.sqlha.com/2012/04/13/allans-alwayson-availability-groups-faq/.

To get started with AlwaysOn, check out http://msdn.microsoft.com/en-us/library/cc645581.aspx.

Enjoy,

-Kev