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 greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers