Get Free Tips
MSSQLTips.com

Author: Jim Evans

Home » Archives for 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

TitleCategoryDate
SQL Server Database Diagram Tool in Management StudioDatabase Design2025-05-28
SQL Convert Date to YYYYMMDDDates2025-05-27
SQL Agent Job Output Options for TroubleshootingSQL Server Agent2025-02-27
SQL DELETE Statement Examples and Best PracticesTSQL2025-01-13
SQL Server Current DateDates2024-12-30
How to Access the SQL Server Error LogError Logs2024-08-23
Review SQL Table Attributes in SQL Server Management StudioSQL Server Management Studio Shortcuts2024-05-21
List All Azure SQL Databases and Properties with PowerShell ScriptAzure SQL Database2024-03-25
Archive SQL Server Data using the SQL OUTPUT ClauseDatabase Administration2024-03-06
Compare SQL Server Offerings from Azure, AWS and Google CloudCloud Strategy2023-09-07
How to Query Multiple Azure SQL Databases and Save the ResultsPowerShell2023-08-23
Query Multiple SQL Servers and Databases with Registered ServersCentral Management Servers2023-03-27
SQL Cheat Sheet for SELECT, INSERT, DELETE and UPDATE CommandsTSQL2023-02-10
SQL Server Database Save Point for RecoveryRestore2022-11-23
SQL UPDATE ExamplesTSQL2022-08-29
SQL INSERT into Table with Code ExamplesTSQL2022-06-17
Learn SQL SELECT with Sample QueriesTSQL2022-05-18
Always On SQL Server Upgrade ChecklistUpgrades and Migrations2022-05-13
How to Connect to Microsoft SQL Server RemotelySQL Server Management Studio2022-03-23
SQL JOIN Types Quick Reference GuideJOIN Tables2021-12-15
SQL Join on Multiple Columns ExamplesJOIN Tables2021-12-09
SQL JOIN 3 Tables Sample CodeJOIN Tables2021-11-17
SQL CROSS JOIN to get Every Combination of RecordsJOIN Tables2021-10-28
FULL OUTER JOIN SQL ExamplesJOIN Tables2021-09-23
SQL RIGHT JOIN ExamplesJOIN Tables2021-06-24
SQL INNER JOINJOIN Tables2021-06-02
SQL DATE FunctionsDates2021-05-18
COALESCE SQL FunctionFunctions System2021-03-22
Combining Queries in SQL Server with Registered ServersCentral Management Servers2021-03-05
SQL Server Change Tracking to Track Columns UpdatedChange Data Capture2021-02-24
Sync SQL Server Change Tracking Tables without Changing DataChange Data Capture2020-08-05
DATEDIFF SQL Server FunctionDates2020-07-16
Analyze SQL Server Results in Excel with Conditional FormattingMicrosoft Excel Integration2020-02-24
Compare SQL Server Results of Two QueriesTSQL2019-10-23
Performance Tuning SQL Server Query without Execution PlanPerformance Tuning2019-09-04
SQL Server Database Activity Based on Transaction Log Backup SizeMonitoring2019-08-01
Fill In Missing Dates for SQL Server Query OutputDates2019-07-12
Delete Data from Large SQL Server Tables with Minimal LoggingDatabase Administration2019-02-14

Categories

Recent Articles

  • 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

  • Database Modernization with AI-Powered Tools

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

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