Role-playing Dimensions
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,887 reads
Blog Posts
SQL Dirty Pages
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is...
2011-11-28
12,270 reads
SQL Server A to Z – Waits
In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...
2011-11-28
903 reads
What Opportunity Are You Looking For?
http://www.flickr.com/photos/mencho-22/6218974134/
A lot has been happening this year. I decided to throw my hat in the ring at being a blogger...
2011-11-28
747 reads
And the winners of SafePeak’s SQL Server Performance Contest are...
SafePeak’s SQL Server Performance Contest – Winners
(In coordination with SQLAuthority.com) Back in September, 2011, SafePeak ran a new contest asking participants to share...
2011-11-27
1,855 reads
Installing SQL Server 2012 RC0 from an iPhone
Short version – Installed SQL Server 2012 RC0 onto a Server 2008 SP2 VM using an RDP connection from my iPhone...
2011-11-27
2,781 reads
MS Days 2011 in Albania, Tirana
I would like to write about the tech events in my country and our brother-neighbor Albania, that everyday we are...
2011-11-27
960 reads
Data Loading Performance Guide
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL...
2011-11-26
3,645 reads
Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug
Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...
2011-11-26
9,775 reads
Adelaide SQL Server User Group Slides and Scripts
You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...
2011-11-25
527 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