One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.
Does your company have a Chief Data Officer? Steve Jones doesn't think you need one to use data wisely.
SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.
A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.
Remember when that old DBA told you not to SELECT *? Erik Darling explains why.
Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
Comments posted to this topic are about the item SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers