Author: jdanton1

For the past several months, along with my outstanding volunteer staff, I have been in the planning phases for SQL Saturday Philadelphia. Thanks to the wonderful folks at Microsoft we have an outstanding location, our sponsors have been wonderful, and we have an awesome group of speakers assembled. You can find the schedule here. Also, […]

My speaking schedule is pretty packed for the next few weeks. Here goes: 5/17 The Impact of FDA Regulations on Maintaining Your Database Environment — SQL PASS Healthcare Virtual Chapter. This talk will harken back to my days in the Pharmaceutical and Medical Device industries. I will discuss the rules and some tips and tricks […]

I’m here in balmy Madison, Wisconsin presenting today at SQL Saturday #118 presenting on High Availability and DR options in SQL Server 2012. Jes Borland (b|t) and the outstanding crew have done a fantastic job with this event. Anyway, I wanted to slides and some resources. Slides are here. Books online for AlwaysOn Availability Groups […]

Late last week, I fired up a Windows Server 8 VM—I wanted to play with it a home a bit, before setting up a large scale environment here at work. The first thing I noticed was how much the GUI has changed—there isn’t a start button, and most tasks are driven by the Server Manager […]

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 […]

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 […]

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’ […]

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 […]

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 […]