Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy
Learn how you can configure clean and size management for your SSIS catalog database.
2019-05-23
14,419 reads
Learn how you can configure clean and size management for your SSIS catalog database.
2019-05-23
14,419 reads
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
55,298 reads
For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.
2009-11-02
3,472 reads
Using VB Script allows one to script out all the Sql Server objects in independent file.
2009-03-25
10,032 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item 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