eBooks

ImageNamesort iconPriceAdd to cart
Reluctant DBAThe Reluctant DBA: SQL Server Basics

More and more companies are asking their IT pros and developers to manage their SQL Server systems instead of having a dedicated DBA on staff. However, most of these “reluctant DBAs” have little to no experience with relational database administration and are looking for quick answers to their questions on SQL Server basics. Here’s a compilation of SQL Server Magazine articles that provide reluctant DBAs with information about how to get started with the fundamentals of administering a SQL Server database including lots of basic T-SQL, plus basics on storage, performance tuning, security, and backup and recovery.

$19.95
The New Era of VirtualizationThe New Era of Virtualization

The attraction of virtualization was the same then as it is now: to save money. Computers were expensive to build, and virtualization promised to reduce the number of computers needed. Even the earliest computers spent a lot of time sitting around waiting for work. Virtualization was a way to let multiple projects share a single computer while keeping them fully isolated, improving utilization and lowering total cost of ownership.

$4.95
T-SQL BlackbeltT-SQL Blackbelt

A collection of 21 articles from SQL Server Pro and written by Itzik Ben-Gan that demonstrate practical, advanced tips for using T-SQL. Also included are 18 logic puzzles that Itzik included in many of his articles. SQL querying problems often require you to deal with logical challenges. Sometimes the logical parts are more difficult to figure out than the technical, SQL-specific, parts. If you’re looking for ways to improve your logic skills, one of the things you can do is to try and solve pure logic puzzles.

$19.95
TSQL 101T-SQL 101: A Quick-Start Guide to T-SQL Basics

T-SQL is the query language used by SQL Server and other database products, so knowing how to write T-SQL queries is an important skill for anyone who works with SQL Server databases. The 10 lessons in the T-SQL 101 series can help you learn the basics, such as how to write queries that retrieve, add, update, and delete records in tables and how to group and aggregate data that you retrieved with queries so that you can produce informative reports. By the end of the series, you’ll even be able to create tables, views, and custom stored procedures.

$19.95
SQL Server 2012 First LookSQL Server 2012 First Look

SQL Server 2012 has proved to be an exciting release on several fronts. In Chapter 1, Richard Waymire provides an overview of SQL Server 2012’s new features and packaging options. He tells you about the system requirements, upgrade process, and some changes in the setup program. In two sidebars to the chapter, you’ll learn about SQL Server 2012 editions and SQL Server 2012 high availability.

$19.95
PowerShell 101: A Quick-Start Guide to PowerShellPowerShell 101: A Quick-Start Guide to PowerShell

The word "scripting" probably makes a lot of IT admins cringe, but it's not that scary or difficult to learn. Windows PowerShell is one of the newest scripting languages, and it has a lot of features that IT admins will appreciate. For example, like spelling in the English language, the naming conventions in many scripting languages are inconsistent. PowerShell avoids such inconsistencies, making it much easier to learn and use.

$19.95
Pocket Guide to Data Warehousing

BI expert and SQL Server Magazine author Michelle Poolet covers a myriad of topics in this downloadable guide. You’ll learn about the characteristics and benefits of implementing a star schema in your organization. Plus, you’ll discover the differences between dimensional and entity relationship data warehouse models, and how to design and use essential data warehouse components, including fact tables and dimensions. More advanced topics are covered as well, including dimensions (e.g., slowly changing, rapidly changing, junk, degenerate), the benefits of using dimensional role-playing in a star schema, and how to horizontally partition a fact table. You’ll also uncover how to determine which type of data warehouse you have and which workloads it uses.

$19.95
Pocket Guide to Business Intelligence

The latest eBook from the editors at SQL Server Magazine. Our BI experts share solutions to common problems that you’ll encounter using SQL Server’s BI features. You’ll learn how to create better reports, dimensions, and data repositories, plus discover new ways to leverage Microsoft Office SharePoint Server 2007 and Microsoft Excel in your BI strategy. Our experts will also help you uncover how to get the most out of features like Reporting Services, SSRS and MOSS, and SSAS.

$19.95
Mel Beckman's Virtualization Decision Support GuideMel Beckman's Virtualization Decision Support Guide

Virtualization technologies come in several varieties, the three most popular being server, storage, and user interface. Each offers many options, and choosing the right options for your application is critical to achieving project success. This first article in our Virtualization Decision Support guide leads you through the landscape of server virtualization features and capabilities, pointing out a few pitfalls along the way.

$9.95
Greg Shields on VirtualizationGreg Shields on Virtualization

No matter how long you may have been using VMware vSphere—VMware’s cloud computing virtualization operating system—questions undoubtedly still arise. You might find the answer you’re looking for in this collection of FAQs by Greg Shields.

$4.95
Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×