Technology Musings
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 [...]
In: SQL Server
19 Aug 2008A T-SQL query to verify the size and growth settings for a SQL Server database without resorting to the Management Studio GUI.
Sitting on my couch one night, I noticed that the time on my laptop was about 10 minutes slow compared to every other time source in my house (mobile phone, cable box, etc.)… Since I’m running a domain environment, I knew that most of my OS installations would be syncing to the domain controller, so I [...]
In: SQL Server
15 Aug 2008Ever needed to round an arbitrary DATETIME to some specified increment (i.e. 5, 10 or 15 minutes)? This function can come in handy for such a task.