SQL Server

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 3rd Edition

The #1 Easy, Common-Sense Guide to SQL Queries Updated for Today’s Databases, Standards, and Challenges. SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques.

Microsoft SQL Server 2012 Performance Tuning Cookbook

As a DBA you must have encountered a slow running application on SQL Server, but there are various factors that could be affecting the performance. If you find yourself in this situation, don’t wait, pick up this book and start working towards improving performance of your SQL Server 2012. SQL Server 2012 Performance Tuning Cookbook is divided into three major parts Performance Monitoring, Performance Tuning, and Performance Management that are mandatory to deal with performance in any capacity.

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.

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook, 3rd Edition

Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS. Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions. Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples

Beginning T-SQL 2008

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible. You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data.

Whats New in SQL Server 2012

Unleash the new features of SQL Server 2012

SQL Server Integration Services Design Patterns 2nd ed. 2014 Edition

SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face.

Professional Microsoft SQL Server 2014 Integration Services 1st Edition

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change.

Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014 1st Edition

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly.

Microsoft SQL Server 2014 Business Intelligence Development Beginners Guide

Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools.

Murach's SQL Server 2016 for Developers

If you're an application developer, or you're training to be one, this 2016 edition of Murach's classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you'll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature.

Pro SQL Server Always On Availability Groups 1st ed. Edition

This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database administrators to implement and manage high availability and disaster recovery solutions far more easily than by implementing the log-shipping and database-mirroring solutions of the past.

 

1 2 3 4 5 Last