Technical Article

Run SQL on All servers in your inventory

There are many times you have to deploy a common code in all of your SQL Servers. I am sure there might be thousands of way to do this, but here is how I do it and it works great. Good thing is - you can either pass SQL Statement or a SQL script (in […]

5 (2)

You rated this post out of 5. Change rating

2007-03-05 (first published: )

820 reads

Technical Article

Check missing exec permission on Stored proc

Stored procedure usp_CheckMissingPermission_for_User checks missing exec permission for given user or group on all the stored procedures within the database. It not only detects missing exec permission, but also generates a scripts for you to fix the problem.

You rated this post out of 5. Change rating

2005-05-30 (first published: )

229 reads

Technical Article

Generates Filegroup listing on a db for each table

This script generates filegroup listing on a given database for each table within the database. This will be very handy to indentify which table is built on a particular filegroup. This is useful for a VLDB (very large database).

5 (1)

You rated this post out of 5. Change rating

2005-05-27 (first published: )

443 reads

Blogs

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Capturing errors and auditing in Azure SQL DB

By

Logging is a necessity in the database world, well, the entire tech world. You...

Read the latest Blogs

Forums

The Mindset of a Database Administrator: A Love Letter to Risk Aversion

By dbakevlar

Comments posted to this topic are about the item The Mindset of a Database...

Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You

By Chandan Shukla

Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...

how to move all SP from one db to another db?

By water490

Hi everyone I have two db - one is test and other is archive. ...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers