Archive for August, 2008
Configuring OpenVPN Adapters
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 [...]
- (1) Comment
- Tags: HOWTO, Software
HOWTO: Ubuntu VirtualBox Server
In: Linux|VirtualBox
24 Aug 2008Not 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 [...]
- (1) Comment
- Tags: HOWTO, Linux, Software, Ubuntu, VirtualBox
Checking database file sizes without a GUI
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.
- No Comments
- Tags: HOWTO, SQL Server, SSMS
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 [...]
- (3) Comments
- Tags: HOWTO, Software, VirtualBox
Round DATETIME to nearest X minute increment
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.
- (2) Comments
- Tags: DATETIME, HOWTO, SQL Server, T-SQL
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Connecting to Oracle from SQL Server
- Windows 7 in VirtualBox: Shared Folders workaround
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Connect to MySQL in SSIS
- Efficiently query the DATE in DATETIME
- Stop SOPA
- Access system date in SSIS without a Script Task
- Connecting to Oracle with SSIS 2008
- Set Permissions Across SQL Server Database Instances
- SQL Server Principals & Roles Permission Audit
- New Office Outlook 2010 Data File Menu Item
- Why RAM Matters Less with OS X Lion
- Cache multiple values in a Map Container for fast in-memory lookup
- Ubuntu VirtualBox Server Redux Addendum
- Default column value to identity of different column
- KALImaR:Im having the same 11.10 problem with this irritating disaster...Solutions please [...]
- Balkan:Hi All, I have similar problem as Dwarakesh, I set the automatic login on, and after that my passwo [...]
- Creating an automated database backup by means of SQL Server Agent Job « Placko's SQL KB:[...] Configuring SQL Server Agent Operators by Taylor Gerring [...] [...]
- Dwarakesh:yeah even I'm getting the same error on my sony e series laptop!!!! I am currently running ubuntu 1 [...]
- Phil:Thanks - this article was a great help. [...]
