Monthly Archives: January 2012

SQL Server 2012 for the DBA

This past Wednesday night, the 18th Jan, I had the privilege to speak at the local SQL Server user group – JaxSSUG.

I was asked by Tom Brenneman to co-present on some of the new SQL Server 2012 hotness. I am currently working on SQL Server 2012 content that will be the basis of an upcoming 4-day class so I was able to put together a quick overview presentation. It was called Delta Force: SQL Server 2012 for the DBA.

JaxSSUG presentation

It was a great evening with approximately 60 people attending. I was definitely the supporting act while Adam Jorgensen (blog | twitter) headlined with his presentation on the BI Tabular Model and PowerView in SQL Server 2012.

Thanks to Scott Gleason, Tom Brenneman and JaxSSUG for putting on a great event.

You may download the slide deck for my presentation here.

SQL Server 2012 for the DBA (virtual class)

A new skill for a New Year
Pragmatic Works Training has a full and varied schedule of classes coming up. You can find the list here.
I will be teaching the SQL Server 2012 for the DBA virtual class on 19th – 22nd March. Registration is now open for this class.

Overview

SQL Server 2012 is the newest version of SQL Server available from Microsoft. This four day (half-day) course is designed to introduce SQL Server DBA’s to the new and exciting features available in that version. We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience. With the hands-on labs, you will experience how the new features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, ColumnStore indexes, SQL Server Data Tools, the FileTable feature, Azure and administering the BI platform within the context of SQL Server 2012.

Prerequisites

The target of this class is SQL Server DBA’s, developers, architects or IT professionals who have average to good T-SQL skills already. This class assumes that you have a good understanding of SQL Server fundamentals. For example, you should know and use the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class. It is not mandatory but some experience using the Business Intelligence Design Studio (BIDS) interface will be an advantage to you.

Day 1 – Administration and Performance:

Module 1: Deprecated and Discontinued Features
Module 2: ColumnStore Indexes
Module 3: DMV’s & Extended Events
Module 4: Security
Module 5: SQLOS
Module 6: Central Management and DRU

Day 2 – AlwaysOn and Disaster Recovery:

Module 7: Availability Groups
Module 8: Using Availability Groups
Module 9: Clustering Enhancements
Module 10: Disaster Recovery Enhancements

Day 3 – Programmability & Azure:

Module 11: SQL Server Data Tools (SSDT)
Module 12: Data-tier Applications (DAC Pac’s)
Module 13: T-SQL Enhancements
Module 14: FileTable and Full-text Semantic Search
Module 15: Introduction to Azure

Day 4 – Administering the BI platform:

Module 16: SSIS Administration
Module 17: SSAS Administration
Module 18: SharePoint Administration
Module 19: Azure Reporting

On sale: $495

Twitter – #Meme15

Logo for Meme15
It’s the middle of January already and most people are curled up under a blanket by the fire, trying to keep warm. I, however, live in Florida where it’s (relatively) warm and I’m putting together this #Meme15 post. #Meme15 is a blog series thought up by Jason Strate (blog | twitter) that gives us a place to discuss a common topic and how that topic affects us personally.

This month, we have been tasked with answering one, or both, of these two questions:

1. Why should average Jane or Joe professional consider using twitter?
2. What benefit have you seen in your career because of twitter?

Well, I joined Twitter back in 2009 and was basically using it to follow people that I thought were interesting (@SteveWoz, @LanceArmstrong, etc). You know – the way the rest of the world uses Twitter. I was looking to get more and more involved in the SQL community and Brent Ozar (blog | twitter) told me to look at connecting with SQL people on Twitter. I was sceptical at first because I wasn’t sure what SQL people tweeted about apart from how big their database was and how many times they had to shrink it per week. Boy, was I wrong. I quickly got connected with some very smart people who were friendly and helpful. I attended many SQL Saturdays and started meeting these people in real life and built up some great friendships within the community.

In 2011 I was fortunate to be able to go on the second SQL Cruise (blog | twitter) and had an absolute blast. If ever anyone feels like taking a great learning vacation, SQL Cruise is the way to go. I feel that the experience was enhanced due to the Twitter friends that I had made.

I returned from the cruise refreshed and a little bit smarter. Not long after that, I received a job offer from Pragmatic Works Consulting. I’d been discussing the opportunity with them for a few months by then and the time had come for me to take the next step in my career. I am currently involved in authoring the upcoming Professional SQL Server 2012 Administration book. I am also currently putting together a 4-day SQL Server 2012 training class and will be recording the class for SSWUG in the near future. I will also be presenting the material at SQL events around the country. The success that I enjoy is due, in part, to the help and support I have found from the SQL people I interact with on Twitter. Thank you to all those people from the bottom of my heart.

To some people, Twitter may just be a place where they can find out when and where celebrities are having lunch. To me, it is a network of like-minded individuals that interact with each other for the greater good of the community. Even if it’s mostly about bacon.