Review of my blog posts in 2011
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey...
2012-01-02
747 reads
SQL Index Fragmentation and sys.dm_db_index_physical_stats
Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...
2012-01-02
1,010 reads
Renewed as MVP for SQL Server
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...
2012-01-02
1,265 reads
Renewed
I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized...
2012-01-01
938 reads
2011 – The dissection
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
686 reads
Roles and Responsibilty of SQL Server DBA
What is a role of a DBA in an organization?What are the daily activities of a DBA?What shall I check...
2012-01-01
754 reads
2012: SQL Server, Olympics, Football and Darts
Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this...
2012-01-01
1,091 reads
SQL Server DBA – Grow as a DBA
It’s the first day of 2012. Setting New Year Resolutions is often a futile activity – and resolutions I’ve set in...
2012-01-01
410 reads
2011-12-31
Book review - SQL Server Secret Diary (Know the unknown secrets of SQL Server)
Like a lot of people within the SQL community, I can never read enough on the subject. Books, whitepapers, academic...
2011-12-31
2,327 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