Books

Troubleshooting SQL Server A Guide for the Accidental DBA eBook cover

Troubleshooting SQL Server: A Guide for the Accidental DBA

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".

2011-09-29

22,883 reads

SQL Server Team-Based Development eBook cover

The Red Gate Guide to SQL Server Team-based Development

This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.

2010-10-21

4,784 reads

Performance Tuning with SQL Server Dynamic Managment Views eBook cover

Performance Tuning with SQL Server Dynamic Management Views

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.

2010-06-14

8,570 reads

Protecting SQL Server Data eBook Download

Protecting SQL Server Data

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.

2009-09-03

2,807 reads

SQL Server Tacklebox eBook cover

SQL Server Tacklebox

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.

2009-07-14

6,853 reads

Blogs

Speaking at Data ANZ 2021

By

Looking forward to speaking at Data ANZ 2021 this weekend. Data ANZ "is the data...

Daily Coping 24 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

DDL Trigger to log database level security commands.

By

In my last post I talked about reasons why your permissions might go missing....

Read the latest Blogs

Forums

The Debug Parameter

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Debug Parameter

value for the max date group by id

By rohitkocharda

Hi everyone, I have data in my table as below date       ...

Cannot log in to new SQL server

By jcuello81

Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers