Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.
SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction
Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
Add a User Across Databases: A Tested Script With Cleanup
To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.
Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?
Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.
Buffer Pool Extension and In-Memory OLTP: What Each One Caches
Buffer Pool Extension caches clean pages of disk-based tables on an SSD. Memory-optimized tables have no pages, so it cannot hold them. This post proves it on SQL Server 2025 with two tables and read-only checks.
SQL SERVER – ReadOnly Databases with ReadOnly File Attribute
A reader attached a database that came up ReadOnly and would not switch to ReadWrite. Here is how the ReadOnly file attribute causes it, with repro steps.