The First Post
I have been a SQL Server DBA and Developer for nearly ten years. In that time I have amassed a...
2011-05-05
452 reads
Blog Posts
Designing Reports with Custom MDX Queries – part 2
…continued from part 1:
Building a Report
For the remainder of this article, I will demonstrate query and report design techniques by...
2011-05-04
1,679 reads
Designing Reports with Custom MDX Queries – part 3
Start at part 1
…continued from part 2:
Handling Parameters
When an MDX query is created using the graphic query designer, parameters can...
2011-05-04
1,219 reads
How do you create or update stored procedures.
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,950 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
Advertisements
Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One
I am a bit late to this party. I have seen...
2011-05-04
470 reads
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
479 reads
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,404 reads
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
516 reads
SQLRally 2011 Scripting Guy Guest Blog Post
Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of May 2nd 2011 including...
2011-05-04
833 reads
SQLRally–Don’t Forget Your Business Cards?
SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up...
2011-05-04
491 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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