In SQL Server Integration Services, connection managers are used as gateways for most any external read and write operation. Connection managers are type- and format-specific, and in the case...
2019-09-24 (first published: 2019-09-16)
364 reads
Here are the things you must/should probably know about PASS Summit 2019, as told by me. Included: Advice for first timers Prioritized schedule at a glance Sessions we recommend...
2019-09-23
40 reads
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-09-23
60 reads
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-09-23
I recently found this DMV and couldn’t wait to share. sys.dm_server_services What’s so great about it? For each service for ... Continue reading
2019-09-23 (first published: 2019-09-12)
1,023 reads
I reviewed a set of wireless headphones this summer, and I continue to use them when traveling. They work well for me and have good battery life. The company...
2019-09-23
19 reads
I’ve been waiting for this a long time. Over the years, as Redgate has improved and changed the SQL Change Automation product in Visual Studio, I’ve been wanting to...
2019-09-23
66 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-09-23
170 reads
Out of necessity are born the tools of laziness. This is a good thing. I have found that organizing and running a SQL Saturday event is a great way...
2019-09-23 (first published: 2019-09-13)
362 reads
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to admit but I missed last week’s post due to my visit to Sweden (SQLSaturday) and...
2019-09-22
11 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