Books

The Redgate Guide to SQL Server Team-Based Development eBook Download

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,732 reads

Performance Tuning With Dynamic Management Views eBook Download

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,453 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,766 reads

SQL Server Tacklebox eBook Download

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,806 reads

Confessions of an IT Manager eBook 2nd Edition Donload

Confessions of an IT Manager, 2nd Edition

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.

2009-05-07

2,424 reads

Blogs

#DPS10 – preconfs

By

I have delivered a preconf on the biggest conference in Asia. The preconf was...

A Memory-Optimized Roundup – T-SQL Tuesday #117

By

The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...

How do you debug your spark-dotnet app in visual studio?

By

When you run an application using spark-dotnet, to launch the application you need to...

Read the latest Blogs

Forums

Export to CSV

By Jenny77

Hi,   i am trying to export a table into csv, and it should...

CHECKDB

By VastSQL

My user database drive have about 100GB free space now and the database is...

Sql 2014 sp3 - extra stats created

By sqlguy7777

Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers