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
9 reads
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
9 reads
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
1 reads
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
3 reads
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
11 reads
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,210 reads
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
3 reads
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
256 reads
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
2 reads
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
6 reads
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
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers