I’ve Got A “SQLSat” In Kalamazoo
Last night I received an e-mail letting me know that I’ll be presenting at SQL Saturday #84 in Kalamazoo, MI. ...
2011-07-22
537 reads
Blog Posts
Lookup functions in SSRS 2008 R2 - I
Introduction
Most of us who are regularly working with SSRS have always felt the need of some way through which multiple...
2011-07-22
35,034 reads
Re-blog – July 15-July 21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-07-22
627 reads
SQLSaturday Orlando 2011 Call For Speakers Closes July 24
The 2011 version of SQLSaturday Orlando (officially SQLSaturday #85), a joint effort between Orlando's PASS chapters OPASS and MagicPASS, is...
2011-07-22
591 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,263 reads
SSRS: Dynamic Data Sources
I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be...
2011-07-22
7,965 reads
Visual Studio vNext
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
730 reads
Article: How to use temporary table in function
Steve Jones from voiceofthedba.com, editor on SQLServerCentral.com gave me an opportunity to publish humble article about workaround solution for using...
2011-07-21
513 reads
Bad Admins: Pocketing Backups
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-21
735 reads
Cursor in sql server
Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic...
2011-07-21
2,695 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