IP address to octets split in TSQL

Split IP addresse into octets in SQL Server
In case you need to handle IP addresses in SQL, they are not much useful as string values. To do anything with them rather then just storing and retrieving (checking the ranges for example) you need to split IP address to segments (octets). The following is modified method I run into online. ... read more

Reducing the number of Stored Procedures for the Application

Approach to reduce number of stored procedure for the application
Nowadays, in the years of ORM, barely anyone thinks about stored procedures, but they are still there and accessing and reading data with ADO and SqlDataReader ist still the fastest way. Stored procedures are validated, parsed and compiled in SQL server, so these steps are not required to be performed versus plaint text query (which is what entity framework generates for accessing data). ... read more

Umbraco CMS

read more


read more