Best PASS Summit Ever (so far)
I have to admit that the 2011 PASS Summit was such an amazing experience and there was so much to...
2011-10-20
696 reads
Blog Posts
Denver SQL Server User’s Group Meeting on October 20, 2011
The Denver SQL Server User’s Group will be having their monthly meeting tonight at the Microsoft office in the Denver...
2011-10-20
733 reads
Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-20
21,514 reads
Jeremy Huppatz presents Row Versioned Data Warehouse
Subject: Row Versioned Data WarehousesLevel: 200-300 (Intermediate)
Start Time: Thursday, December 15th, 2011 8:00 PM US Central Time
Presenter: Jeremy Huppatz...
2011-10-20
515 reads
PASS Board Of Elections: Adam Jorgensen
Be Part Of The Solution, Not The Problem
<disclaimer >
Now that BoD season is in full swing and I’m not running for...
2011-10-20
1,459 reads
Penance
Buck Woody wrote a fantastic post this morning for speakers to think about. All too often I have seen some...
2011-10-20
1,849 reads
Setting up SSIS Auditing Part 2
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-20
3,600 reads
SolidQ Announces BI Center of Excellence
Carl Rabeler, SharePoint and SQL BI Expert Formerly With Microsoft SQLCAT, Rejoins SolidQ as Director of the Business Intelligence Center...
2011-10-20
911 reads
sp_configure OR sys.configurations? and do you back these up?
G’day,
I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people...
2011-10-20
6,784 reads
Todo lo que debes saber sobre SSIS en 1 hora!
Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento...
2011-10-20
1,327 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