Books

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

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

13,995 reads

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

SQL Server Crib Sheet Compendium

As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.

2009-02-10

10,193 reads

SQL Server Execution Plans

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.

2009-02-10

45,493 reads

The Art of XSD eBook Download

SQL Server XML Schemas

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.

2009-02-10

5,229 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Use Domain Account for SQL Server service on Linux

By S_DBA

Currently, while installing SQL server we use a local linux account to run the...

Reversing a String in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reversing a String in Python

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers