Track Incomplete Statements
What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for...
2014-07-16
606 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,221 reads
SQL Speakers–Will You Accept The Chapter Challenge?
Most SQLSaturday’s do ok when it comes to finding speakers, the results of an incredible speaker mailing list and a...
2014-07-18 (first published: 2014-07-16)
639 reads
Presentation to the Baltimore SQL Group on July 15, 2014
I did an online presentation about PCI and Credit Card Security for BSSUG last night and it went pretty well,...
2014-07-16
679 reads
Building The SQLSaturday Orlando Marketing Plan-Part 23
Here’s the latest update on our registrations. We’re still ahead of all our previous events, that’s good, and we’re 2...
2014-07-16
575 reads
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own to share. I’m excited to say that I’ll be...
2014-07-16
5 reads
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own to share. I’m excited to say that I’ll be...
2014-07-16
11 reads
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own...
2014-07-16
387 reads
Yes, Virginia, you can have too much white space.
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch...
2014-07-22 (first published: 2014-07-16)
9,139 reads
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
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