Setting Different Colors for Connections in SSMS
Learn how to set colors for different connections in SSMS.
2015-03-13 (first published: 2013-09-17)
29,357 reads
Peter Schott
Grant EXEC on all Stored Procedures to a Role
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
15,680 reads
Blogs
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get...
Daily Coping 17 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the...
Forums
UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue
I've been working a little bit with a few tables here, they've got "CreatedDate"...
Multiple deadlocks occuring on simultaneous deletions from temporal table
We have a stored procedure which is attempting to delete 1-2 rows at a...
Foreign key for Xml Datatype
Is foreign key constraint possible in xml data type? OR Is it possible to...
Ask SSC