Understanding Analysis Services Relationships using Dimension Usage
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure...
2014-07-15
1,725 reads
PASS SQL Saturday Events: August 2014
DateEventAugust 2 SQLSaturday #324 – Baton Rouge 2014August 9 SQLSaturday #304 – Indianapolis 2014August 23 SQLSaturday #328 – Birmingham 2014August 23 SQLSaturday #309...
2014-07-15
648 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
572 reads
Execution Plan Details
I wouldn’t say it’s common knowledge that you should look at execution plans when tuning queries, but it’s not exactly...
2014-07-17 (first published: 2014-07-15)
10,310 reads
Building the SQLSaturday Orlando Marketing Plan-Part 22
Had our second planning meeting, still trying to complete the email template and realized we had not clearly defined two...
2014-07-15
644 reads
Merge csv files – quick PowerShell snippet
During a bit of work I’ve been doing this evening for SQLRelay, I used something I have in my arsenal of...
2014-07-14
1,091 reads
Murder In Denver
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-07-14
7 reads
Murder In Denver
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-07-14
779 reads
SSC Editorial: Infect Your Colleagues with the Learning Bug
If you work with colleagues that aren’t as interested in growing and learning as you are, I hope you’ll read...
2014-07-14
641 reads
The SQL Sac wrap!!
Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave a BIG mark. That’s right, this last weekend was...
2014-07-14
6 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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