SQL Puzzle: Advent of Code
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar...
2018-08-29
521 reads
Blog Posts
Undercover TV- Episode 2
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...
2018-08-29
378 reads
What are my permissions?
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z...
2018-08-29 (first published: 2018-08-16)
3,196 reads
Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
232 reads
Generating a Constrained Random Date–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-28
1,225 reads
How Do Azure Accounts and Subscriptions Work Together?
Azure accounts vs. Azure subscriptions – often a topic that brings some confusion to Azure newbies. Are they the same? What’s...
2018-08-28
205 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
14 reads
Ignoring NULLs with FIRST_VALUE
Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...
2018-08-28
8,922 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
11 reads
MAXDOP Calculator
Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance...
2018-08-28
13,865 reads
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