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+.

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).
Police care with emergency lights
Policing the Use of SQL Server Management Studio
SQL Server Management Studio suffers from a lack of dedicated developer talent assigned to update it, but it's the best tool we currently have for the full range of administrative duties database administrators face.
Mountain trail through Rocky Mountain National Park
Using the all_columns System View in SQL Server
A quick and easy way to query the database schema for a particular column name is through the use of a seldom-recognized system view called all_columns.
sql server database administrator stretching outside on a pedestrian bridge
When Will Key SQL Server Processes End? 2
There is a simple script that makes use of SQL Server's Dynamic Management Objects so you can get an idea how long certain key processes are going to take.
deep outer space
Deeper into the SQL Server Management Studio Template Explorer
Here's a look at two options for working with existing templates in the SQL Server Management Studio Template Explorer.
Opening the Template Explorer in SSMS
Introduction to Using the Template Explorer in SQL Server Management Studio
We all have our little code libraries saved somewhere for quick access. What if you were to find out you can have that library inside SQL Server Management Studio (SSMS)?
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...

Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Health check note on computer keyboard
Jul 28, 2014

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....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) ×