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
18 reads
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
18 reads
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
7 reads
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your...
2011-08-23
839 reads
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
12 reads
Demo files from my presentation at Dallas Tech Fest 2011.
SQL Server CLR – An Introduction – Dallas Tech Fest 2011
2011-08-12
714 reads
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,133 reads
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,465 reads
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,820 reads
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,127 reads
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,429 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Hi, it isnt clear from the web if something like this should work as...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers