SQL Server From .Net: Making A Connection
A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.
Using T-SQL to Detect Stock Price Reversals with the RSI
Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.
SSIS Design Pattern - Staging Fixed Width Flat Files
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?
Considering Other Views
When we build software, are we empathetic to how others (literally) view our software?
Monitor Query Performance Using Query Store in SQL Server
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security
In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.
Software Testing Skills Must Shift with AI
Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.
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