Have a Think
It's easy for most of us to get caught up in work and not stop to think about the larger picture, or the longer term. Steve Jones thinks you should make time for both of these.
SQL and Scope
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
Where SQL Server monitoring fits into your tech stack
This article explains the basic components of a tech stack, and the decisions and requirements that affect how and where monitoring tools generally, and a specialist SQL Server monitoring tool like SQL Monitor, in particular, fit into your stack.
Databases in Azure… Where to begin? Create a Database and log in!
Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.
The K8s Overview
Kubernetes is a technology Steve thinks will be important in the future and knowing a bit more about it can be important for your career.
Troubleshoot Slow RDS SQL Servers with Performance Insights
In this article we look at using AWS Performance Insights to help monitor and troubleshoot SQL Server performance issues when running on RDS.
Digging into Azure SQL Database Hyperscale Edition
This article will look deeper at the Azure SQL Database - Hyperscale edition, which was moved into General Availability (GA) in May 2019. This followed a bit of a preview time, when I first learned about how it worked in detail. I was impressed with the work being done, some of which will make it […]
Automating Schema Comparisons with SQL Compare Projects and PowerShell
Your PowerShell process for database comparison and deployment is running smoothly, and your instinct is to 'leave well alone'. However, you continually need to delve into the script to tweak comparison settings or add a new command line switch. Phil Factor proposes a way to avoid this using SQL Compare projects.
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
Losing The Security Game
Losing the security game is no fun when data is involved. Steve points out some things you should be doing.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers