SQL Homework – December 2018 – Configure SSMS
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
206 reads
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
206 reads
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,399 reads
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,536 reads
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....
2018-11-21
940 reads
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed...
2018-11-14 (first published: 2018-11-05)
1,941 reads
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...
2018-11-13
228 reads
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,904 reads
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...
2018-11-07
232 reads
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...
2018-10-31 (first published: 2018-10-22)
2,644 reads
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
322 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