DBA Mission and Vision Statement
There is a saying that "The important is often not
urgent and the urgent not important". I could not agree more...
2009-01-03
18,349 reads
Blog Posts
SQL 2008 Row and Page compression – or SQL 2005 (post SP2) vardecimal conversion
One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those...
2009-01-02
1,781 reads
How Certification Can Help You Stay Current with Technology, as well as Continuing Your Education
If you'd like to keep up with your profession as a SQL DBA, I thoroughly recommend certification. It has certainly...
2009-01-01
2,004 reads
Meeting Goals
I'm not a big goals person. I think it's a good idea to set goals, and they can help you,...
2009-01-01
449 reads
MVP 2009
I was re-awarded MVP status from Microsoft for 2009. Since I didn’t hear anything to the contrary in the last...
2009-01-01
455 reads
MVP Award
Received my notification via email this morning that I've been recognized as a Microsoft MVP for SQL Server. It's been...
2009-01-01
739 reads
PASS Update #1
As many of you know I'm joining the PASS Board of Directors for a two year term beginning yesterday. I'm...
2009-01-01
388 reads
Thoughts for 2009
Only a few changes planned for this coming year to the blog (so far), none of them huge:
I plan to...
2008-12-31
1,413 reads
Another Use of XML
XBRL is yet another use of XML, this time for financial reporting. It is supposed to be in place for...
2008-12-30
1,726 reads
End of 2008 Wrap Up Post
Something new for the end of the year - a recap of everything I posted for 2008. 303 posts if the...
2008-12-30
1,548 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