T-SQL Enhancements: OVER clause
With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of...
2011-08-16
1,459 reads
Blog Posts
You Are Allowed to Care About Whatever You Want
I wanted to write this because its often overlooked. I care about things that may not interest you, things that...
2011-08-16
575 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,484 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,398 reads
ColoradoSQL in August
All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...
2011-08-15
586 reads
Don't Wait to Start Blogging
I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...
2011-08-15
2,254 reads
I am a Big Bro
The first time I did any volunteering work for PASS was last year at the Summit. I enjoyed doing it....
2011-08-15
1,667 reads
MCM Training – Day 6 & 7
My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...
2011-08-15
547 reads
Micromanaging
Micromanaging is one of those words that evokes an instant negative image. Certainly there are times when it happens, but...
2011-08-15
632 reads
Notes from SQLSaturday #79
This was the third SQLSaturday in South Florida and the third time I’ve attended, just too good an event to...
2011-08-15
733 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
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