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,614 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,208 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,103 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,836 reads
Blogs
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What...
Last Week Reading (2019-09-22)
By Kamil
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...
Simple Graph Queries
In this post we saw how to create some graph tables with data. In...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
SSMS Login Properties can't change default language
Hello, I have a strange problem with my SSMS 18.2. As you can see...
Automate script for SQL Server Database backup
I am writing a script for automating database backup, which is not working properly....
Ask SSC