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
Sharing Registered Server Entries in SQL Server Management Studio
We’re dedicating at least one article per month here at SQL Server Pro on features, usability, and navigation inside SQL Server Management Studio (SSMS). This month I wanted to build on my introduction to the Registered Servers window by showing you how you can share the listing and categorization of SQL Server instances throughout your environment with others on your team.
Last Day to Submit Abstracts for 2016 IT/Dev Connections
Are you interested in contributing to the success of your peers and share insights into how you do things in your day-to-day efforts as a SQL Server Data Professional? Then consider submitting to IT/Dev Connections 2016 as a speaker.
Hidden Gems in SQL Server Management Studio: Registered Servers

As a SQL Server Database Administrator you tend to spend more time in SQL Server Management Studio (SSMS) than you do with your family. It’s surprising just how many peers I speak to though that are not using components of SSMS that I think of as routine – or are not using them to their full potential.

PASS Business Analytics Conference Day 2 Keynote: A Framework for Ethical Data Use
The final day of the 2016 PASS Business Analytics Conference in San Jose, CA started with a keynote on the ethical collection and use of data by Susan Etlinger. Tim Ford shares the key takeaways.
At PASS Business Analytics Conference, a look at history to see the future of data analytics
The 2016 PASS Business Analytics Conference kicked off at the San Jose, CA Fairmont on May 2 with a day of pre-conference sessions ahead of this morning’s keynote address and general sessions, and Tim Ford reports on what happened.
Security Options for Developers in Dev/Sandbox Environments
As a DBA is it possible to limit access to only the objects a user needs rights to without being a constant blocker for new development from your developers and engineering teams? It definitely is but there are options with their own benefits and risks.
Introduction to the Index Operational Statistics Dynamic Management Function
How do query operations translate to metadata inside two popular SQL Dynamic Management Objects?
Preview of the PASS 2016 Business Analytics Conference
The PASS 2016 Business Analytics Conference is coming to San Jose May 2 - 4, 2016 and SQL Server Pro will be onsite to cover the event.
A Sneak Preview of SQL Server 2016 and Cortana Intelligence

It seems fitting that the SQL Saturday Silicon Valley on the Microsoft campus in Mountain View, CA., on April 9 took place on the anniversary of the signing of the ENIAC (Electrical Numerical Integrator and Computer) contract in 1943 in the facility where that foundational device resides in present day.  Though it’s a far cry from today’s calculating power, ENIAC was cutting edge for the time - capable of 5,000 additions per second.

Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 2)

A Review of Part 1

In part one of this article I laid out the base query for which to return valuable information out of the sys.dm_db_index_usage_stats Dynamic Management View.  In part two here I’ll now so how we can use the base query for addressing specific questions about index usage (or lack of) and what you may be able to discern from minor adjustments to that base query.

For those of you who want to jump right in without all the initial theory here is that base t-sql statement from Part 1

Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 1) 4

Valuable insights are available about your indexing strategy through the Dynamic Management Views: one in particular.

Comprehensive Wait Stats Query for SQL 2005 - 2016 2
Looking for a Microsoft SQL Server wait statistics query that works across all versions of SQL since 2005. This is the one.
New Dynamic Management Views in SQL Server 2016 Part 2: dm_exec_session_waits
SQL Server 2016 is rapidly approaching release and in this continuing series Tim Ford exposes some of the new Dynamic Management Objects available in the latest version of Microsoft's flagship database platform.
Identifying High-Impact Queries and Stored Procedures with Dynamic Management Views 2
Are you looking for a comprehensive set of scripts to identify queries or stored procedures with highest reads or writes, most CPU consumption, or are the longest running on your SQL Server instances? Then go no further than here where Tim Ford, who truly "wrote the book" on Dynamic Management Views provides two new toolbelt queries for doing just that.
Comments
Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 1)
February 8, 2016

Good point. I'll edit the script to note that and also provide an alternate for older versions back to 2005. Thanks.

Identifying Query Text and Graphical Execution Plans in Active Queries
December 10, 2015

Anggara, this works fine when I copy and paste it into SSMS. There is nothing to fix syntactically. Can you tell me what version of SQL you're running and the collation...

Identifying High-Impact Queries and Stored Procedures with Dynamic Management Views
October 2, 2015

I suspect you may not have swapped-out the template parameter in the WHERE clause.

If you want to return results for the entire instance then comment out the WHERE...

The Myth About Estimated Execution Plans
September 3, 2015

Jason, I must apologize, but I inadvertantly deleted as spam your response when I meant to delete one purporting the commenter's new relational database written by himself...

CTP 2 of SQL Server 2016 Now Available
May 27, 2015

Ah, it appears there are benefits to being an MVP. MVPs get in today; public tomorrow!

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
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....More
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....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) ×