This guide contains a wealth of solutions to problems that SQl Server programmers face. The recipes in the book range from those that show how to perform simple tasks to ones that are more complicated.
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data.
This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks.
But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features.
Over 100 expert recipes to design, create, and deploy SSIS packages with this book and ebook.
Without Transact-SQL, there is nothing.
This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks.
Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease About This Book Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services Program and extend ...
Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.
If so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face.