Rodrigo Acosta


Technical Article

Query Performance comparison between instances

Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!

3.33 (3)

You rated this post out of 5. Change rating

2016-12-19 (first published: )

838 reads

Technical Article

Function to encript password

If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password,  modifies every character and returns the encripted password.

You rated this post out of 5. Change rating

2004-03-18

589 reads

Technical Article

Sp to enable, disable or list all Triggers in  DB

This one is For SQL 2000.This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with […]

You rated this post out of 5. Change rating

2002-09-19

675 reads

Technical Article

Sp to enable, disable or list all Triggers in a DB (SQL 7)

This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with it current state. I didn't […]

You rated this post out of 5. Change rating

2002-09-16

594 reads

Blogs

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

By

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Read the latest Blogs

Forums

Connect tabular model to excel via Power BI semantic model

By Bhagat

I have a tabular cube, with myself included in one of the roles. I...

New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

By uratol

  Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers