Monthly Archives: September 2011

SQL Server Features for Developers: What you should be using and why

Date: September 23, 2011 Location: Jones Day Abstract: You know about CLR and T-SQL functions like PIVOT and DENSE_RANK().  But what about those features built into the SQL Server engine itself? We’ll discuss database snapshots, data compression and Service Broker, examining how each works and, most importantly, the where and why you should use them. […]

SQL Server A to Z – NUMA

Back to our ABCs for a bit. Today we’re talking about Non-Uniform Memory Access, aka NUMA. What is NUMA? Once upon a time, servers only had a few, relatively slow processors. And these processors all used the same shared memory bus to access system memory. But because there were so few processors and because they […]