Posted by Unknown
On
21/12/12
Book Description
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.
What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.
Provides practical and proven solutions towards creating resilient ETL environments
Clearly answers the tough questions which professionals ask
Goes beyond the tools to a thorough discussion of the underlying techniques
Covers the gamut of data integration, beyond just SSIS
Includes example databases and files to allow readers to test the recipes
What you’ll learn
Import and export to and from CSV files, XML files, and other text-based sources.
Move data between SQL databases, including SQL Server and others such as Oracle Database and MySQL.
Discover and manage metadata held in various database systems.
Remove duplicates and consolidate from multiple sources.
Transform data to meet the needs of target systems.
Profile source data as part of the discovery process.
Log and manage errors and exceptions during an ETL process.
Improve efficiency by detecting and processing only changed data.
Who this book is for
SQL Server 2012 Data Integration Recipes is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment.
Table of Contents
MS Office Data Sources
Flat File Sources
XML Data Sources
SQL Database Sources
SQL Server Sources
Miscellaneous Data Sources
Exporting Data from SQL Server
Metadata
Data Transformation
Data Profiling
Delta Data Management
Change Tracking and Change Data Capture
Optimising Data Import
ET Process Acceleration
Logging and Auditing
Appendix A: Data Types
Appendix B: Sample Databases and ScriptsAbout The Author
Adam Aspin is an ETL expert having 17 years experience with SQL Server and satallite products such as Data Transformation Services and SQL Server Integration Services. For the past decade he has focused especially on ETL projects. He has worked for high-profile clients such as J.P. Morgan, Marks and Spencer, Harrods, Tesco, and more. He has been a frequent contributor to SQLServerCentral.com, and has broad experience across a number of database platforms such as SQL Server, Oracle Database, MySQL, DB2, and others. Adam holds an MA from Oxford University.Product Details
- Paperback: 1056 pages
- Publisher: Apress; 1 edition (November 16, 2012)
- Language: English
- ISBN-10: 1430247916
- ISBN-13: 978-1430247913
- Product Dimensions: 7.5 x 2 x 9.2 inches
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Recipes Apress)
Posted by Unknown
On
21/10/12
Book Description
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
Current: Newly updated for SQL Server 2012
Comprehensive: Covers all common T-SQL problem domains
What you’ll learn
Create databases, tables, and indexes
Query and manipulate data
Store and manage XML inside the database
Move business logic into the database
Resolve common performance problems.
Build reports that matter to your business.
Perform common backup and recovery tasks.
Who this book is for
SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back–end database, and the database administrators who create, manage, and secure those databases.
Table of Contents
Getting Started with SELECT
Elementary Programming
Nulls and Other Pitfalls
Combining Data from Multiple Tables
Grouping and Summarizing
Advanced SELECT Techniques
Query Techniques for Reporting
Inserting, Updating, Deleting
Working with Strings
Working with Dates
Working with Numbers
Transactions, Locking, Blocking, Deadlocking
Managing Tables
Managing Views
Managing Indexes
Managing Large Tables
Stored Procedures
User-Defined Functions
Triggers
Error Handling
Query Performance
Hints
Index Tuning and Statistics
XML
Files, Filegroups, and Integrity
Backup
Recovery
Principals and Users
Securables and Permissions
Objects and DependenciesAbout The Author
Jason Brimhall is first and foremost a family man. He has 15+ yrs experience in IT and has worked with SQL Server starting with SQL Server 6.5. He has worked for both large and small companies in varied industries. He has experience in performance tuning, high transaction environments, large environments, and VLDBs. He is currently a DB Architect and an MCITP for SQL 2008. Jason regularly volunteers for PASS and is the VP of the Las Vegas User Group (SSSOLV). You can read more more from Jason on his blog at: http://jasonbrimhall.info.
David Dye is a Microsoft SQL Server MVP, instructor, and author specializing in relational database management systems, business intelligence systems, reporting solutions, and Microsoft SharePoint. For the past 9 years David's expertise has been focused on Microsoft SQL Server development and administration. His work has earned him recognition as: a Microsoft MVP in 2009 and 2010, a moderator for the Microsoft Developer Network for SQL Server forums, Innovator of the Year runner-up in 2009 by SQL Server Magazine, and in the Training Associates Technical Trainer Spotlight in April 2011. David currently serves as a technical reviewer and co-author with APress Publishing in the SQL Server 2012 series, and as an author with Packt Publishing.
Andy Roberts is a Data Platform Technology Specialist for Microsoft in the Northeast district. Prior to that, Andy spent 12 years as a consultant for Microsoft Consulting Services. As a consultant, Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant, including that of application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and guy-that-knows-a-bunch-of-stuff-about-Microsoft. When not basking behind the glow of his laptop, Andy enjoys volunteering as a ski instructor at Maine Adaptive Sports. He also enjoys golfing, biking, and trying to reverse engineer his three month old son, Max.
Wayne Sheffield started working with databases in the late 1980's, using DBase, Foxbase and FoxPro. With over twenty years in the IT industry, he has worked with SQL Server database systems (starting from version 6.5) since the late 1990's in various development and administration roles, with an emphasis in performance tuning. He is author of several articles at www.sqlservercentral.com, and enjoys sharing his knowledge by presenting at various SQL PASS events and posting on his blog at http://blog.waynesheffield.com/wayne.
Jonathan Gennick is an Apress Assistant Editorial Director with responsibility for database topics. He is line-leader for Apress's Oracle and SQL Server lines. He publishes carefully-chosen database books of a general nature. He maintains a keen interest in books across all lines that touch upon relational databases.
In his last position before changing to an editorial career, Jonathan rose to the rank of Manager at KPMG Consulting (now BearingPoint). There he delivered development and system integration services to state and local government clients. He was noted for his troubleshooting skills and his ability to smoothly navigate the oft-turbulant waters between client management, consultants from competing firms, and client technical personnel. Jonathan has experience with languages and technologies such as Mumps, COBOL, Powerbuilder, various assembly-languages. He is well-known and widely-published for his expertise with Oracle Database and the attendendant languages SQL and PL/SQL. Product Details
- Paperback: 808 pages
- Publisher: Apress; 3 edition (September 19, 2012)
- Language: English
- ISBN-10: 1430242000
- ISBN-13: 978-1430242000
- Product Dimensions: 7.5 x 1.6 x 9.2 inches
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Recipes Apress)
.jpg)
.jpg)
.png)
.jpg)
