Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database. When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software. I recently visited www.csvexpress.com to check out just how simple it could get. In short, CSVexpress offers a repeatable and quick way to load any CSV file into SQL Server (or any other database). For those whose data quality is not as pristine as it should be, CSVexpress also offers … [Read more...]
Blogger, Have You Heard of Microsoft Broadcaster?
Introducing the Microsoft Broadcaster: A self-service technical content repository that provides you with rich content for your blogs/sites. On behalf of Microsoft, I would like to invite you to dive into Microsoft Broadcaster. It's a site that unleashes a torrent of free technical content like Videos, Webcasts, Whitepapers, eLearning, and more, which you can use in your blogs or user group site to drive deeper engagement with your audience and community. Key Features of Microsoft Broadcaster include: Download and embed content on your sites without sending traffic away … [Read more...]
Quest Named to the SD Times 100 List
My employer, Quest Software, was once again named to the SD Times 100 list, this year in the “database and integration” category! The program recognizes the top leaders and innovators, looking back at each company’s achievements from the year before. Out unwavering market leadership was also reinforced in 2010 with IDC ranking Quest as “the top independent database management and development tools vendor serving distributed and other non-mainframe systems”· Other innovations contributed to our win, such: Ongoing innovation within the Toad product family, including the introduction of … [Read more...]
Is There Such a Thing as Easy ETL?
E.T.L. That's Extract - Transform - Load. That doesn't sound like a lot of work when all you need to get loaded is a simple Access database or an Excel spreadsheet. In a situation like that, the process is so simple, all you really need to focus on is the L in ETL. There's not a whole lot of E.T. to process, despite how wonderful that movie is. [pun intended] But as soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. The other cross-thread that had really caught my interest lately is the USA federal … [Read more...]
New Releases in the Toad Family of Tools
Toad Extension for Visual Studio 1.2 is now live. You can access it HERE. Key new features in Toad Extension for Visual Studio v1.2: Deployment Scripts: the pre- and post-deployment scripts of TFS are now supported. XML Columns: supports tables with XML data type columns. Nested Tables: supports tables with up to two levels of nested table type columns. Synonyms: synonyms can now be imported into your DB project Source Navigation: You can now use F12 navigation to find the definition of items in the code editor. Stored Procedures: generate Oracle stored procedures that … [Read more...]