Tim Ford

SQL Cruise

Tim Ford is an independent consultant, data professional, author, and community leader whose technical passions lie in creative solutions for managing and presenting data. He has been a healthcare DBA since 2000, and is an advocate for proper design, performance, and security in that sphere of information technology. Currently on the Professional Association for SQL Server (PASS) Board of Directors, Tim has oversight of the SQLSaturday program. As an author for MSSQLTips, Simple-Talk, SQLServerCentral, and his own site, thesqlagentman.com, Tim regularly provides content on database-related topics, professional development sciences as well as general technology commentary.  

Tim regularly speaks at SQLSaturday events worldwide, but his true passion lies in taking small groups of students and leaders in the SQL Community aboard cruise ships for technical and professional development training without the distractions of the office and Internet twice a year on SQL Cruises (www.sqlcruise.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+.

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.
Important dates
Cheat Sheet for Calculating Important Dates 1
Looking for a single source for date calculations for starting and ending periods for days, months, and years? We have you covered!
Man and woman juggling at sunset by the ocean
Identifying Orphaned Logins 1
Identify and resolve orphaned logins on a SQL Server instance with this simple query process from Tim Ford.
Shortcut to Consistent SQL Server Installs Using Configuration Files 1
If you support a large environment for SQL Server, then consistency between SQL instances and simplicity of installations are both key to making your life easier; this advanced install tip leads to both.
Identifying Role Permissions & Who Can Get You Fired
People who can get DBAs fired are the ones that have permissions to do things such as dropping databases, overwriting backup files, creating databases with 2TB log files on a 500GB log volume—they have server-level role membership.
Identifying SQL Server Failover Cluster Shared Drives, Nodes, and Current Ownership
When it comes to being a database administrator, it's not just about keeping things running—it's also about constant analysis of the SQL environment as a whole.
Red SQL Server
Protect Yourself in SQL Server Management Studio with Color Coding Instances
The possibility of executing code against the wrong instance is something that exists in SQL Server—particularly for DBAs or developers who may have elevated permissions in multiple environments (PROD, TEST, DEV, and so forth.) It's possible to add color cues to these different environments for an additional level of protection.
Modifying the Default SQL Script in Management Studio
One simple solution you can employ to avoid running a query against the wrong instance, is altering the code that populates each and every New Query window that is populated in SSMS, the default query.
SQL Server query results
Identifying Query Text and Graphical Execution Plans in Active Queries
The information about what is currently running on a SQL Server is fairly easy to collect from a singled Dynamic Management Function (DMF).
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
Two women looking a man's computer monitor
Sep 17, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×