Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

Entity Framework Hidden Cursors

As a database administrator I’m most concerned about what’s happening in production – not how many lines of code were saved in development.  For this reason I started researching EF on … Continue reading

Featured · 1 Comment

TSQL Tue 63: Extensible Key Management

It’s TSQL Tuesday!  Edition 63 is being hosted by Kenneth Fisher (@sqlstudent144).  The topic this month is security, and what a globally relevant topic it is. Target, Home Depot, Blue … Continue reading

February 10, 2015 · 2 Comments

What Every DBA and SWE Should Know About EF

An ORM (object relational mapper) can make the task of developing code against the data tier much easier for the Software Engineer.  One of the more popular ORMs is Entity Framework.  … Continue reading

December 29, 2014 · 5 Comments

You say po-tay-toh; I say physical reads

Consider the following hypothetical conversation between two DBAs. Alpha: Hey, take a look at the query running in prod.  It’s generating a ton of reads. Omega: 40 thousand reads?  That doesn’t seem so high. … Continue reading

November 21, 2014 · Leave a comment

TSql Tue 60: Hey Ma, looky here what I learnt!!

Pass Summit has come and gone.  I am definitely suffering from the post-PASS blues.  My head is all full of interesting stuff but also… I’m exhausted.  Hats off to those who are able … Continue reading

November 11, 2014 · 1 Comment

TSQL Tue #59: My Heroes

I’m looking forward to reading the TSQL2SDAY posts this month.  Hero worship is something I have a bit of a problem with.  The problem being, there are way too many … Continue reading

October 14, 2014 · Leave a comment

Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins

The logical joins (inner, outer, left, right etc) are familiar to any SQL pro.  As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading

October 13, 2014 · Leave a comment
Follow

Get every new post delivered to your Inbox.