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
Hotfix Released for July 2016 SQL Server Management Studio Download
The Microsoft Data Platform MVPs and SQL Server Product Group at Microsoft have worked hard to identify and resolve issues from the July 2016 release of SQL Server Management Studio. The hotfix with these changes has just been released.
SQL Server 2014 SP2 Now Available
Fast on the heels of the release of SQL Server 2016 comes the latest service pack for SQL Server 2014 packed with over 20 improvements and cummulative hotfixes including SP1 CU7.
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.
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
Jul 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
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
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) ×