Books

Technical Article

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

Technical Article

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

46,078 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.

You rated this post out of 5. Change rating

2009-02-10

5,295 reads

Blogs

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023

By

I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs

Forums

Convert common Separated number to # table

By ralahari

@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...

Things to be considered before implementing database auditing

By vsamantha35

Hi All, As part of security compliance, we are told to audit DML &...

The Need for DevSecOps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Need for DevSecOps

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers