A question came up recently concerning whether it was still possible to connect to .xlsx Excel files as SQL Server linked servers.
Short answer: Yes, it's possible as recently as...
2021-11-26 (first published: 2021-11-05)
1,579 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...
2021-11-05
17 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...
2021-11-04
21 reads
After my post last week on sorting the list, I now have a list of files, sorted in the right ... Continue reading
2021-11-12 (first published: 2021-11-04)
484 reads
It’s been a long two years for most of us, with little or no training budget being spent on us at conferences. Online events are convenient and accessible, but...
2021-11-03
53 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-11-03
10 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-11-12 (first published: 2021-11-03)
422 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...
2021-11-03
21 reads
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the Azure SQL space, SQL...
2021-11-03
105 reads
Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was...
2021-11-15 (first published: 2021-11-03)
311 reads
No two SQL Server environments are alike. A fix that resolves a performance issue...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...