NewsDemon Banner

Configuring OpenVPN Adapters

In: Windows

26 Aug 2008

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 was displayed in the Network Connections Control Panel.

After some digging, it seems the easiest solution, is to remove the virtual adapter, re-configure the .inf file, then re-add the adapter. So let’s get started:
Read the rest of this entry »

HOWTO: Ubuntu VirtualBox Server

In: Linux|VirtualBox

24 Aug 2008

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 I’ll have access to security patches for a full 5 years. As for the actual virtualization software? There are multiple choices for Linux, but I really liked several aspects of VirtualBox: cross-platform support, the VRDP feature, and I had already been running it in a headless configuration on Windows. For your enjoyment, I documented the entire procedure. So here goes:
Read the rest of this entry »

Checking database file sizes without a GUI

In: SQL Server

19 Aug 2008

Here’s a quick little statement you can use to verify the size and growth settings for a SQL Server database. It doesn’t spell everything out for you, but if you’re aware of some common conventions (-1 = unlimited, 0 = no growth), it’s a fast and easy way to verify settings before issuing your ALTER DATABASE command. The filename is commented out by default, but provided just-in-case.
Read the rest of this entry »

Synchronize a Virtualized Domain Controller with External Time Servers

In: Active Directory|VirtualBox|Windows

19 Aug 2008

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 was a bit baffled by the prospect that things were not syncing. After a quick RDC to my PDC, I noticed that it was the culprit of the slowed time. First, a quick Google on how to synchronize with an external time source. With that figured out, time to pick out a reliable time source. Now let’s run it:
Read the rest of this entry »

Round DATETIME to nearest X minute increment

In: SQL Server

15 Aug 2008

Ever 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.
Read the rest of this entry »

Page 13 of 14« First...1011121314

Categories

Archives

  • 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.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.