Getting Started with dbWatch
Explore dbWatch, a powerful tool for database administrators that simplifies monitoring and managing databases across platforms.
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
Upgrade to SQL Server 2025 Enterprise Developer Edition
Learn the steps to perform an SQL Server 2025 upgrade for the developer edition from older versions with our easy-to-follow guide.
SQL Server 2025 Enterprise Developer Edition Download, Install and Configure
Check out this step by step guide to install SQL Server 2025 Enterprise Developer Edition using either Basic or Custom options.
How to Create a SQL Server Agent Job in SSMS
In this article, I show how to create and schedule a SQL Server Agent Job and how to setup operator to receive notifications.
SQL Agent Job Output Options for Troubleshooting
This tip demonstrates options to configure SQL Agent Job to capture complete job output in a clean readable way to aid in troubleshooting.
How to Access the SQL Server Error Log
Learn about three different ways to access and read the SQL Server error logs and SQL Agent error logs when monitoring and managing SQL Server.
Review SQL Table Attributes in SQL Server Management Studio
In this tip, we look at ways to quickly get table attributes such as columns, data types, indexes, constraints, and more when using SSMS.
List All Azure SQL Databases and Properties with PowerShell Script
This article includes a PowerShell script that you can run to get a list of your Azure SQL Databases and additional data.
Archive SQL Server Data using the SQL OUTPUT Clause
This tip explores a better, more direct, and more optimized method for moving or archiving data in SQL Server using the SQL OUTPUT clause.
Compare SQL Server Offerings from Azure, AWS and Google Cloud
In this article, we look at the similarities and differences between what is offered for SQL Server for Azure, AWS, and Google Cloud.
How to Query Multiple Azure SQL Databases and Save the Results
In this article, we look at how to query multiple Azure SQL Databases and store all the results in a centralized location.
Query Multiple SQL Servers and Databases with Registered Servers
In this article, learn how to query all databases on multiple SQL Servers and store the results in a single table.
SQL Cheat Sheet for SELECT, INSERT, DELETE and UPDATE Commands
Learn how to use the basic SQL statements to add, retrieve, delete, and change data in a SQL Server table using INSERT, SELECT, DELETE, and UPDATE.
SQL Server Database Save Point for Recovery
Learn about options for creating a database save point establishing a recovery point before database deployments in case a rollback is needed.
SQL UPDATE Examples
In this article, we look at how to use the SQL UPDATE statement along with several examples and a way to not accidentally update the wrong data.
SQL DELETE Statement Examples and Best Practices
In this article, we look at how to use the SQL DELETE statement along with several examples and a way to not accidentally delete the wrong data.
SQL INSERT into Table with Code Examples
In this article learn about the basics of SQL INSERT statements along with several different examples of how to insert data into SQL Server tables.
Learn SQL SELECT with Sample Queries
In this article we look at how to use the SQL SELECT statement to query data from a SQL Server table along with several different examples.
Always On SQL Server Upgrade Checklist
Checklist you can follow to upgrade an Always On SQL Server environment from one version of SQL Server to a later version.
How to Connect to Microsoft SQL Server Remotely
Learn how to make a connection to a SQL Server database and how to connect to a database using SQL Server Management Studio and Azure Data Studio.
SQL JOIN Types Quick Reference Guide
Learn about the different types of JOINs that you can use in SQL Server to join tables along with examples and additional references.
SQL Join on Multiple Columns Examples
Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.
SQL JOIN 3 Tables Sample Code
In this article learn how to build a SQL Server query using 3 tables along with different examples.
SQL CROSS JOIN to get Every Combination of Records
Learn various ways you to do Cross Joins in SQL Server to get every combination of records between all tables.