Data Strategy Checklist for 2025
The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.
2024-12-20 (first published: 2024-12-16)
413 reads
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...
2024-12-14
49 reads
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...
2024-12-27 (first published: 2024-12-13)
483 reads
A New Word: Dolonia
dolonia – n. a state of unease prompted by people who seem to like you too much, which makes you wonder if they must have you confused with someone...
2024-12-13
105 reads
Cloudbrew 2024 – Slides
You can find the slides for the session Building the €100 data warehouse with the Azure Data Platform in this GitHub repo.
The post Cloudbrew 2024 – Slides first appeared...
2024-12-13
33 reads
Ways to land data into Fabric OneLake
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as its central data storage hub for all Fabric-integrated products. A variety of tools and methods...
2024-12-18 (first published: 2024-12-12)
672 reads
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...
2024-12-25 (first published: 2024-12-11)
1,115 reads
AI Helping with an API
Can an AI help me with some database API work? Let’s see. This is part of a series of experiments with AI systems. The Scenario One of the things...
2024-12-11
139 reads
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....
2024-12-23 (first published: 2024-12-11)
681 reads
T-SQL Tuesday #181: A Technology Present
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve gotten to #181. That’s over 15 years of monthly blog parties. This month we have...
2024-12-10
47 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers