Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
20 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
24 reads
Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,805 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
941 reads
Non use of persisted data – Part deux
In my last blog I showed how persisted data may not be used if you have used the base data...
2011-06-20
541 reads
Difference between Checkpoint and LazyWriter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
1,047 reads
Difference between Checkpoint and LazyWritter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
558 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help...
2011-06-20
907 reads
Table Backups and the TableArchive Database
A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...
2011-06-20
914 reads
Presenting Two Sessions at PASS Summit 2011
I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...
2011-06-19
920 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers