In most places, we use some kind of field naming convention. Many times we have one or more fields with similar name in all tables for some kind of tracking. You can use this query to find similar names in all tables.
2002-04-29
224 reads
There are times you want to kill all the connections in a database. This would do that trick. This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.
2002-04-17
2,438 reads
During some maintenance task, you might not want any one to connect to a database. This script would help you do that. If you need to run this script, you might also need my other script to kill connections.
2002-04-17
769 reads
2002-04-01
765 reads
This script would help find primary key, foriegn key, unique constraints, check constraints on a table. With slight modification you can use it to find various information about a table.
2002-04-01
589 reads
2002-04-01
680 reads
This script would help you find users, their logins, roles etc in a database.
2002-04-01
331 reads
I know I can use extended events (xevents) in Azure SQL DB when in...
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
I'm working with someone whose client says "Yes, we have a data warehouse. But...
Hi Folks, I have been tasked with reviewing all the activity on a...
Ask SSC