Where you been? Where you going?
I’ve gotten really bad about regular posting. I have a few excuses. One, my job in my professional life has changed considerably. I’m now working across a much wider swath … Continue reading
A Group of Basic Availability Groups
Can a group of basic availability groups mimic an enterprise level availability group for far less cost? With SQL Server 2016 we have finally been able to have some form … Continue reading
Pass 2016 Summit Application and Feedback
For the past three years I have put myself out there and submitted for PASS. While a long time user of SQL Server, and a somewhat recent IT manager of … Continue reading
TSQL Tue #79: When the Memory is All Gone
I used to blog. Today I ashamedly realized it’s been nearly six months since my last post. That’s pretty pathetic. I was doing a couple a month there for a nearly 2 years … Continue reading
A Sane TSQL Repository
In the previous post we talked about using the template explorer within SSMS to keep a sane TSQL library. People have complained for some time that the template explorer within … Continue reading
A Sane TSQL Script Library
Earlier this year I got to speak at SQL PASS on performing under pressure. Leading up to that event I previewed my session at a couple SQL Saturdays and during … Continue reading
Your NoSQL Choice Needs More Relational Algebra
Whether you can admit it to yourself or not, data without relation or context is pointless. Let’s say I have a database with 14 TB of integers between 0 and 100, with … Continue reading
Including Cluster Key in Non Clustered Index Definition
I ran into a question I haven’t gotten in a while – does including a clustered key as part of a non-clustered index offer any benefit? It came up because … Continue reading
24HOP: Stress Inoculation (2015 PASS Summit Preview Session)
Today was my first dress rehearsal presenting my PASS 2015 presentation to a living audience. I was fortunate enough to get an invite to 24 hours of PASS. My session … Continue reading
Experience; There is no Substitute
A few weeks ago I wrote a blog post entitled experience is over-rated. Today you’ll get a little peak inside my mind while I counter that original argument myself. Experience, … Continue reading