Community

Speaking at SQLSaturday Pensacola

I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! If you don’t know what SQL Saturday is, it’s a whole day of free SQL Server training available to you at no cost! If you haven’t been to a SQL Saturday, what are you waiting for!

Friend of Redgate 2016

I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development. Last year was my first year in the program and the value that it provides to the community is immeasurable. I got to see first hand the dedication Redgate has to the SQL community and to making great software.

Speaking at SQLSaturday Chicago

I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! My presentation is “Performance Monitoring AlwaysOn Availability Groups” Here’s the abstract for the talk Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives?

Public Speaking – The First Time

Update for T-SQL Tuesday #84 Well, this year I was challenged with the goal of speaking publicly three times, well I blew that out of the water and have spoken 8 times (one of which was a major IT conference) this year with one more on deck for Friday at the Albuquerque SQL Server User Group. I never thought it would have gone this far, but it certainly is fun and exciting.

Thanks Paul!

What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this year Paul Randal ( b | t ), in the name of community, offered his services to mentor to a small group of people. Check it out here. Crazy as it may sound he went ahead and offered mentoring to everyone that submitted here and I was on that list. Here’s my blog post submission

Friend of Redgate 2015

Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development. In the short time I’ve been a part of this, I can already see the value of the program! Did I mention how excited I am :)

Book Review – SQL Server Internals: In-Memory OLTP

In-Memory OLTP – a potential game changing technology Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one of them. The design team set out with a goal of reaching an order of magnitude improvement over existing technologies and techniques. To do so they had to rethink key facets of the relational database system, latching, locking, logging and statement compilation.

Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes

Here are my unedited chapter notes: Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do so at the column level. Supports only sorting, comparison and grouping. Will remove the need for case sensitive code on tables and columns but not data. Collate database_default to handle tempdb collation of temp objects. Research more. Interpreted SQL via interop useful for ad hoc or migration of code.

Reflections as a consultant

Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus on career and professional development for a minute. In 2011 I was thrust into the world of consulting…accidentally. Accidentally you ask, how can that happen? Well, at the time I worked remotely for a large health care practice doing system design and software development on the Microsoft stack.

Building Debug Symbols – Troubleshooting symbol building

Recently,I have been working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the internals of SQL Server. I approached one of our clients about doing this on a non-production system and they thought it be great. They would get better insight on their workload, I would get access to a real workload. win..win, right? Even in their stage environment they have a pretty heavy workload so it would be a good candidate for generating call stack data.