SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
18 reads
measure twice, cut once.
More Times Like These with SQL Server
I blogged the other about have some issues translating Oracle date formats to SQL Server date data types I find the way SQL Server handles dates with a defined...
2021-12-06
4 reads
Times Like These with SQL Server
I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...
2021-12-02
5 reads
What exactly is a modern data warehouse?
G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...
2020-12-14
12 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-24 (first published: 2020-06-09)
6,653 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-09
5 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
279 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
4 reads
OPENJSON : Getting to the data, and the PATH – PART II
We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...
2020-06-07
15 reads
OPENJSON : Getting to the data, and the PATH – PART II
We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...
2020-06-07
1 reads
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
SQL 2022 upgrade issues
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Script-Drop Orphan users from SQL Server Database
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
The Hidden Cost of Ignoring Software Bugs
Every expert knows you can't make perfect software that never crashes or has bugs....
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers