Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got some data recently from an online...
2020-09-30 (first published: 2020-09-23)
322 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-30
9 reads
This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As with most things in...
2020-09-30
229 reads
There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and...
2020-09-29 (first published: 2020-09-23)
440 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-29
11 reads
Looking forward to presenting at SQLSaturday Memphis virtually this weekend!
Both my wife and I are on the schedule for Saturday, and the organizers chose interesting nontechnical topics for both...
2020-09-29
10 reads
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-09-29 (first published: 2020-09-22)
321 reads
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only...
2020-09-29
184 reads
Happy Tuesday everyone… Today I am honored to have my first article published on MSSQLTips.com. As a Production SQL Server Database Administrator, you do not usually find yourself in...
2020-09-28 (first published: 2020-09-22)
591 reads
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results...
2020-09-28 (first published: 2020-09-22)
1,165 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers