SQLServerCentral - Guest Columnist: Oscar D Garcia

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. Read more...

By Oscar D Garcia 2009/11/02 | Source: SQLServerCentral.com | Category: sql-dmo

Rating:

|

Discuss |

Briefcase | 3,053 reads

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. Read more...

By Oscar D Garcia 2012/07/20 (first published: 2009/07/09) | Source: SQLServerCentral.com | Category: sql server

Rating:

|

Discuss |

Briefcase | 47,969 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. Read more...

By Oscar D Garcia 2009/03/25 | Source: SQLServerCentral.com | Category: vbscript

Rating:

|

Discuss |

Briefcase | 9,655 reads