Books

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,847 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,876 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,477 reads

Technical Article

Brad's Sure Guide to SQL Server 2008

SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists…in this book I focus on what I thought were the ten most important new features for Production DBAs.

2009-02-10

14,492 reads

Technical Article

How to Become an Exceptional DBA

Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.

2009-02-10

6,471 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

parameterizing a sql server connection

By winston Smith

I am parameterizing an sql server connection. There are the following fields: username password...

'DATE' is not a recognized built-in function name

By yrstruly

Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...

SSIS Sort Alphanumeric?

By John524

Hello, I'm pretty new to SSIS, but I have an Excel source that I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers