A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what...
2011-11-15
852 reads
DBA in Space: Behind the Scenes Part 2
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
563 reads
ColoradoSQL in November (2011)
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-11-15
829 reads
Quotename in SQL
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...
2011-11-15
8,091 reads
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
525 reads
Tuesday Hardware Tidbits, Nov 15, 2011
A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end,...
2011-11-15
851 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
707 reads
SQL Inspire NYC – 2011
The lineup for SQLInspire
I spoke at the SQL Inspire event this last weekend and it was a greart experience. This...
2011-11-14
1,504 reads
Do You Use “Forced Parameterization”?
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
798 reads
DBA in Space: Behind the Scenes Part 1
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
733 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers