DataOnWheels

Blog Post

SQL Saturday Atlanta BI Recap

https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the year. This year was especially sweet to see a lot of the SML (Saturday Morning...

2025-03-10

6 reads

Blog Post

Dynamically Unpivot columns in SQL

Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...

2024-05-27 (first published: )

569 reads

Blogs

Comparing My Current Schema with a Backup with SQL Compare

By

A customer asked if they needed to restore a database from backup to compare...

Improving Our Conversations

By

If we aren't having the same conversation, we aren't going to be heard. That's...

How Do You Pick Events in Extended Events?

By

A while back I wrote about using AI to explore why people are not...

Read the latest Blogs

Forums

create a table with data capture for next 3 years

By anug

Hello, I would like to build a table capturing data starting from 1st day...

Is GenAI Coming Faster Than You Think?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is GenAI Coming Faster Than...

Local Storage Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Local Storage Options

Visit the forum

Question of the Day

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

See possible answers