SSRS - Custom Code with External Assemblies
In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting...
2012-01-31 (first published: 2012-01-26)
24,308 reads
SQL Server – Error Logs recycle without SQL Server Restart
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming...
2012-01-26
733 reads
SQL Saturday #104 Colorado Springs, CO
Janet, my girlfriend, and I went to Colorado Springs a day early, Thursday, to ski on Friday before SQL Saturday...
2012-01-25
709 reads
Enabling Compression? Update your baseline
I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me...
2012-01-25
1,085 reads
So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
597 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,379 reads
Windows 8 Easy Refresh?
I saw this write up about the built in ability to both restore to factory settings as well as just...
2012-01-25
663 reads
Venting Frustration
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
600 reads
Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis
Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from...
2012-01-25
1,333 reads
Congratulations to Philippe Falardeau for Monsieur Lazhar's Oscar Nomination (Played by Fellag, the Algerian Comedian Famous For Le Visa)
Congratulations to Philippe Falardeau - he has made the official Oscar Nominations!
http://www.monsieurlazharmovie.com/tourné à Montréal – Filmed in Montreal! The hilarious Algerian comedian...
2012-01-25
2,743 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