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...]
Quest Named to the SD Times 100 List
August 4, 2011 by Leave a Comment
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...]
Managing Complex DB Environments
August 3, 2011 by Leave a Comment
Check out the new white paper “Key Methods for Managing Complex DB Environments” at Quest.com. Heterogeneous database management hassles used to be much less common than today. When I first started at Quest nearly ten years ago, I'd put forward that on 15-20% of my big customers regularly managed more than one major database platform. (That doesn't mean they didn't have more than one, rather secondary platforms were either unmanaged or considered entirely unimportant). Today, I'd put forward that 70-80% of my big customers support at least two major database platforms. Often, they support … [Read more...]
Wednesday Quest: Plenty O’Betas and Product Releases
June 29, 2011 by Leave a Comment
Spotlight on SQL Server That's right! An all new version 8.0 of Spotlight on SQL Server Enterprise is now GA and updated trials are live on the website. Some cool stuff therein: • Support for SQL Server 2011 (Denali) - Spotlight can now be used to monitor SQL Server 2011 databases (Denali CTP1 and CTP2 releases). • Project Lucy integration - Use Project Lucy to analyze the performance of your database and compare your experience with everyone else who uses the service. • VMware memory diagnostics - Analyze virtual memory using charts similar to that used to analyze virtual CPU. We also … [Read more...]
New Releases in the Toad Family of Tools
June 8, 2011 by Leave a Comment
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...]
