Idea Excursion
Technology Musings
Running multiple X11 sessions
In: Linux
24 Dec 2008Got a misbehaving application preventing logout or maybe there’s a game that demands then entirety of your screen? There’s a couple of different ways to start a second X11 instance, both of which are very easy to use. One requires just a few keystrokes, and the other allows you to embed one session within your existing.
Read the rest of this entry »
- No Comments
- Tags: HOWTO, Linux, Ubuntu, X11
VirtualBox 2.1 new features
In: Linux|Mac|VirtualBox|Windows
17 Dec 2008Today, Sun released VirtualBox 2.1, and it seems that the new features really pack a punch. I wanted to share those new features and my thoughts on each.
First, the summarized new features according to the Changelog, with my personal favorites with emphasis:
Read the rest of this entry »
- (3) Comments
- Tags: Review, Software, VirtualBox
Unsigned integer data types
In: SQL Server
4 Dec 2008I’m sure there are more posts like these to come, but I just wanted to get this out there. It’s been a small annoyance of mine that carried over from my MySQL days, but why aren’t there unsigned numerics in SQL Server?
Why do I have to waste a whole bit on the sign in IDENTITY columns, possibly causing me to choose a larger data type, doubling my storage requirements for that column from 4-byte INT to 8-byte BIGINT?
Can we get by with what we have now? Absolutely
Are there workarounds to emulate the behavior? Sorta
Would this be terribly difficult to implement? Doubtful
So whadyasay? Can we have native data type support for unsigned integers?
- No Comments
- Tags: Analysis, Database, MySQL, SQL Server
Set FTP password in SSIS
In: SQL Server|SSIS
24 Nov 2008Undoubtedly, you’re reading this because you’ve discovered that SQL Server Integration Services (as of SSIS 2008) will not allow you to set the password of an FTP connection through expressions. Fortunately, there is an easy workaround, that requires a simple Script Task. While not as simple as native expression support, it’s darn close. I’ve included C# code, but you may need to adapt to VB.Net if that’s your preferred flavor.
Read the rest of this entry »
- No Comments
- Tags: C#, FTP, HOWTO, SQL Server 2008, SSIS
Handling Embedded Text Qualifiers
In: SQL Server|SSIS
12 Nov 2008It seems that SSIS can’t handle embedded text qualifiers when importing from a flat file. What is an embedded text qualifier? Let’s say you have a CSV file with a few fields. To thwart problems with commas inside your text fields causing confusion with your column delimiters, you implement a text qualifiers – typically double quotes. It makes a row look something like this:
"12036","Company Name, Inc.","555-555-1234","3.14159"
That’s fine, but what happens when the field also contains quotes, such as this:
"52665","Best "Kept" Secret Storage Facility","555-555-9876","2.71828"
- (12) Comments
- Tags: C#, HOWTO, SQL Server, SSIS
Categories
- Google (6)
- Gmail (1)
- Hardware (1)
- Internet (3)
- iPhone (6)
- Linux (12)
- Mac (3)
- Microsoft (39)
- Dynamics AX (1)
- Windows (36)
- Active Directory (2)
- SQL Server (25)
- SSIS (6)
- VirtualBox (13)
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Windows 7 in VirtualBox: Shared Folders workaround
- Connecting to Oracle from SQL Server
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Efficiently query the DATE in DATETIME
- All About Linux Swap Part 2: Management
- All About Linux Swap Part 3: Analysis
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- 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
- Ubuntu VirtualBox Server Redux
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Create Email Forwarders in Google Apps
- Import Excel 2007 with SQL Server Import and Export Wizard
- Firefox 3.6 Beta 3 now available
- Microsoft Office 2010 Beta posted on MSDN/TechNet
- Accessing Custom .NET Assemblies in SSIS 2008 Script Tasks
- 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 [...]