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

810 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

569 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

670 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

588 reads

Blogs

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

What I Love About My Job

By

In June this year I took redundancy from the company I’d worked at for...

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

Read the latest Blogs

Forums

STUFF Command Not Working

By AMCiti

I am trying to use the STUFF command, however, the column using the STUFF...

SQL Replication - Disconnected from Azure Storage with OS result code: 0

By DanielP

Hello, We had a few errors with replication for SQL Managed Instance stopped working...

Provider not found in SSMS

By cphite

I am trying to setup a linked server and per the documentation it needs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers