First Presentation Ever And My 50th Post

Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...

Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution

You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...

Home Workspace: Standing Desk

Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...

Interest In SQL Server Seems To Be Declining?

Amusing myself for a minute at Google Trends. Anyone missing 2005?
 

Make Your Storage Administrator Your Best Friend

That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin.  For the...

Presenting at the kickoff Lynchburg Va SQL User Group meeting

There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...

The CHOOSE keyword

G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...

The RedMonk Programming Language Rankings: January 2014 #programming

The RedMonk Programming Language Rankings: January 2014
As long as we have been doing our programming language rankings here at RedMonk,...

Transact-SQL query to obtain basic information about partitioned tables

Here is the simple query that returns basic information about all tables in a database that are partitioned:

SELECT SCHEMA_NAME([schema_id]) AS...

What Is a Throwout Bearing?

A throwout bearing is a part of an automotive clutch system that temporarily disengages the engine from the manual transmission while shifting....