Jim Evans

Jim Evans is an IT professional who has worked with SQL Server since 1995. He has a passion for SQL Servers and working with the people who utilize it. As a C++ programmer early in his career he was mentored to learn T-SQL with optimizing for performance always a goal. He has supported many corporate business units and application, taken part in designing many databases, managed DBAs, BI Developer and Data Management teams. He is always up for a challenge, embraces new features and functionalities as they are rolled out and enjoys sharing his knowledge. When not working on SQL Server he has spends time coaching youth sports, coaching in a disability softball league and volunteering with Black Dagger Military Hunt Club providing outdoor activities for veterans.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2022 | Author Contender - 2021 | Rookie Contender - 2019
Title Category Date
SQL Server Current Date Dates2026-05-27
SQL Server Database Diagram Tool in Management Studio Database Design2026-05-21
SQL INSERT into Table with Code Examples TSQL2026-04-28
Getting Started with dbWatch Database Administration2026-04-22
Upgrade to SQL Server 2025 Enterprise Developer Edition Upgrades and Migrations2026-02-20
SQL Server 2025 Enterprise Developer Edition Download, Install and Configure Install and Uninstall2026-01-29
How to Create a SQL Server Agent Job in SSMS SQL Server Agent2025-12-15
SQL Convert Date to YYYYMMDD Dates2025-05-27
SQL Agent Job Output Options for Troubleshooting SQL Server Agent2025-02-27
SQL DELETE Statement Examples and Best Practices TSQL2025-01-13
How to Access the SQL Server Error Log Error Logs2024-08-23
Review SQL Table Attributes in SQL Server Management Studio SQL Server Management Studio Shortcuts2024-05-21
List All Azure SQL Databases and Properties with PowerShell Script Azure SQL Database2024-03-25
Archive SQL Server Data using the SQL OUTPUT Clause Database Administration2024-03-06
Compare SQL Server Offerings from Azure, AWS and Google Cloud Cloud Strategy2023-09-07
How to Query Multiple Azure SQL Databases and Save the Results PowerShell2023-08-23
Query Multiple SQL Servers and Databases with Registered Servers Central Management Servers2023-03-27
SQL Cheat Sheet for SELECT, INSERT, DELETE and UPDATE Commands TSQL2023-02-10
SQL Server Database Save Point for Recovery Restore2022-11-23
SQL UPDATE Examples TSQL2022-08-29
Learn SQL SELECT with Sample Queries TSQL2022-05-18
Always On SQL Server Upgrade Checklist Upgrades and Migrations2022-05-13
How to Connect to Microsoft SQL Server Remotely SQL Server Management Studio2022-03-23
SQL JOIN Types Quick Reference Guide JOIN Tables2021-12-15
SQL Join on Multiple Columns Examples JOIN Tables2021-12-09
SQL JOIN 3 Tables Sample Code JOIN Tables2021-11-17
SQL CROSS JOIN to get Every Combination of Records JOIN Tables2021-10-28
FULL OUTER JOIN SQL Examples JOIN Tables2021-09-23
SQL RIGHT JOIN Examples JOIN Tables2021-06-24
SQL INNER JOIN JOIN Tables2021-06-02
SQL DATE Functions Dates2021-05-18
COALESCE SQL Function Functions System2021-03-22
Combining Queries in SQL Server with Registered Servers Central Management Servers2021-03-05
SQL Server Change Tracking to Track Columns Updated Change Data Capture2021-02-24
Sync SQL Server Change Tracking Tables without Changing Data Change Data Capture2020-08-05
DATEDIFF SQL Server Function Dates2020-07-16
Analyze SQL Server Results in Excel with Conditional Formatting Microsoft Excel Integration2020-02-24
Compare SQL Server Results of Two Queries TSQL2019-10-23
Performance Tuning SQL Server Query without Execution Plan Performance Tuning2019-09-04
SQL Server Database Activity Based on Transaction Log Backup Size Monitoring2019-08-01
Fill In Missing Dates for SQL Server Query Output Dates2019-07-12
Delete Data from Large SQL Server Tables with Minimal Logging Database Administration2019-02-14