SQL IS NULL and SQL IS NOT NULL Examples
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User's Group.
- MSSQLTips Awards: Author of the Year Contender - 2021, 2022 | Trendsetter (25+ tips) - 2021
SQL EXISTS Use Cases and Examples
This tip will explain what the SQL Server keyword EXISTS does and show several different use cases of how you can use EXISTS.
SQL NULL Meaning and How to Handle NULL Values
This tip will help you understand what NULL means and different ways to handle NULL values when working with SQL Server data.
SQL Server Deprecated Features Management
Learn about deprecated features in SQL Server, if it is bad to use them, and what you should do if you are using them.
SQL Scripts for Monitoring Current Activity, Blocking and Performance
Enhance your DBA toolkit with essential SQL monitoring scripts to address performance issues and streamline your server management.
Identify SQL Server Locking and Blocking for Rows, Tables and Objects
This article provides SQL code to determine what file, table, row, or other object is locked and causing SQL Server blocking.
SQL Cheat Sheet for SQL Server DBA Daily Operations
This article contains various code fragments and scripts that could be used to manage and check on SQL Server and databases.
Troubleshoot Performance with User Defined Functions in SQL Server
Troubleshoot SQL Server User-Defined Function performance issues using actual execution plans, estimated execution plans, and live query statistics.
Learn Prepared Statements in SQL Server
Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.
How to get Time from a RowVersion value with T-SQL Code
Check out this article to help you figure out real dates and times when using a SQL Server RowVersion value.
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server
This tip shows several examples of COUNT and COUNT DISTINCT to show how SQL Server handles them differently.
SQL LIKE Statement Examples
Learn the SQL LIKE statement to find various text patterns contained within a set of text along with many different examples of how to use LIKE.
SQL IF Statement for Conditional Logic
Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
Database Performance, Monitoring and Management with dbWatch
Learn about dbWatch Control Center to help you better manage your database environment for SQL Server, Oracle, Postgres, Azure, AWS, and more.
Offload SQL Server Reporting to a Separate Database
In this article we look at different ways you can offload reporting to another SQL Server instance to minimize impact to production databases.
Adding SQL Comments to Code
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
Manage SQL Server Without Remote Desktop Connections
In this second article we learn more ways of how to manage SQL Server without having to make remote desktop connections to the server.
Reasons to Not Access SQL Server Remotely
Learn ways to avoid making remote desktop connections to SQL Server and still be able to install, patch, read error logs and manage the server.
SQL Server datetimeoffset for Time Zones
In this article we look at the datetimeoffset data type in SQL Server and how this can be used to determine dates for different time zones.
SQL WHERE Clause to Filter Rows for SELECT, UPDATE and DELETE
In this article we take a look at the SQL WHERE clause and how this can be used to filter rows for selecting, updating and deleting data.
SQL ORDER BY Clause Code Examples
Learn how to use the SQL ORDER BY clause to provide different sort orders for query results along with several different examples.
Data Architect for SQL Server
This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
SQL Server Database Roles and Job Titles
Learn about various job titles and positions for SQL Server. This will give you an idea of the different types of database roles that exist.
SQL NOT EQUAL Examples
Learn about writing TSQL statements using the not equal operator along with various examples of using not equals.