Configuring OpenVPN Adapters

 Windows  1 Response »
Aug 262008
 

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:
Continue reading »

 Posted by at 10:16 am  Tagged with: ,

Checking database file sizes without a GUI

 SQL Server  No Responses »
Aug 192008
 

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.
Continue reading »

 Posted by at 3:38 pm  Tagged with: , ,

Synchronize a Virtualized Domain Controller with External Time Servers

 Active Directory, VirtualBox, Windows  4 Responses »
Aug 192008
 

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:
Continue reading »

 Posted by at 10:12 am  Tagged with: , ,

Round DATETIME to nearest X minute increment

 SQL Server  2 Responses »
Aug 152008
 

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.
Continue reading »

 Posted by at 3:07 pm  Tagged with: , , ,

Query Active Directory from SQL Server 2005

 Active Directory, SQL Server  1 Response »
Aug 152008
 

Some time ago, I needed to sync down a list of AD users to use as a lookup (as opposed to querying LDAP on demand). I found this little gem: How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code. It works great, especially since I submitted a bug fix.

In any case, the process is very simple:
Continue reading »

 Posted by at 1:50 pm  Tagged with: ,
Page 9 of 9« First...56789
© 2012 Idea Excursion Suffusion theme by Sayontan Sinha