Creating a Comma-Separated List (SQL Spackle)
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
Express a Number or Currency in Words with T-SQL Code
This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.
Simple Talks podcast episode 2: Coffee chat with Huxley Kendell
Host Louis Davidson meets with Solutions Engineer Huxley Kendell, to chat about his experience in working in the tech industry. Listen in to this episode for discussions including LLMs and AI, Coding and Career paths, all the way to Dungeons and Dragons.
Choosing a File Format - Data Engineering with Fabric
In this next article, learn about the different file formats and which work well inside your Microsoft Fabric Lakehouse.
Relationally Divided over EAV
A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. It covered some items to check at the hardware level and configuration items, but this section gets into more detailed hardware auditing details.
The full agenda for the Redgate Summit New York is live!
The full agenda for the Redgate Summit New York is live! Join us to stay ahead of the curve and gain valuable insights from industry experts like Bob Ward (Microsoft), Mri Pandit (Navy Federal Credit Union), Erik Darling (Darling Data), Steve Jones (Redgate Software), and many more.
Git, GitHub and Visual Studio Code for SQL Server
Learn how to get started with Git and Visual Studio Code.
MTTD
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers