SQLSaturday #96 in DC - 11/5/2011
Coming to the Capitol, tomorrow Saturday, November 5, 2011 is SQLSaturday#96 in Washington, D.C.! This great event down in DC,...
2011-11-04
887 reads
Blog Posts
Things I Favorited on Twitter (a weekly wrapup, of sorts)
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
938 reads
What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,130 reads
Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
825 reads
Why SQL Server is using so LESS memory
Today I want to talk about a phenomenon regarding memory management in SQL Server.
A few weeks ago I had a...
2011-11-04
7,227 reads
An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,477 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
15 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,270 reads
DDL Auditing presentation – feedback
Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than...
2011-11-03
790 reads
Dimensional Modeling Financial Data in SSAS pt2
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,287 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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