ozkary

Oscar Garcia is a Principal Software Architect who resides in South Florida. He is a Microsoft MVP and certified solutions developer with many years of experience building enterprise software solutions. He specializes in building cloud solutions using technologies like AWS, Azure as well as data platform and BI projects for data visualization using SQL Server, Firebase, Redshift, JMP, Tableau and PowerBI. You can follow Oscar on Twitter @ozkary or his blog at www.ozkary.com

Interests: big data, data science, cloud data platform
Blog: ozkary.com
Skills: Data Platform

All authors

Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy

by ozkary

SQLServerCentral

Learn how you can configure clean and size management for your SSIS catalog database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2019-05-23

14,469 reads

Discuss

Map IP Address to a Geographical Location

by ozkary

SQLServerCentral.com

SQL Server

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(125)

You rated this post out of 5. Change rating

2012-07-20 (first published: 2009-07-09)

55,301 reads

Discuss

Automate the Publishing of Data Changes into DML Scripts

by ozkary

SQLServerCentral.com

SQL-DMO

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.