SQL Server Integration Services is part of Microsoft’s business intelligence suite and an ETL (extract, transform, and load) tool. With SSIS Succinctly by Rui Machado, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more. …
Data Mining for the Masses
In Data Mining for the Masses, professor Matt North—a former risk analyst and database developer for eBay.com—uses simple examples, clear explanations and free, powerful, easy-to-use software to teach you the basics of data mining; techniques that can help you answer some of your toughest business questions. …
SQL Server Source Control Basics
For efficient team-based database development, and reliable and repeatable database deployments, going without source control isn’t really optional any more. Quite apart from making it easier to work together, roll back, and share changes, it’s the cornerstone of better change management and continuous integration. SQL Server Source Control Basics provides just the right combination of theory and practical example to get you started quickly. …
MongoDB Succinctly
In MongoDB Succinctly, author Agus Kurniawan explains the essentials of the MongoDB database system. Starting with creating a MongoDB database, you’ll learn how to make collections and interact with their data, how to build a console application to interact with binary and image collection data, and much more. You’ll also learn how to integrate MongoDB into Windows Forms, ASP.NET, and ASP.NET MVC projects. …
45 Database Performance Tips for Developers [PDF]
This free eBook is a collection of SQL Server performance tips and tricks recommended by some of the smartest minds in the Simple Talk community, including SQL Server MVPs. …
Graph Databases
Early release of “Graph Databases”, written by Ian Robinson, Jim Webber, and Emil Eifrém, is available in pdf format for free. It introduces graphs and graph databases to technology enthusiasts, developers, and database architects. …
Free eBook: Introduction to Data Science
“Introduction to Data Science”, a free eBook by Jeffrey Stanton, provides non-technical readers with a gentle introduction to essential concepts and activities of data science. …
SQL Server Concurrency
Free eBook: “SQL Server Concurrency: Locking, Blocking and Row Versioning” by Kalen Delaney. This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking. It is also for those SQL Server professionals who need to know how to troubleshoot and solve blocking and deadlocking problems. …
SQL Server Execution Plans – Second Edition
The latest edition of “SQL Server Execution Plans”, by Grant Fritchey, is available as a free download in pdf format. This second edition is more evolution than revolution. There is also plenty of new content. …
The Art of SQL Server Filestream
“The Art of SQL Server Filestream: A Quick Start Guide for developers and administrators”, by Jacob Sebastian and Sven Aelterman, is available to download in pdf format. It is for SQL Server developers who have to deal with more than relational data. …