SQL Server

SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle

Learn Essential SQL and Database Skills Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. Step-by-Step in Plain English This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data …

Learn more

Microsoft SQL Server 2008 R2 Unleashed

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more.   Four expert SQL Server administrators, developers, and consultants have packed this book …

Learn more

MS SQL, T-SQL, and SQL Server Interview Questions: Hundreds of Questions, Responses, and Explanations

This book contains typical interview questions that you might encounter while interviewing for a SQL Developer. It is geared towards a Microsoft environment, that is, employment positions that use Microsoft SQL, Microsoft SQL Server, and Microsoft T-SQL, although the SQL portion is applicable towards any Relational Data Base (RDB) that uses ANSI SQL. This isn’t every conceivable question …

Learn more

Microsoft SQL Server 2014 Query Tuning & Optimization

Optimize Microsoft SQL Server 2014 queries and applications Microsoft SQL Server 2014 Query Tuning & Optimization is filled with ready-to-use techniques for creating high-performance queries and applications. The book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution …

Learn more

Professional Microsoft SQL Server 2012 Administration

An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of …

Learn more

Beginning Microsoft SQL Server 2012 Programming

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply …

Learn more

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and …

Learn more

T-SQL Querying (Developer Reference)

T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the …

Learn more

Recommended