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.
2019 Awards
2019 Awards
Central Management Servers
- Combine Multiple SQL Server Query Results with Registered Servers (last update: 3/5/2021)
Change Data Capture
- SQL Server Change Tracking to Track Columns Updated (last update: 2/24/2021)
- Sync SQL Server Change Tracking Tables without Changing Data (last update: 8/5/2020)
Database Administration
- Delete Data from Large SQL Server Tables with Minimal Logging (last update: 2/14/2019)
Database Design
- SQL Server Database Diagram Tool in Management Studio (last update: 12/17/2019)
Dates
- DATEDIFF SQL Server Function (last update: 7/16/2020)
- Fill In Missing Dates for SQL Server Query Output (last update: 7/12/2019)
- How to Get Current Date in SQL Server (last update: 4/9/2021)
- SQL Convert Date to YYYYMMDD (last update: 7/22/2021)
- SQL DATE Functions (last update: 5/18/2021)
JOIN Tables
- Getting Started with SQL INNER JOIN (last update: 6/2/2021)
- Join 3 Tables in SQL (last update: 11/17/2021)
- Learn SQL FULL OUTER JOIN with Examples (last update: 9/23/2021)
- Learning SQL CROSS JOIN with Examples (last update: 10/28/2021)
- SQL RIGHT JOIN Examples (last update: 6/24/2021)
Microsoft Excel Integration
- Analyze SQL Server Results in Excel with Conditional Formatting (last update: 2/24/2020)
Monitoring
- SQL Server Database Activity Based on Transaction Log Backup Size (last update: 8/1/2019)
Performance Tuning
- Performance Tuning SQL Server Query without Execution Plan (last update: 9/4/2019)
TSQL
- COALESCE SQL Function (last update: 3/22/2021)
- Compare SQL Server Results of Two Queries (last update: 10/23/2019)
