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,667 reads
ozkary
- Interests: big data, data science, cloud data platform
- Blog: ozkary.com
- Skills: Data Platform
- Website: https://www.ozkary.com
- LinkedIn: https://www.linkedin.com/in/oscardgarcia/
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)
55,306 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,473 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
10,035 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers