Looking for a way in a SQL query to extract the IP address from a string and then rename it.
For example I have a date field called Date_Time and field called "message" and it contains data such as
TCP connection 72260 for Outside:22.214.171.124/4717 to Inside:0.0.0.0/650 duration 0:00:00 bytes 0 TCP Reset-I ()
TCP connection 7260 for Outside:126.96.36.199/4718 to Inside:10.10.10.10/60 duration 0:00:00 bytes 0 TCP Reset-I ()
I want to grab the IP address of 188.8.131.52 and return something like
2008-10-17 10:48:48 NewHostName <---- based on the IP of 123.123129.145
2008-10-17 10:50:17 AnotherHostName <---- based on the IP of 123.123123.19
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…