Building Great Software
Steve notes that building great software isn't easy, and there is a lot of work that goes into this. Even in today's age of AI.
OUTER APPLY Fundamentals: Part 2
In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.
Create SQL Server 2025 Availability Groups with SSMS Wizard
SQL Server Availability Groups are great for DR and HA purposes. In this article, we look at how to setup a SQL Server 2025 Availability Group using the features in SQL Server Management Studio.
How to Work with On-Premises AI Models to Generate T-SQL Code
See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.
Imagine the Physical World
Today Steve notes that he often compares the work a computer does to what might happen if the same actions occurred in the physical world.
How SQL Server maintenance becomes an attack path – and what to do about it
The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
Managing Incidents and Fighting Fires
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
BIT_COUNT in SQL Server
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
Power BI Best Practices
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers