Repair SQL Server on Linux after an Ubuntu distribution upgrade
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more...
2018-07-25
353 reads
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more...
2018-07-25
353 reads
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient...
2018-07-11
327 reads
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
313 reads
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
374 reads
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
922 reads
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the...
2018-06-13
299 reads
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in...
2018-06-06
1,151 reads
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
455 reads
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...
2018-05-23 (first published: 2018-05-16)
3,890 reads
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
482 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