2011-03-04 (first published: 2011-02-21)
6,168 reads
Scripts
Monitoring Resource Governor Memory Grants
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,209 reads
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,116 reads
2011-03-01 (first published: 2011-02-18)
4,072 reads
Columns Explorer - With constraints create / drop scripts (no cursors)
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,624 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
2011-02-25 (first published: 2011-02-09)
2,061 reads
2011-02-21 (first published: 2011-02-05)
1,968 reads
2011-02-18 (first published: 2011-01-25)
3,090 reads
Financial Month
This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.
2011-02-16 (first published: 2011-02-05)
1,542 reads
(new) Kill ALL Connections To a SQL Database
Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.
2011-02-15 (first published: 2011-01-26)
3,959 reads
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Alamat BCA KCP Raden Saleh +62 838-4945-0961
Wa:083849450961 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec. Senen, Kota...
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers