Introduction With SQL databases, a frequent task is to insert a record into a table that includes an Identity Field. Following this insertion, retrieving this newly generated ID for subsequent…
What are SQL fat pipes?
Introduction SQL fat pipes are a performance issue that can occur in SQL Server databases. They occur when a query scans or seeks a large number of rows from a…
Understanding the SQL “SELECT FROM a SELECT” Query
Introduction A common and useful feature in SQL is the ability to use a "SELECT FROM a SELECT" query, often referred to as a subquery or inner query. This post…
The SQL Like Command
Introduction The SQL LIKE command is used in a WHERE clause to search for a specified pattern in a column. It's commonly used in string comparison to find matches in…
Demystifying the SqlPackage.exe Command
Introduction As a SQL Server professional, you're likely familiar with the concept of database deployment and the tools that facilitate it. Among these tools, SqlPackage.exe is a versatile command-line utility…
SQL JSON: Taming the Wild World of JSON Data in SQL Server
Introduction JSON, or JavaScript Object Notation, has become the de facto standard for data interchange. Its flexibility and human-readable format make it ideal for representing complex data structures. However, integrating…
A Guide to Common Table Expressions
Introduction In SQL, Common Table Expressions (CTEs) are a powerful tool for structuring complex queries and enhancing data analysis. Introduced in the SQL:1999 standard, CTEs have gained immense popularity among…
Terminating Database Connections
Introduction In database administration, housekeeping routines play a critical role in maintaining the optimal performance and integrity of databases. These routines involve tasks such as optimizing tables, defragmenting indexes, and…
Moving SQL Server Log Files to a New Location
Introduction In many cases, it becomes necessary to move SQL Server log files to a different location. This can be done for various reasons, such as optimizing disk space utilization…
Fix Up SQL User Access
Introduction In any SQL Server instance, user logins play a crucial role in controlling access to databases and granting permissions to perform specific actions. However, as databases evolve and user…