Distribution Database Migration
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
2014-11-20
9,190 reads
Articles
Monitoring Azure SQL Database
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
2014-11-20
8,841 reads
Where in the Application Should Data Validation be Done?
Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.
2014-11-19
11,050 reads
Removing Rows with the DELETE Statement in SQL Server
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
2014-11-18
11,181 reads
SQL Monitor Custom Metric: Possible Duplicate Indexes
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
2014-11-18
7,931 reads
SQL Overview VII - SSRS Reports and Subscriptions
In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.
2014-11-17
5,296 reads
SSIS 2012 Projects: Setup, Project Creation and Deployment
It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.
2014-11-17
8,447 reads
ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-14 (first published: 2012-06-19)
9,067 reads
Overcoming the OPENQUERY Record Limit for AD
Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.
2014-11-13
8,094 reads
Configuring Critical SQL Server Alerts
What do you do when you want to receive critical server health alerts?
2014-11-13
8,936 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers