Posts Tagged ‘HOWTO

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

Up until this morning, I have been using NuevaSync to act as a conduit between my iPhone and Google accounts. Unfortunately they hit a hiccup this morning, ceasing all sync’ing. In an effort to remedy the situation, I turned off sync’ing for contacts (which deletes all contacts), then turned it back on, only to later [...]

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

Not long ago, I took upon the task of setting up a dedicated virtualization server. I knew I wanted to maximize hardware by keeping the OS slim, so I decided to go with my Linux distro of choice: Ubuntu. This works out very well, because the current version is a Long Term Support release, which means [...]

A T-SQL query to verify the size and growth settings for a SQL Server database without resorting to the Management Studio GUI.


  • shiva ramani: good instruction. How to push data to MySQL from SQL 2005 [...]
  • Winkey: I've created a linked server for mysql successfully, and also can do Insert, Select. But when I try [...]
  • RaghuRam: Thanks a lot buddy it helped me to change the root password when I got the error trying to c [...]
  • Taylor Gerring: If you're on a 64-bit OS, did you run the 32-bit version of ODBC applet? Run: odbcad32 [...]
  • Taylor Gerring: If the issue is the guest sync'ing to the host, can't you just force time sync the host if you can't [...]


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