SQL Server Special Ops
SQL Server 2012 is coming to 12 cities next year. Is your city on the list? It can be – or...
2011-11-29
864 reads
SQL Saturday 99 – Quest Interview
Welcome to the first of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-11-29
516 reads
DBA in Space: Behind the Scenes—Question 7
This is a continuation of my DBA in Space journal.
Episode seven is filmed at the “Animals in Space” exhibit at...
2011-11-29
574 reads
SQL Mag Top 10 Bloggers
I was astounded to see this blog at #4 on the list from the recent SQL Server Magazine Community Choice...
2011-11-29
714 reads
SSRS Export part 2 (Export Data Source)
Pro-tip on how to quickly and easily migrate data sources for reporting services.
Related Posts:
File Maintenance - Cleaning Up Old Files December 21, 2018
Get a List of Files with...
2011-11-29
19 reads
SSRS Export part 2 (Export Data Source)
Back in August, I published a post on exporting SSRS report files en masse. That article (which can be read...
2011-11-29
1,701 reads
New string function in SQL Server 2012 – FORMAT()
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...
2011-11-29
3,246 reads
Silly issues with SSRS
Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started...
2011-11-29
907 reads
Day 2: Log file grown high cannot shrink log file.(available size in – negative)
Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...
2011-11-29
535 reads
Execution plan warnings–The final chapter
In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...
2011-11-29
1,857 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