Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
16 reads
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
16 reads
Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...
2019-03-05 (first published: 2019-02-19)
3,256 reads
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
3 reads
This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way...
2019-03-01 (first published: 2019-02-12)
3,220 reads
Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...
2019-02-26
890 reads
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
5 reads
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
6 reads
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...
2019-02-12
1,650 reads
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
4 reads
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
Let's get one thing straight: database administration isn't the most glamorous tech job out...
I am working on a data warehouse project for a bakery. For the most...
I am working on a data warehouse project for a bakery. For the most...
Hi I want to create a copy of a DB on the same server....
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers