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
1,087 reads
ozkary
Map IP Address to a Geographical Location
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)
48,741 reads
Automate the Publishing of Data Changes into DML Scripts
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,097 reads
How to Get the Scripts for SQL Server Objects
Using VB Script allows one to script out all the Sql Server objects in independent file.
2009-03-25
9,809 reads
Blogs
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Function Issues
I have created the following function which is to be used for a check...
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
Ask SSC