I’m in the midst of a project using System Center Configuration Manager’s (SCCM) Desired Configuration Management (DCM) component. It has taken us some time to come up to speed on this, so our initial configuration checks were strictly against the Windows OS. Last week, we started working on the first SQL check—checking for service pack […]
Author: jdanton1
AlwaysOn versus Active Data Guard—A Value Proposition
With the launch of SQL 2012, much of my focus has been on the new Availability Groups functionality. I do lots of work in the HA and DR space, and the ability to utilize secondary copies of databases is an outstanding functionality enhancement to SQL Server. Additionally, now we can have multiple secondary replicas (up […]
24 Hours of PASS–My Session
Slides are here So I had the honor of being selected to speak at the upcoming 24 Hours of PASS (3/21, or 21/3 for my international readers), and I was thrilled, almost as thrilled as if I had been selected to drive in the 24 Hours of Le Mans. Ha–since the racing thing won’ […]
Matching EMC LUNs to Windows Disks
We are doing some SAN performance testing on the latest EMC VMAX array. As part of this, we are testing different storage configurations and policies and doing some baselining. I recently requested a set on LUNs for a new SQL install from my storage admin–I didn’t think about it, but I asked for disks that […]
Wheeling Presentation
Thanks to the Wheeling SQL Server usergroup for letting me present on SANs for DBAs.The slides can be found here. Denny Cherry’s article discussing SQL DR options along with SAN DR options can he found here. If you would like to vote for my session on New HA and DR Options in SQL Server 2012 […]
SQL Rally–Vote for My Session–and upcoming talks
I hate having to do this, but it’s part of the process. I am nominated for a community selection to the PASS SQL Rally event in Dallas this May. The session I would be giving is a great talk on the new High Availability and Disaster Recovery options in SQL Server 2012. I give an […]
SQL Rally Precon — Vote for Me
I had the honor of making it to the voting round of SQL Rally precon voting. So, I’m here to tell you more about my session and ask for your votes. My precon is SQL 2012 and Disaster Recovery–Getting Your Organization Ready. This session will really be in two parts, the morning will focus on […]
Using SQL to Build SQL
One of the DBAs on my team hadn’t seen this trick yesterday, so I thought it would be good to document it for persistence. I particularly like to use this technique when granting access to a specific object to user or role. This technique is also known as concatenating SQL. Here is how you do […]
New Orleans
As many of you know, I grew up in New Orleans (as did my darling wife). Both of our parents still live there, and as avid Saints fans, we are there all of the time. (I know all the flight attendants on US 1135). Anyway, I get a decent number of requests for what to […]
SQL 2012 HA/DR Presentation to Norther Virginia User’s Group
This is the presentation I gave last night to the Northern Virginia SQL Users Group on the new HA and DR features in SQL Server 2012. Thanks everyone for coming out–I had a great time presenting to your group.