Tim Ford

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

Looking for SQL Server 2014 SP 1... Hold Off a Bit Longer
Microsoft released service pack 1 for SQL Server 2014 on April 15, 2015. Why can't we download it though?
Who Will Be Attending HostingCon 2015?
Who will be attending HostingCon 2015?
2015 IT/Dev Connections Data Platform and Business Intelligence Track Sessions Announced
The 2015 IT/Dev Connections Data Platform and Business Intelligence sessions have been announced. We're taking a first peek at who will be providing knowledge and guidance at this year's event at the Aria Resort in Las Vegas.
Early Bird Discount and Full-Day Workshops for 2015 IT/Dev Connections
The IT/Dev Connections super early-bird discount ends on Tuesday, March 31st and it is the lowest price of the year.
Software Vendor Takes on SQL Injection 1
A Dublin company creates a solution claiming will prevent SQL injection attacks in web-based applications running Java.
Getting Started for Free with Amazon Web Services for SQL Server
Getting started with SQL Server in the Amazon Cloud is easy. It's also free for the first 12 months.
Three Methods for Identifying When the SQL Services Were Last Started
Do you need to know the last time the SQL Services were restarted? Find out about three options on how to do just that.
Building the Best Data Content Tracks for IT/Dev Connections
The call for speakers has closed and the time has begun to start crafting the best data tracks possible from the sessions that have been submitted. Here is a look into what we'll be bringing you this year at IT/Dev Connections.
IT/Dev Connections Call for Speakers in its Waning Hours

2015 Call For Speakers at IT/Dev Connections is Winding Down

Though technically the Call for Speaker's for this year's IT/Dev Connections Conference at the Aria Hotel in Las Vegas closed yesterday I've persuaded the Powers That Be to leave the window on submissions open through tomorrow.  I do know how my fellow SQL Server Professionals love to take their time to mull over their abstract opportunities and get their sessions just right before submitting.

SQL Server Management Studio Requires Modernization 6
SQL Server Management Studio is over 10 years old and little has been done to accommodate growth and feature enhancements in the SQL Server platform. The time has come for Microsoft to invest in it's future as the core client tool for it's flagship data platform.
Efficient SQL Server Administration: Mise En Place for IT
Mise En Place is a culinary term which refers to organizing and arranging ingredients required for a shift in a professional restaurant for preparing all menu items for a given shift. While a culinary term its practice can be applied to anything: even database administration and development.
5 Reasons Against Allowing db_owner Role Permissions 1
As someone who has had to implement independent software vendor-developed (aka "purchased") solutions with a foundation in SQL Server for over 15 years I cringe whenever I see that the vendor requires db_owner role permissions for the end users.
4 Methods of Identifying Connections Count in SQL Server
Recently I received a question about finding out how many connections were associated with a SQL Server instance. The answers really depend upon which version of SQL Server we're talking about.
17 Questions Every SQL DBA Should Ask Before Supporting a New Third-Party Database 3
17 questions every production DBA should ask to ensure that the architecture that surrounds the new database is appropriate, complete and as minimal as necessary to accomplish the correct level of support and service.
Identifying Indexes on a Table
During performance tuning it's frequently necessary to determine if there are better indexing options to satisfy the query you're tuning but at the same time ensuring you're not going to make matters worse overall. That usually means you need to know what indexes already exist on a table. Here is a quick script you can use immediately to give you that information.
Table Variable Tip
April 2, 2015

We're seeing this as a browser-agnostic issue and are working to fix it inside of the CMS. Thanks for letting us know!

17 Questions Every SQL DBA Should Ask Before Supporting a New Third-Party Database
January 18, 2015

Sure! db_owner allows you to grow or add a data or log file inside your database. That being the case imagine someone doing so at a size that fills up the associated disk...

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

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
Mar 17, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015

For Data Quality, Intelligent Rules Add Value to the Golden Record 6

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....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) ×