External Article

Manipulating Multiple Objects in SQL Server Management Studio

Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.

Technical Article

TSQL Challenge 21 - Reading, recognizing and processing graphical representation of digits.

Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here is something that is very interesting where you might need to process records in a 'three-line-at-a-time' fashion.

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

SWAG Saves the Day

By

PASS Summit East is in one week. I was on the road last week...

Upgrading SQL Server Containers on the Laptop

By

I don’t have SQL Server installed on my laptop. In an effort to keep...

Read the latest Blogs

Forums

BCA KCP Gading Square Tlpn/Wa 0853.7373.7551

By thammyvienula

Blk. B, Komplek Rukan Kelapa Gading Square, Jl. Boulevard Bar. Raya No. 21 &...

BCA KCP Gudang Peluru Telpon/WA:08137887595

By tanehome

BCA KCP Gudang Peluru Telpon/WA:08137887595.Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar No.23...

BCA KCP Graha Inti Fauzi Telpon/WA:08137887595

By tanehome

BCA KCP Graha Inti Fauzi Telpon/WA:08137887595.Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt....

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers