Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...
2019-01-08
212 reads
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...
2019-01-08
212 reads
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...
2019-01-02 (first published: 2018-12-19)
7,558 reads
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...
2019-01-02
1,077 reads
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
433 reads
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...
2018-12-18 (first published: 2018-11-28)
2,760 reads
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,035 reads
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
1,073 reads
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
238 reads
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,083 reads
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
7,413 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