What is 268435456?
What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for...
2014-06-27
1,325 reads
Mile High Tech Con
There’s a brand new business intelligence conference launching next month in Denver, Colorado. The Mile High Tech Con is a...
2014-06-27
1,244 reads
What is an “operational” DBA?
On Facebook last night, I posted the following:
An operational DBA isn’t just a manager of a traditional RDBMS, transactional system....
2014-06-27
5,288 reads
Friday Followup For June 27, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-27
883 reads
SQL Saturday #316, MVP’s, MCMs and a baby.
TweetG’Day,
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt...
2014-06-27
1,409 reads
Deck & Demo's Live & Thank You AZSSUG & OPASS!
Hello Dear Reader! Just a quick post to say Thank You to the Arizona SQL Server User Group and to...
2014-06-27
694 reads
Microsoft Azure Portal Preview looks promising !
This is one of those posts which is pending for a very long time. I was pretty excited when Azure...
2014-06-26
957 reads
T-SQL Window Functions – Part 2: Ranking Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
1,254 reads
Worst Day As A DBA
I remember the day pretty vividly, it was in the summer months and I was as green as green can...
2014-06-26
435 reads
Why Is your datetime saved as a bigint anyway?
Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.
On...
2014-06-26
729 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