Tim Ford

Tim
R.
Ford
Owner,
SQL Cruise

Tim Ford is an independent consultant and the owner of SQL Cruise. He's a data professional, author, and community leader whose technical passions lie in creative solutions for managing and presenting data with 15 years of experience as a healthcare database administrator, architect, and team leader. Tim is an advocate for proper design, performance, and security in that sphere of information technology where "good data" truly does save lives.

Currently on the Professional Association for SQL Server (PASS) Board of Directors, Tim has oversight of the SQLSaturday program bringing free SQL Server, business intelligence, business analytics, Powershell, Excel, and professional development training to global audiences. Tim regularly provides content on database-related topics, professional development sciences and general technology commentary for SQL Server Pro, MSSQLTips, Simple-Talk, SQLServerCentral, and his own site, thesqlagentman.com.  

He's authored a book on Dynamic Management Objects with Louis Davidson and provides commentary and content in his own voice (and in 140 character bursts) on Twitter as @sqlagentman. Also, follow Tim on Google+.

Articles
Free Tools for SQL Server Professionals
Looking for free SQL Server tools? Do you want recommendations from leaders in the SQL Community? Look no further than this summary from the panel discussion held this year at the Dev/IT Connections Conference in Las Vegas where that question was posed to the panelists.
Enhancing SQL Agent Notifications
SQL Agent has certain limitations but they can usually be overcome given a bit of simple ingenuity. Join Tim as he shows you how to get SQL Agent to speak to a wider audience when needed.
Important Soft Skills for the Entry-Level Data Professional 1
When hiring for an entry-level data professional role, you don't have the same technical benchmarks to measure prospective candidates against compared to when you're looking to fill higher-level technical roles.
Returning Column Metadata for a Specific Table 1
The SQL Server Community uses Twitter quite efficiently—and just yesterday, through the use of the #sqlhelp hashtag—one community member had their question answered, and I came up with this article as a result.
My Query is (Not) Waiting Because of Parallelism?
I recently received a frantic email from a team member stating their query was suspended because of parallelism. Let's talk about why that's probably not true.
Column Cardinality, Statistics, and Query Plans: Order Can Matter
When it comes to proper statistics, and therefore, proper use of indexes to satisfy queries against your SQL Server databases, order can matter and I'll show you why!
Identifying Details of Active Cursors
Recently, I was digging my way through a really nasty set of trace results from SQL Profiler when I ran across a series of commands that only provided insight into the fact that cursors were being employed.
SQL Server master files
One SQL Server Catalog View to Rule Them All
Have you ever wanted to query multiple databases on a SQL Server instance in order to return information about it's data and log files yet didn't want to deal with undocumented stored procedures to do so? If that's the case, get an introduction to sys.master_files.
red tips and tricks key on computer keyboard
Quick T-SQL Tip: Parsing Drive and File Information in SQL Server
Parsing full physical file names for information is one of those tasks a database administrator (DBA) finds they do on a semi-frequent basis; from looking up SQL Agent Job output paths or reviewing database file metadata.
GUIDs are Unruly, Mean-Spirited and Worst of All... Non-Sequential
Clustered Indexes Based Upon GUIDs 4
A look at GUIDs and Clustered Indexes and why this combination is bad and what can be done to make it better (to some extent).
Beware of Implicit Conversions
Even good code can be impacted negatively by a bad SQL Server database schema. Tim shows us why you should ensure your column data types are appropriate and consistent, and how a simple query can be impacted when that's not the case.
old green pickup by the side of the road
Fixing Outdated Page Verify Settings in SQL Server
Here's a very simple script to fix out-dated or incorrectly-set page verify values in your SQL Server 2005 and later databases.
Data illustration with business man looking up
Not All SQL Server Page Splits are Bad
Page splits! They're bad and cause massive amounts of performance issues, or do they? Let's look at diagnosing where page splits are high and when this is NOT a problem.
IT/Dev Connections logo
SQL Server Workshops at IT/DEV Connections 2014
IT/DEV Connections 2014 is less than one month away. We have five workshops devoted to a broad range of SQL Server topics this year by leaders in the SQL Server Community. Here is your guide to those sessions.
man peeking out behind a laptop
Behind the Scenes with SQL Server Included Columns and Covering Indexes
Learn what happens behind the scenes between a SQL Server query run against a table with a Covering Index and one with the same index structure, but without the Included Columns.
Comments
When Will Key SQL Server Processes End?
July 10, 2014

Doh! I don't often get lyrics wrong, but you're absolutely right. How about we cap off the article with the following instead: "we CAN check out anytime we like AND we're...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Availability Groups screenshot
Nov 11, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
Stretch SQL Server into Azure
Nov 5, 2014
blog

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×