Tim Ford

Tim
R.
Ford
Owner,
SQL Cruise

Tim Ford is Senior SQL Server Database Administrator at Survey Monkey, the owner of SQL Cruise, and a senior contributing editor to SQL Server Pro. He's a data professional, author, and community leader whose technical passions lie in creative solutions for managing and presenting data with more than 15 years of experience as a healthcare database administrator, architect, team leader and consultant. Ford 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, Ford has oversight of the SQLSaturday program bringing free SQL Server, business intelligence, business analytics, Powershell, Excel, and professional development training to global audiences. Ford 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 Ford on Google+.

Articles
How to Restart Failed Log Shipping Quickly
Log shipping is a great tool for maintaining a redundant copy of your database to protect against site failures in a disaster recovery situation but what happens when it stops unexpectedly and you've an unknown number of transaction log backups to apply to get it going again? Tim has a script for you to identify the next transaction log backup to restore and kick-start the process.
Using Index Operational Stats to Drill Into High Latch and Lock Waits
If analysis of your SQL Server's wait stats shows high levels of latch or lock waits how do you know which indexes are to blame so you can zero-in on troubleshooting and tuning?
SQL Server Management Studio August 2016 Release
The newest release of SQL Server 2016 Management Studio has been released. You may want to skip this release however.
What Every Accidental DBA Needs to Know Now: Backups 2
What are the most important things for an Accidental DBA to know in order to survive in their new career?
SQL Professionals On the Road – Episode 1: Tim Ford and Others - Iceland SQLSaturday
Last month I had the opportunity to be one of only 2 US speakers to present at Iceland's first SQLSaturday. This article is about that experience and the travel experience of veteran Microsoft Data Platform professionals on the road. Oh, and we tossed ourselves in a volcano...
SQL Server 2016 Cumulative Update #1 Released
Microsoft has released the first update for SQL Server 2016 which fixes 192 issues.
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.
Comments
What Every Accidental DBA Needs to Know Now: Backups
September 13, 2016

Thank you for such a kind comment. You don't know how we authors appreciate the feedback. Usually we feel we just send these articles out into the wild and never hear anything...

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

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
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
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

Sponsored Introduction Continue on to (or wait seconds) ×