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
Microsoft Announces Enterprise Edition Features Across all Editions of SQL Server 2016
Major announcements from Scott Guthrie of Microsoft at the 2016 Connect Conference concerning enterprise edition features availability and SQL Server on Linux.
Don't Panic: Busting a File Space Myth
Just because a data file is almost out of space doesn't mean it's going to endure an auto-grow event.
PASS Summit 2016 Women in Technology Luncheon
Kelly Lockwood Primus, SVP, Strategic Client Solutions at Leading Women, was the keynote speaker at the annual PASS Women in Technology Luncheon that took place at the recent PASS Summit. Her talk was titled Leadership, The Missing 33%TM and Career Success for Women and presented research identifying nine critical differentiators for moving from middle management into senior and executive positions.
One Month Free Trial for Azure Data Warehouse
Looking to test out Microsoft Azure Data Warehouse? How about doing so for free for one month?
Microsoft Announces Azure Analysis Services Preview at PASS Summit 2016
The PASS Summit - the largest conference for Microsoft Data Professionals - kicked off the 2016 event in Seattle today with a number of exciting announcements; including news about Analysis Services availability on the Azure cloud platform.
Sending Results of DBCC CHECKDB SQL Agent Job Via Email
Sending the results of DBCC CHECKDB is not too difficult but there is a couple of things that, if you've not dealt with before, will serve as issues with successfully architecting a solution.
How to Set Up SQL Server Database Mail in One Easy Script
Database Mail in Microsoft SQL Server allows for messaging to occur between SQL Server and anyone with a valid email address. It can be daunting to set up through SQL Server Management Studio but by using the SQL Server Template in this article you'll find you can do so in just a few minutes.
What Every Accidental DBA Needs to Know Now: Basics of SQL Security
Congratulations you're now a DBA! What do you need to know about security for SQL Server? Read on and find out.
What Every Accidental DBA Needs to Know Now: SQL Server Configuration Manger 1
The SQL Server Configuration Manager is an critical but often overlooked application for proper SQL Server instance management and, well, "configuration". In Tim Ford's continuing series aimed at the Accidental Database Administrator he takes time to explain the basics of this tool, its use, and its features.
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.
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) ×