Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
354 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
354 reads
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
895 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
287 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,132 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
425 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
467 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,878 reads
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...
2018-05-09
243 reads
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...
2018-05-02
255 reads
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
378 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers