How to Find Where Your Databases Reside In The File System

How to Find Where Your Databases Reside In The File System

SQL Script:

Copy

/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.

It is dynamic...

Playing with the Data API Builder

I published an article today on the Data API Builder, which is a way of presenting your database tables as a REST or GraphQL API for developers. You can...

A Very Cool Benefit in SSMS 21

I saw a post from Erin that Preview 2 is available. I’d gotten a message when I started SSMS v21 this morning, but got distracted. I made a short...

Free SQL Training: Dive into Databases This December!

Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...

Creating a “Real” Copy of a View: #SQLNewBlogger

I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....

Microsoft Fabric Training and Tutorials

Microsoft Fabric is the new data offering in Microsoft Azure and there is a great deal of interest in it. How do you get started? Where are the tutorials?

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...

Data Strategy Checklist for 2025

The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.

Grinding Away: Brent Ozar

Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...

My 2024 in Data: Music

This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...