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
15 reads
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
5 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
815 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
7 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
710 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,129 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,381 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,790 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
12,629 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,425 reads
Blogs
A New Word: Amoransia
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Forums
DbDefence - how does work this tool?
How it is implemented? I have installed, tried, it is free for dbs <=30...
Technical Pain Behaviors
Comments posted to this topic are about the item Technical Pain Behaviors
trying to call powershell from TSQL statement
Hello, trying to call a powershell file I created, locally on the server, but...
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers