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
12,264 reads
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
48,107 reads
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,327 reads
SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.
2009-02-09
19,020 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Comments posted to this topic are about the item The Ending Substring
Comments posted to this topic are about the item Done is Better than Good,...
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers