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 ozkary.com

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

Website: http://ozkary.com
LinkedIn: https://www.linkedin.com/in/oscardgarcia/

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

2019-05-23

5,482 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.58 (125)

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

51,440 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.