There are many interesting questions related to date calculations. For example, I have seen the following questions Give a date, find the first Tuesday day of the previous week/month/quarter,...
2022-01-28
144 reads
If you are using SSMS V17.4 as I am
You may encounter a weird error. This can be repeated as follows:
Open...
2018-02-06
463 reads
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,679 reads
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,657 reads
It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored...
2017-02-17
751 reads
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...
2017-01-26 (first published: 2017-01-19)
1,429 reads
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
706 reads
After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...
2016-12-01 (first published: 2016-11-28)
1,874 reads
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
1,989 reads
With SQL Server 2016 to be officially released this year, I want to make a wish list for the features...
2016-01-15 (first published: 2016-01-10)
1,674 reads
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Comments posted to this topic are about the item Local Storage Options
Comments posted to this topic are about the item DeepSeek: What is new with...
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers