Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag IP Addresses Rss

   Items 1 to 6 of 6   
 

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,131 reads

Optimal Storage of IP addresses in a SQL Server database

Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?  Read more...
By Additional Articles 2011/12/07 | Source: MSSQLTips.com | Category: ip addresses
Rating:  Rate this |   Briefcase | 3,391 reads

Get SQL Server IP Address

To Get Server IP Address without having to log into box or RDP  Read more...
By Shirley Bouzon 2011/08/02 | Source: SQLServerCentral.com | Category: ip addresses
Rating: |  Discuss |   Briefcase | 2,749 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,131 reads

Storing IPv4 Addresses for Performance

An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries  Read more...
By Jean-Sebastien Carle 2009/08/19 | Source: SQLServerCentral.com | Category: ipv4 addresses
Rating: |  Discuss |   Briefcase | 8,229 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,131 reads
   Items 1 to 6 of 6   
 
Tags
sql server (2)    
geo database (1)    
ipv4 addresses (1)    
optimization (1)    
performance tuning (1)    
storage (1)    
substring (1)    
t-sql (1)