Technology Musings
In: SQL Server
2 Oct 2008I stumbled upon a few little gems that SQL Server 2008 includes that I hadn’t yet heard about. Although, very few are deploying SQL 2008 to production currently, these enhancements might make life programming in 2008 much easier.
In: SQL Server
1 Oct 2008T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.
In: SQL Server
24 Sep 2008SQL Server T-SQL function to calculate the number of weekdays between two dates and helper function to return the maximum of two integers.
In: SQL Server
22 Sep 2008Split delimited values into a table using T-SQL UDF.
In: Windows
26 Aug 2008Much to my dismay this morning, I had problems opening a VPN connection home: The connection opened, but wouldn’t retrieve an IP address from the DHCP server… okay, not a problem, I can just manually set an IP and be on my merry way. It would have been that easy if the OpenVPN TAP adapter [...]