January #Meme15 Round-Up
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were...
2012-01-28
799 reads
Blog Posts
Petitions on Change.org and Thoughts on Changing PASS
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...
2012-01-28
796 reads
Blogging: Building a Blog
I took an interest in building a blog/website several years ago when I first started my company and working for...
2012-01-27
756 reads
Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...
2012-01-27 (first published: 2012-01-23)
3,086 reads
2012-01-27
710 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
638 reads
Re-blog – January 20 – January 26
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-27
546 reads
SQL Server - Generate SQL INSERT from Excel
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY...
2012-01-27
1,077 reads
SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,286 reads
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)
I was a big fan of the original Iron...
2012-01-27 (first published: 2012-01-22)
2,806 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