SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Oscar D Garcia

SQLServerCentral.com profile

   Items 1 to 3 of 3   

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,088 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 | 48,570 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,799 reads
   Items 1 to 3 of 3