Find tables unused since last SQL Server restart
This script will return tables that haven't had any user activity since the SQL Server Service was last restarted. SQL 2005+
2011-07-22 (first published: 2010-01-28)
5,277 reads
Kill all SPIDs with a certain user ID
This script is used to disconnect all connections by a particular individual to a server. I use it when I have to disconnect somebody and they have too many processes to do it by hand. Normally, you can just connect the offending process, but if there are multiple processes that are causing a problem , […]
2004-03-08
1,241 reads
Blogs
Using Azure Data Factory Mapping Data Flows to populate Data Vault
By Rayis Imayev
(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure...
New Azure “SQL Server settings” blade in the Azure Portal
I just noticed today that there is a new blade in the Azure portal...
Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task....
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Buffer Pool calculation
Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines...
SSIS Scale out deployment in a high availability cluster
Good day all, Just wondering if it will be possible to have a scale-out...
Ask SSC