Sync SSMS Tools Pack Across Computers Using SyncToy
My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me a lot of time and effort. DBAs where I...
2011-10-06
21 reads
Eric Humphrey
Sync SSMS Tools Pack Across Computers Using SyncToy
My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me a lot of time and effort. DBAs where I...
2011-10-06
9 reads
Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your...
2011-08-23
844 reads
Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...
2011-08-23
14 reads
Dallas Tech Fest – Demo Files for SQL Server CLR: An Introduction
Demo files from my presentation at Dallas Tech Fest 2011.
SQL Server CLR – An Introduction – Dallas Tech Fest 2011
2011-08-12
715 reads
Prevent SQL Logins from using SSMS … or any other app
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,134 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,496 reads
Disable SQL Agent Jobs with PowerShell
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,827 reads
Get all SERVERPROPERTY values for SQL Server
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,196 reads
Notes for Moving BizTalk’s Databases
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,430 reads
Blogs
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers