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...]
Simplifying CSV Data Loads
Filed Under: Administration, Cool Technologies, Databases, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Data Cleansing, Data Quality, DBA, ETL, Master Data Management, SQL Server 2008
Video: Worth the Wait Why SQL Server 2008 is Great
Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable. Originally Posted on YoutTube November 12, 2008. Follow me on Twitter! … [Read more...]
Filed Under: Administration, Databases, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, Quest Software, SQL Server 2008
Join O’Reilly on Facebook
O'Reilly Media on Facebook is a place for for anyone who is a fan of O'Reilly, whether you've been following their books, conferences, webcasts, and more since the very beginning or you recently jumped onto the bandwagon. I really enjoy the newsletters and blogs from O'Reilly's various channels, especially Tim O'Reilly's commentary. And, of course, there's my book - SQL in a Nutshell - published by O'Reilly for your consideration. This book provides a complete reference of the latest release of the ANSI SQL standard, as well as full coverage of support for the ANSI standard from the … [Read more...]
Filed Under: On-Line Resources, SQLServerPedia Syndication Tagged With: ANSI SQL, DBA, Developer, MySQL, Oracle, PostgreSQL, SQL Server 2008, Transact-SQL Programming
