Join SQL Server tables where columns include NULL values
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
Eyes Wide Open
Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.
Tracking Failed Job Steps
Recently a customer was asking for a way to alert on job steps that failed, but the job succeeded. They really wanted a custom metric for SQL Monitor, which I submitted, but this post looks at the query in general, trying to determine if a job step failed. Note: Let me start by noting that […]
Diagnose and resolve latch contention on SQL Server
This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.
Schedule Azure SQL DB Processes using Azure Functions
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
What to do with more free time
Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]
Are You a Tech Company?
Is your company a tech company? Steve Jones looks at the world from the perspective of software development and how that impacts business.
Formatting T-SQL Scripts using ScriptDOM and PowerShell
Well-formatted scripts are always easier to maintain and enhance readability to high degree. Formatting standards are an important part of coding standards anywhere and if not, they need to be. If there are a large number of scripts this can add up to a significant amount of time needed to maintain them. It is also […]
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
Flyway with SQLite for Those of a Nervous Disposition
Get started with running Flyway migrations on SQLite databases, using PowerShell.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers