Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,062 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,260 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,739 reads
   Items 1 to 3 of 3