Archives: October 2016
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really got nothing to do with the Halloween problem. But it is Halloween today so it seemed like a good time to bring the subject up. Of course if… Read more
As I write this we are packing to leave for Disney World, where my family and I will spend close to a week hanging out with hundreds of thousands of the happiest people, not just from the US, but from all over the world. Then while I’m traveling home thousands… Read more
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we care? Starting with simple definitions first:
- occurring at the same time; coinciding in time; contemporaneous; simultaneous.
- going on at the same rate and exactly together; recurring together.
- Physics, Electricity.…
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says anything I want to point out that yes, I realize that you can use Powershell instead. Of course not all of us know Powershell all that well and most of… Read more
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece of code. But a much faster way to get a simple template is to use a snippet. With a simple key command (ctrl-K, ctrl-X) you can… Read more
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best for different queries. In a system with a lot of queries that means we could need a lot of indexes. Fortunately we can have up to 999 non-clustered indexes… Read more
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a blog party started by Adam Machanic (b/t) almost 7 years ago. Each month someone selects a topic and hosts the “party”. Then… Read more
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that wasn’t really what they needed, but we can get to that later. It did get me thinking and I figured it would make a good post.
This… Read more
I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when the MVPs are announced a number of us (wow I can’t believe I just said us) post the fact on twitter, usually under the hashtag #mvpbuzz. This was… Read more