Copy Triggers from One DB to Another
A simple script that transfers triggers from one database to another.
2013-03-04 (first published: 2013-02-12)
4,078 reads
Scripts
2013-02-28 (first published: 2013-02-12)
1,177 reads
ERRORFILE and MAXERRORS option with BULK INSERT
ERRORFILE and MAXERRORS option are rarely used important arguments in BULK INSERT so, I will try to highlight the use of these arguments in this script.
2013-02-27 (first published: 2013-02-14)
6,161 reads
Powershell - Query SQL Servers Operating system details
The script works through the CMS you have set up to manage your environment and gathers various server information.
2013-02-26 (first published: 2013-02-05)
1,692 reads
List Jobs and their respective programming.
List all active Jobs in SQL Server with the details of the schedule.
2013-02-25 (first published: 2013-02-07)
1,322 reads
2013-02-22 (first published: 2013-02-05)
1,822 reads
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,144 reads
2013-02-18 (first published: 2013-01-25)
2,800 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
6,125 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,299 reads
Blogs
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...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
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,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
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