There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]
Today Steve asks which data model issues are most annoying to you.
In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
How can we get familiar with Azure Databricks with Spark Dataframes?
Learn how to emulate Azure storage for files, blogs, and queues.
Let’s get a little nerdy and look at database internals.
Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
I’m giving two online sessions soon on virtual events that are free to attend....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Comments posted to this topic are about the item Tables with a SPARSE Column...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers