In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, [...]
Archive for the ‘Business Intelligence’ Category
-
About Pinal Dave
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1200 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia.
-
Blog Stats
- 13,721,468 (13 Million+)
SQLAuthority Links
.
My Homepage
My Resume
My Other Blog
I prefer Idera
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Pages
Categories
- About Me (69)
- Best Practices (98)
- Business Intelligence (27)
- Data Warehousing (39)
- Database (284)
- DBA (130)
- MVP (109)
- Poll (5)
- Readers Contribution (43)
- Readers Question (55)
- Software Development (67)
- SQL Add-On (93)
- SQL Backup and Restore (56)
- SQL BOL (11)
- SQL Coding Standards (21)
- SQL Constraint and Keys (52)
- SQL Cursor (28)
- SQL Data Storage (48)
- SQL DateTime (38)
- SQL Documentation (242)
- SQL Download (243)
- SQL Error Messages (136)
- SQL Function (126)
- SQL Humor (25)
- SQL Index (115)
- SQL Interview Questions and Answers (60)
- SQL Joins (65)
- SQL Optimization (88)
- SQL Performance (249)
- SQL Puzzle (29)
- SQL Security (121)
- SQL Server DBCC (42)
- SQL Server Management Studio (28)
- SQL Stored Procedure (105)
- SQL String (22)
- SQL System Table (54)
- SQL Trigger (24)
- SQL User Group (53)
- SQL Utility (128)
- SQL White Papers (50)
- SQLAuthority (431)
- SQL Training (3)
- SQLAuthority Author Visit (92)
- SQLAuthority Book Review (20)
- SQLAuthority News (397)
- SQLAuthority Website Review (39)
- SQLServer (104)
- Tech (1005)
- Pinal Dave (995)
- SQL Scripts (583)
- Technology (1283)
- SQL (1283)
- SQL Authority (1283)
- SQL Query (1283)
- SQL Server (1283)
- SQL Tips and Tricks (1283)
- T SQL (1283)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - Interview Questions & Answers Needs Your Help
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - 2008 - Download and Install Samples Database AdventureWorks 2005 - Detail Tutorial
- SQL SERVER - 2008 - Interview Questions and Answers - Part 1
- SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
Top 5 Commenters
-
Authors
-
pinaldave
- SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward
- SQLAuthority News – Microsoft SQL Server Protocol Documentation Download
- SQL SERVER – Interview Questions & Answers Needs Your Help
- SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
- SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
- SQL SERVER – Quick Note of Database Mirroring
- SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
- SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You
- SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
- SQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1
-
Archives
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
-
