Data Debt
The idea of data debt seems both silly and obvious to Steve. We all have too much data and it's out of control.
2025-01-31
139 reads
data
Building a Culture of Data: The Technical Aspects
In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While the lion’s share of the work will be getting people to work together and embrace ever deeper use of data, as a reader of Simple-Talk, a lot of this transition will be technical.
2024-05-15
Being Responsible for Data
There is an interesting court case on who is responsible for the data being posted on the Internet. Steve has a few thoughts today.
2023-03-29
268 reads
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
2022-04-29
129 reads
Do You Have ALL the YAML?
There are lots of data exchange formats, and one of them that has become popular is YAML. However, are you sure you have the entire file?
2021-07-26
1,339 reads
The Next Data Decade
There are lots of predictions that people make at the start of every year. I've written quite a few over the years, but in 2020 I decided not to make any. After all, there are plenty of other people making them. One person that did make some was Jeff Clarke, COO of Dell. He wrote […]
2020-04-22
129 reads
2019-12-18
251 reads
2019-11-26
370 reads
Fragmented or Centralized Data
Is it better to copy and distribute data or centralize it? Steve has a few thoughts today.
2019-10-15
242 reads
Data Challenges and Travel
A few problems in travel have Steve thinking about the complexities and challenges of companies that coordinate lots of data.
2019-07-23
264 reads
Blogs
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
Free Cloud Environment Setup: A Beginner’s Guide
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers