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 […]
Author: jdanton1
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.
Philadelphia Presentation Always On
Here are the slides from my presentation at the Philadelphia SQL Server User’s group last night. Slides Also, if you have any comments, please leave them here. SpeakerRate http://www.slideshare.net/Jdanton/sql-server-2012-ha-dr
PSSUG Presentation 12/7 AlwaysOn
I’ll be presenting at the Philadelphia SQL Server User’s Group at Microsoft Malvern on Wednesday December 7. The topic will be a new feature in SQL Server 2012–Always On Availability Groups. I’ll give an overview of the existing DR and HA technologies currently available with SQL 2008, talk about what’s need in 2012 Clustering, and […]
Presentations from SQL Saturday #96 Washington
These are my presentations from SQL Saturday in Washington. I’ll post a follow up on a couple of the questions I had in the presentation later this week. http://www.slideshare.net/Jdanton/sql-saturday-powerpoint-dcsan http://www.slideshare.net/Jdanton/sql-saturday-dc-vm-ware
What my SQL Family Means to Me
So there are a ton of things I could talk about with this–helping each other remotely, being stuck, bored in a hotel room in another country and assisting with a restore for entertainment, or the fact that if I travel to almost anywhere I have someone to hang out with, but there’s more. The night […]
How to Find Data File Page Counts for a Table
Last week one of the guys on my DBA team, asked me if I knew of a way to identify which data from a table is in a particular data file. SQL Server (when it has multiple data files) typically does a proportional fill of data files—it will try to write an even amount of […]