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: )

815 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: )

222 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: )

428 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

singleton is interferring with getting multiple nodes in xml

By stan

Hi we have an xml doc shaped essentially as shown in image 2 below. ...

The backup to one location fails but is successful on another

By Arsh

Dear Friends, Would be glad if any of you can help in a backup...

How to set execution timeout in SSMS for SQL Server

By IT researcher

I tried to set the execution timeout in SSMS for SQL Server 2017 using...

Visit the forum

Question of the Day

Implementing Change Data Capture

I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?

See possible answers