SQLRally, Pre-Cons, and Taking Risks
Before I get into my thoughts, go vote! Here are the options this year for the SQLRally pre-cons:
BI Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingBI.aspxDBA...
2010-10-29
1,462 reads
SQL Saturday 58 TODAY! #sqlsat58
Don’t forget the Minnesota SQL Saturday is TODAY. Obviously, this was written before today and I’m hoping to catch a...
2010-10-29
1,483 reads
Free SQL Server Training for the Week of November 1, 2010
Tuesday
PASS Performance Virtual Chapter - Five Fast Fixes for Fatal Flaws - Brent Ozar
Wednesday
SQL Lunch - Data Mining in SQL Server and Power...
2010-10-29
1,815 reads
Shopping
In about a week and a half, the SQLServerCentral opening night party takes place at the PASS Summit. And while...
2010-10-29
1,661 reads
SQLSaturday #59 – Speaker Interview Series #14 with Grant Fritchey
Sunday, October 31, 2010 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and...
2010-10-29
2,418 reads
My Bucket List
I actually built on in 1999 and called it a Life List. Over the years I’ve tried to work on...
2010-10-29
1,536 reads
Creating Analysis Services Partitions Using BIDS
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...
2010-10-28
3,366 reads
Adding Data Compression to an Existing Clustered Index in SQL Server 2008 R2
Working at an ISV like NewsGator Technologies, I get to work on products like Social Sites for SharePoint 2010, that...
2010-10-28
2,638 reads
PASS Summit Blogging
During the PASS Summit I have again been given the opportunity to keep my laptop plugged in… as long as...
2010-10-28
769 reads
Fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
1,144 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