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.
Use Powershell to query AD for Users, Groups and GroupMembers
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.
Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I