Get Free Tips
MSSQLTips.com

Author: Tim Ford

Home » Archives for Tim Ford

Tim Ford is a Senior Database Administrator with MindBody in San Luis Obispo, California and is in the process of relocating west to the Pacific Northwest from Michigan. Since 2010 he’s produced Microsoft Data Platform training events branded as SQL Cruise from Alaska to the Caribbean and the Mediterranean at Tech Outbound, an events company specializing in technical training in unconventional locations. His SQL Cruise events take place on cruise ships in the Caribbean, Alaska, and the Mediterranean. Tim also is the Executive VP of Marketing for PASS, the global association for Microsoft data professionals. He also is a contributing author for itprotoday. Tim loves helping people find their true potential through education and building networks between Thought Leaders in various fields and those who are just starting on their careers or struggling to find their footing in established careers. If you’re looking for this sort of experience then check out the next SQL Cruise event taking place this August in Seattle.

  • MSSQLTips Awards: Acheiver (75+ tips) - 2010

TitleCategoryDate
SQL Server database backup and missing backup history scriptsBackup2025-02-05
sp_msforeachdb to Execute the Same Command on all SQL Server DatabasesScripts2024-12-30
Find Current Running SQL Statement in SQL ServerMonitoring2020-08-14
SQL Server Index and Statistics ReportFragmentation and Index Maintenance2020-08-13
SQL Server function to convert integer date to datetime formatDates2019-05-24
How to Find Keywords in SQL Server Stored Procedures and FunctionsDynamic Management Views and Functions2019-05-03
Verbose SQL Server Agent LoggingSQL Server Agent2018-08-31
Determine Free, Used and Total Space for SQL Server DatabasesDatabase Administration2018-06-02
Identify Completion Time for Long Running SQL Server Processes using Dynamic Management ObjectsMonitoring2014-03-03
Find SQL Server databases where log file is too largeDatabase Administration2011-04-25
Useful management information from SQL Server DMV sys.dm_os_sys_infoDynamic Management Views and Functions2011-01-31
Analyzing SQL Server Plan Cache Performance Using DMVsPerformance Tuning2010-12-31
Trending Buffer Pool Performance Using DMV sys.dm_os_performance_countersPerformance Tuning2010-12-29
Collect and store historical SQL Server performance counter data with DMVsDynamic Management Views and Functions2010-12-21
Using INSERT OUTPUT in a SQL Server TransactionTSQL2010-12-13
Creating a SQL Server proxy account to run xp_cmdshellSecurity2010-10-22
Run SSIS using xp_cmdshell in a SQL Server stored procedureIntegration Services Execute Package Options2010-10-18
Reassign Job Ownership for All Jobs on All SQL ServersSQL Server Agent2010-08-24
Run SQL Commands Against Multiple SQL Servers Without CMSCentral Management Servers2010-08-10
Collecting SQL Server performance counter data for trendingDynamic Management Views and Functions2010-07-27
SQL Server Performance Counter DMV sys.dm_os_performance_countersDynamic Management Views and Functions2010-06-17
Microsoft Access Pass Through Queries to SQL Server in DetailMicrosoft Access Integration2010-05-25
Transition from MS Access to SQL Server with the Migration AssistantUpgrades and Migrations2010-04-28
Identifying SQL Server logins with overlapping server rolesSecurity2010-04-23
Understanding SQL Server BlockingLocking and Blocking2010-04-06
Understanding SQL Server LockingLocking and Blocking2010-03-23
Function to Return Default SQL Server Backup FolderBackup2010-03-19
SQL Server sys.dm_os_wait_stats DMV QueriesDynamic Management Views and Functions2010-02-24
SQL Server Third Party Application Requirements Document and ChecklistDatabase Administration2010-01-25
Script to find SQL Server databases without transaction log backupsBackup2010-01-06
How to read SQL Server graphical query execution plansQuery Plans2009-11-04
Identify Orphaned Windows Logins and Groups in SQL Server with sp_validateloginsAuditing and Compliance2009-10-22
SQL Server Query Execution Plans in SQL Server Management StudioQuery Plans2009-10-12
SQL Server 2005 Index Best PracticesDBA Best Practices2009-10-06
Using Windows Groups for SQL Server Logins as a Best PracticeDBA Best Practices2009-09-03
Session State Settings for Cached SQL Server Query PlansDynamic Management Views and Functions2009-09-02
Find, compare and use the same session settings as another SQL Server userTesting2009-08-17
Third Party Application Checklist for SQL ServerDatabase Administration2009-08-12
Identify last statement run for a specific SQL Server sessionDynamic Management Views and Functions2009-07-22
Retaining historical index usage statistics for SQL Server Part 3 of 3Indexing2009-07-08
List columns and attributes for every table in a SQL Server databaseScripts2009-06-26
SQL Server Date function that determines date range based on weekdayDates2009-06-10
Retaining historical index usage statistics for SQL Server Part 2 of 3Indexing2009-06-05
Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema nameFunctions System2009-06-04
Retaining historical index usage statistics for SQL Server Part 1 of 3Indexing2009-05-12
SQL Server function to convert MSDB integer value to time valueFunctions User Defined UDF2009-05-05
SQL Server UDF to pad a stringFunctions User Defined UDF2009-04-27
Handling cross database joins with different SQL Server collationsJOIN Tables2009-03-27
How to find out what SQL Server rights have been granted to the Public roleAuditing and Compliance2009-02-24
How to eliminate SQL Server security issue caused by sp_replwritetovarbinSecurity2009-02-23
Manage the size of SQL Server Transaction LogsDatabase Administration2009-02-09
Getting additional error messaging information for SQL Server replicationReplication2009-02-03
Auto notification for failover or a restart of SQL Server servicesSQL Server Agent2009-01-12
Identify Windows Volumes on Clustered SQL Server Instance with DMVsClustering2009-01-05
Finding a string value in a SQL Server tableFunctions User Defined UDF2008-12-29
Configure SQL Server Resource Group Ownership in Cluster AdministratorClustering2008-12-22
Cluster Administrator Application for SQL Server DBAsClustering2008-12-17
Using the FORFILES Command to Delete SQL Server BackupsBackup2008-11-03
SQL Server 2008 Date and Time Data TypesDates2008-10-30
Launching a default Project in SQL Server Management StudioSQL Server Management Studio Configuration2008-10-20
Execute UPDATE STATISTICS for all SQL Server DatabasesMaintenance2008-10-17
SQL Server Management Studio customized startup optionsSQL Server Management Studio Configuration2008-10-10
Determine space used for a table using SQL Server Management StudioSQL Server Management Studio2008-09-26
SQL Server 7.0 to 2005 Security Vulnerabilities Could Allow Elevation of Login PrivilegesSecurity2008-09-19
SSRS Conditional FormattingReporting Services Dynamic Reports2008-09-18
Vacation for a SQL Server DBAProfessional Development Career Planning2008-08-25
SQL Server DBA Telecommuting TipsProfessional Development Skills Development2008-08-22
Managing SQL Server Database and Application MetadataDatabase Administration2008-08-19
Balancing Resources for SQL Server Clustering and ConsolidationClustering2008-08-13
Differences between SQL Server temporary tables and table variablesTemp Tables2008-08-06
SQL Server Clustering Active vs PassiveClustering2008-08-04
Getting started with SQL Server clusteringClustering2008-07-16
Rebuilding the SQL Server master database (Part 3 of 3)Disaster Recovery2008-07-03
Rebuilding the SQL Server master database (Part 2 of 3)Disaster Recovery2008-06-26
Rebuilding the SQL Server master database (Part 1 of 3)Disaster Recovery2008-06-23
Find All Columns in SQL Server Database with Default ValuesScripts2008-06-04
Options for scripting SQL Server database objectsSQL Server Management Studio2008-05-21
Modifying Microsoft Access Linked Tables from SQL ServerMicrosoft Access Integration2008-05-02
Custom job categories to organize your SQL Agent jobsSQL Server Agent2008-04-24
Microsoft Access Pass Through Queries to SQL ServerMicrosoft Access Integration2008-04-22
Configure Microsoft Access Linked Tables with a SQL Server DatabaseMicrosoft Access Integration2008-04-18
SQL Server DSN and ODBC ConfigurationSQL Server Configurations2008-04-07
Microsoft Access and SQL Server IntegrationMicrosoft Access Integration2008-04-04
Building and customizing SQL Server script templatesSQL Server Management Studio2008-03-28
SQL Server Script to Create Windows DirectoriesScripts2008-03-21
SSRS Configuration ToolReporting Services Configuration2008-03-12
Adding Reporting Services to an existing SQL Server 2005 installationReporting Services Installation2008-02-28
Correct the SQL Server Authentication Mode in the Windows RegistrySecurity2008-02-25
SQL Server 2005 Database Mail Setup and Configuration ScriptsDatabase Mail2008-02-20
How to setup linked servers for SQL Server and Oracle 64 bit clientLinked Servers2008-02-13
Collect SQL Server database usage for free space and trendingMonitoring2008-02-04
SQL Server function to determine if all characters are capitalizedFunctions User Defined UDF2007-11-07

Categories

Recent Articles

  • Building a Dynamic Countdown Timer in Power BI

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide