books

SQLServerCentral Article

Protecting SQL Server Data

  • Article

This book holds the key to "encryption without fear". In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned and implemented, they are an essential tool in the DBA's fight to safeguard sensitive data.

2017-11-07

2,971 reads

SQLServerCentral Article

SQL Server Tacklebox

  • Article

Inside the SQL Server Tacklebox you'll find day-to-day tools and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster.

2017-11-03

7,185 reads

SQLServerCentral Article

Performance Tuning with SQL Server Dynamic Management Views

  • Article

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements.

5 (4)

You rated this post out of 5. Change rating

2017-11-02

9,880 reads

SQLServerCentral Article

Inside the SQL Server Query Optimizer

  • Article

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

4.67 (3)

You rated this post out of 5. Change rating

2017-02-06

27,052 reads

SQLServerCentral Article

SQL Server Execution Plans, Second Edition by Grant Fritchey

  • Article

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

3.55 (20)

You rated this post out of 5. Change rating

2017-02-02

18,706 reads

SQLServerCentral Article

Troubleshooting SQL Server: A Guide for the Accidental DBA

  • Article

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

4.6 (5)

You rated this post out of 5. Change rating

2014-11-11

25,307 reads

SQLServerCentral Article

Confessions of an IT Manager, 2nd Edition - Book

  • Article

The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry.

2013-10-01

2,601 reads

SQLServerCentral Article

The Fundamentals of SQL Server Replication by Sebastian Meine

  • Article

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.

2 (7)

You rated this post out of 5. Change rating

2013-09-30

6,492 reads

Blogs

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

First Time Speaking with a Mask at an Event

By

Over the past couple of months, I have started losing my ability to talk...

A New Word: Apolytus

By

apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Read the latest Blogs

Forums

Unlocking Power with Updatable Views in SQL Server

By Almighty

Comments posted to this topic are about the item Unlocking Power with Updatable Views...

Seagull Management

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Seagull Management

Using Table Hints in a Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using Table Hints in a...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers