books

SQLServerCentral Article

Brad's Sure Guide to SQL Server 2008

  • Article

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.

2013-04-11

14,314 reads

SQLServerCentral Article

SQL Server Crib Sheet Compendium

  • Article

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.

2022-04-27 (first published: )

11,023 reads

SQLServerCentral Article

SQL Server Stumpers, Vol.5

  • Article

Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.

You rated this post out of 5. Change rating

2013-03-15

3,523 reads

SQLServerCentral Article

SQL Server Hardware

  • Article

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.

4.29 (7)

You rated this post out of 5. Change rating

2013-03-15

15,144 reads

SQLServerCentral Article

SQL Server Execution Plans

  • Article

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.

2013-03-15

50,814 reads

SQLServerCentral Article

SQL Server XML Schemas

  • Article

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.

You rated this post out of 5. Change rating

2013-03-15

5,406 reads

Blogs

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

By

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

Read the latest Blogs

Forums

Technological Dinosaurs or Social Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?

DBCC CHECKIDENT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKIDENT

Distributed Availability Group Health: T-SQL and Zabbix

By Pablo Echeverria

Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...

Visit the forum

Question of the Day

DBCC CHECKIDENT

What is returned as a result set when I run this command without a new seed value?

See possible answers