Archive for the ‘Microsoft’ Category

I 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.

T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.

SQL Server T-SQL function to calculate the number of weekdays between two dates and helper function to return the maximum of two integers.

Split delimited values into a table using T-SQL UDF.

Much 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 [...]


  • Graham Charles: I've been considering using this approach to forward individual users' e-mail, but I'm curious if th [...]
  • Paden: Ok another 15min all sorted. something between changing default account on iphone to the exchange go [...]
  • Paden: Thank you I'm sooo close! Same thing as Brandon & Krlrvr. How does one make Google calendar disp [...]
  • Yushe » Blog Archive » Conectar SQL Server con MySql: [...] Disclaimer: El árticulo arriba no es mio, es solo una traducción parcial del árticulo aqui [...]
  • Nick: Here is an extensive how to on sharing folders with Windows 7. http://www.ilertech.com/2010/09/shar [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.