You Are a Professional, So Speak Up
You are hired for your ideas so share them, it can only help your career.
2008-07-31
174 reads
Stacey Gregerson
Linked SQL Servers, databases, and users Report
Fixed user protion of the script. Sorry had the test script mixed with prod. I was asked to create a report listing all of our SQL Servers, and the databases on them. I was also asked to list everyone that has access to each database and whether it was a standard, windows or windows group […]
2002-10-15
1,044 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Question about deadlock
Hello DBAs, I am facing some deadlock issue and after investigation from trace flag...
Get Date Based on TimeOffSet and Day
Team I have a table which carries the below columns and values TimeOffSet >...
MSDTC and Always On AG
Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...
Ask SSC