PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...
2011-12-14
813 reads
#SQLLove for my Mentor
In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later...
2011-12-14
749 reads
TechNet Virtual Labs
There is an excellent site called TechNet Virtual Labs that enables you to quickly and easily evaluate Microsoft’s newest products and...
2011-12-14
1,087 reads
Will You Buy Refurbished? Part 1
A couple months back the laptop my wife uses was fading away, the internal power connector was broken/barely working and...
2011-12-14
644 reads
Notes from the MagicPASS Holiday Party
I haven’t been to a MagicPASS meeting in a while, so it was nice to reconnect with the group at...
2011-12-14
740 reads
Installing SharePoint 2010 and SQL Server 2012 RC0
With SQL Server 2012 right around the corner and Release Candidate 0 already out there I’m sure you will all...
2011-12-14
5,201 reads
Contracting, SQL Server and gethynellis.com
A while back I started posting some contractor related articles.The articles were mainly for the those people that wanted to...
2011-12-14
613 reads
Nic Teaming
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes...
2011-12-14
1,769 reads
Codeplex: SSIS Community Tasks and Components
I recently bumped into this very exhaustive list of SSIS tasks, components and samples in CodePlex http://ssisctc.codeplex.com. The list is maintained by...
2011-12-14
1,344 reads
2011-12-14
627 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