My 2011 PASS Summit Submissions
I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle...
2011-05-06
800 reads
Blog Posts
New Diagnostic Manager functionality
The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives...
2011-05-06
1,039 reads
Orlando 101 For SQLRally Attendees: Weather
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-06
847 reads
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of
my customers. One big part of this...
2011-05-06
1,449 reads
Re-blog – April 29-May 5
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-06
567 reads
SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,112 reads
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
401 reads
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,288 reads
Why you should ask your CTO to attend the User group meetings.
When we (Bill Wunder and me) started our user group, the first person we invited to sign up to our...
2011-05-06
1,859 reads
A row has no row number
It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...
2011-05-05
3,973 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