3D Printing for Under $1000
I saw this about the iModela 3d printer, it’s priced under $1000, making it approachable if not quite cheap. 3d...
2011-10-19
626 reads
Moving to House of Brick
Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.
To everyone out there saying "Didn't you...
2011-10-19
535 reads
Culture Posters
I work with a client now that had a poster made of the top 10 values for the IT department....
2011-10-19
624 reads
Announcing the fifth certification study session
The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...
2011-10-19
992 reads
SQL Server – Moving table with LOB data to different file group
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,695 reads
Next PASS Summit is Nov 6-9, 2012
After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...
2011-10-19
545 reads
JOIN IN SQL FAQ
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL...
2011-10-19
1,465 reads
Using sys.dm_exec_requests to find a blocking chain
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,181 reads
Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!
Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...
2011-10-18
681 reads
October 2011 SQL Server 2008 Diagnostic Information Queries
Since Microsoft has been so busy releasing Cumulative Updates for both SQL Server 2008 and SQL Server 2008 R2 over...
2011-10-18
1,686 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