Reading Through the Logs
The problems at TSB Bank in the UK have Steve worried about his own records.
SQL Server From .Net: Connecting Visual Studio Community Edition
This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.
Provisioning SQL Server Instances with Docker
With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.
The Technology Journey to Disaster
Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.
Parking Garages And Predicates
You lost your car in a big parking lot. Erik Darling explains how this is just like an index scan.
Navigating Hadoop Resources
Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
“But I don’t need to back up that database.”
Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.
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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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