Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.
With an emphasis upon performance but also branching into release management, auditing, and other issues the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system
Goes beyond the manual to cover good techniques and best practices
Delivers knowledge usually gained only by hard experience
Focuses upon performance, scalability, reliability
Helps achieve the predictability needed to be in control at all times
Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators and developers who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. Download eBook Free »
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools 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: Solutions for Integration Services and Other ETL Tools 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: Solutions for Integration Services and Other ETL Tools is the one book that will meet your needs. Download eBook Free »
SQL Server 2012 Integration Services Design Patterns
SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.
SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You’ll learn more about SSIS as a result, and you’ll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.
SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It’s for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It’s an excellent choice for business intelligence and data warehouse developers. Download eBook Free »
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach 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.
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach 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. Download eBook Free »
Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments.
Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft’s SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need.
Pro SQL Server 2012 BI Solutions is aimed at database administrators, SQL programmers, and report developers who create business intelligence solutions for midsized businesses and departments. Pro SQL Server 2012 BI Solutions shows how to use Microsoft SQL Server and related products to deliver cost-effective and practical business intelligence solutions. Download eBook Free »
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft’s enterprise level reporting platform. It is included with many editions of SQL Server, and is something you’ll want to take advantage of if you’re running SQL Server as your database engine.
Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft’s enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you’ll want to take advantage of if you’re running SQL Server as your database engine. Download eBook Free »