Tim Ford

Tim Ford
Tim Ford is a Senior Database Administrator with MindBody.

linkedin  twitter 
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.
2010 Awards   MSSQLTips award

2009 Awards   MSSQLTips award

2008 Awards   MSSQLTips award

Category Tip Title
Auditing and Compliance How to find out what SQL Server rights have been granted to the Public role
Auditing and Compliance Identify Orphaned Windows Logins and Groups in SQL Server with sp_validatelogins
Backup Function to Return Default SQL Server Backup Folder
Backup Script to find SQL Server databases without transaction log backups
Backup Script to retrieve SQL Server database backup history and no backups
Backup Using the FORFILES Command to Delete SQL Server Backups
Central Management Servers Run SQL Commands Against Multiple SQL Servers Without CMS
Clustering Balancing Resources for SQL Server Clustering and Consolidation
Clustering Cluster Administrator Application for SQL Server DBAs
Clustering Getting started with SQL Server clustering
Clustering Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
Clustering Manually Configure SQL Server Resource Group Ownership in Cluster Administrator
Clustering SQL Server Clustering Active vs Passive
Database Administration Determine Free Space, Consumed Space and Total Space Allocated for SQL Server databases
Database Administration Find SQL Server databases where log file is too large
Database Administration Manage the size of SQL Server Transaction Logs
Database Administration Managing SQL Server Database and Application Metadata
Database Administration SQL Server Third Party Application Requirements Document and Checklist
Database Administration Third Party Application Checklist for SQL Server
Database Mail SQL Server 2005 Database Mail Setup and Configuration Scripts
Dates SQL Server 2008 Date and Time Data Types
Dates SQL Server Date function that determines date range based on weekday
Dates SQL Server function to convert integer date to datetime format
DBA Best Practices SQL Server 2005 Index Best Practices
DBA Best Practices Using Windows Groups for SQL Server Logins as a Best Practice
Disaster Recovery Rebuilding the SQL Server master database (Part 1 of 3)
Disaster Recovery Rebuilding the SQL Server master database (Part 2 of 3)
Disaster Recovery Rebuilding the SQL Server master database (Part 3 of 3)
Dynamic Management Views and Functions Collect and store historical SQL Server performance counter data with DMVs
Dynamic Management Views and Functions Collecting SQL Server performance counter data for trending
Dynamic Management Views and Functions How to Find Keywords in SQL Server Stored Procedures and Functions
Dynamic Management Views and Functions Identify last statement run for a specific SQL Server session
Dynamic Management Views and Functions Session State Settings for Cached SQL Server Query Plans
Dynamic Management Views and Functions SQL Server Performance Counter DMV sys.dm_os_performance_counters
Dynamic Management Views and Functions SQL Server sys.dm_os_wait_stats DMV Queries
Dynamic Management Views and Functions Useful management information from SQL Server DMV sys.dm_os_sys_info
Fragmentation and Index Maintenance SQL Server Index and Statistics Report
Functions System Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name
Functions User Defined UDF Finding a string value in a SQL Server table
Functions User Defined UDF SQL Server function to determine if all characters are capitalized
Functions User Defined UDF SQL Server UDF to pad a string
Functions User Defined UDF SQL Server user defined function to convert MSDB integer value to time value
Indexing Retaining historical index usage statistics for SQL Server Part 1 of 3
Indexing Retaining historical index usage statistics for SQL Server Part 2 of 3
Indexing Retaining historical index usage statistics for SQL Server Part 3 of 3
Integration Services Execute Package Options Run SSIS using xp_cmdshell in a SQL Server stored procedure
JOIN Tables Handling cross database joins that have different SQL Server collations
Linked Servers How to setup linked servers for SQL Server and Oracle 64 bit client
Locking and Blocking Understanding SQL Server Blocking
Locking and Blocking Understanding SQL Server Locking
Maintenance Execute UPDATE STATISTICS for all SQL Server Databases
Microsoft Access Integration Configure Microsoft Access Linked Tables with a SQL Server Database
Microsoft Access Integration Microsoft Access and SQL Server Integration
Microsoft Access Integration Microsoft Access Pass Through Queries to SQL Server
Microsoft Access Integration Microsoft Access Pass Through Queries to SQL Server in Detail
Microsoft Access Integration Modifying Microsoft Access Linked Tables from SQL Server
Monitoring Collect SQL Server database usage for free space and trending
Monitoring Find Current Running SQL Statement in SQL Server
Monitoring Identify Completion Time for Long Running SQL Server Processes using Dynamic Management Objects
Performance Tuning Analyzing SQL Server Plan Cache Performance Using DMVs
Performance Tuning Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
Professional Development Career Planning Vacation for a SQL Server DBA
Professional Development Skills Development SQL Server DBA Telecommuting Tips
Query Plans How to read SQL Server graphical query execution plans
Query Plans SQL Server Query Execution Plans in SQL Server Management Studio
Replication Getting additional error messaging information for SQL Server replication
Reporting Services Configuration SQL Server Reporting Services Configuration Tool
Reporting Services Dynamic Reports SQL Server Reporting Services Conditional Formatting
Reporting Services Installation Adding Reporting Services to an existing SQL Server 2005 installation
Scripts Finding and listing all columns in a SQL Server database with default values
Scripts List columns and attributes for every table in a SQL Server database
Scripts Run same command on all SQL Server databases without cursors
Scripts SQL Server Script to Create Windows Directories
Security Correct the SQL Server Authentication Mode in the Windows Registry
Security Creating a SQL Server proxy account to run xp_cmdshell
Security How to eliminate SQL Server security issue caused by sp_replwritetovarbin
Security Identifying SQL Server logins with overlapping server roles
Security SQL Server 7.0 to 2005 Security Vulnerabilities Could Allow Elevation of Login Privileges
SQL Server Agent Auto notification for failover of a server and restart of SQL Server services
SQL Server Agent Custom job categories to organize your SQL Agent jobs
SQL Server Agent Reassign Job Ownership for All Jobs on All SQL Servers
SQL Server Agent Verbose SQL Server Agent Logging
SQL Server Configurations SQL Server DSN and ODBC Configuration
SQL Server Management Studio Building and customizing SQL Server script templates
SQL Server Management Studio Determine space used for a table using SQL Server Management Studio
SQL Server Management Studio Options for scripting SQL Server database objects
SQL Server Management Studio Configuration Launching a default Project in SQL Server Management Studio
SQL Server Management Studio Configuration SQL Server Management Studio customized startup options
Testing Find, compare and use the same session settings as another SQL Server user
TSQL Differences between SQL Server temporary tables and table variables
TSQL Using INSERT OUTPUT in a SQL Server Transaction
Upgrades and Migrations Transition from MS Access to SQL Server with the Migration Assistant
No Records Found
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (31)
Analysis Services Analysis Services Development (94)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (147)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (14)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (199)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (41)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (85)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (41)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (77)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (72)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (73)
Database Development Query Optimization (14)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (365)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (148)
Power Platform Power BI Charts (51)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (50)
Professional Development Professional Development Community (16)
Professional Development Professional Development Conferences (2)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (18)
Professional Development Professional Development Management (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (196)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms