(2020-Apr-19) Creating a data solution with Azure Data Factory (ADF) may look like a straightforward process: you have incoming datasets, business rules of how to connect and change them and...
2020-04-30 (first published: 2020-04-19)
4,152 reads
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-04-17
14 reads
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-05-04 (first published: 2020-04-17)
651 reads
I am super excited, and humbled, to have been selected to speak at the very first PASS virtual SQL Saturday, SQL Saturday Richmond, on Saturday, April 25, 2020. I...
2020-04-17
18 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-17
25 reads
We are living in some very interesting times and the technical conference community is facing some challenges like it never has before. So many in-person events have been postponed...
2020-04-16
18 reads
Did you ever want to rename an existing connection in Azure Data Studio? Unfortunately as of today (April 2020), there is no way to modify an existing connection group or...
2020-04-28 (first published: 2020-04-16)
788 reads
I figured it would be nice to start up a weekly chat while everyone is on lock down. If it goes well I’m up to make this a regular...
2020-04-16
52 reads
I am very excited to announce that I will be taking my paid precon content “Tools for SQL Server Query Performance Tuning” and presenting it for free. This is...
2020-04-23 (first published: 2020-04-16)
177 reads
Hi All, While I haven’t been writing here, I have been writing. I have a new article that has just been published on Simple Talk, and I am developing...
2020-04-16
63 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers