Russ Thomas – SQL Judo

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

TSQL Tue 64 Roundup

Last week was my first time hosting TSQL Tue.  The topic was “focused tuning”.  I had some stiff competition that week with SQLBits and the final week to get PASS submissions … Continue reading

Featured · Leave a comment

TSQL Tue 64: Tuning SSIS with In-Memory Stage

I’m excited to be hosting TSQL Tuesday this month.  The topic is focused performance tuning.  Please be sure to check out the other posts submitted for this month’s blog party … Continue reading

March 10, 2015 · Leave a comment

TSQL Tue 64: Calling All Tuners and Gear Heads

It is month 64 of Adam Machanic’s monthly blog party known as TSQL Tuesday.  I’m very honored to be hosting this month.  Let’s get to it.  This is your official invite to the SQL Server Performance Grand … Continue reading

March 2, 2015 · 9 Comments

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

February 24, 2015 · 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
Follow

Get every new post delivered to your Inbox.