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
2,123 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)
49,640 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,112 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,848 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
First DW design - advice appreciated
All, Up to this point I've only worked with relational databases. I'm trying to...
Backup Strategy For distributed availability groups
What is the recommendations for backups in distributed availability groups? I have AG setup...
What happens when I drop a huge table with LOBs? will the space be reused?
Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...
Ask SSC