Conditional Default Values in SSRS
I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. ...
2012-02-07
3,419 reads
Send email from Powershell with attachment
This post describes how to call to add an email attachment using Powershell.
In an earlier post - SQL Server – Send email...
2012-02-07
8,266 reads
Arithmetic Overflow in sp_MSarticle_validation
This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more...
2012-02-07
1,021 reads
February 2012 – Monthly SQL Server Checklist
It’s the first Monday of February, mostly, it’s a short month, but there’s no reason to skirt on checking out...
2012-02-07
822 reads
SQL Saturday Jacksonville and Precon with Kevin Kline
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year...
2012-02-07
1,053 reads
Finding the Missing Perfmon Counters in SQL Express
My post this weekend about slaying beasts with magical .dll incantations was my way of relieving some stress after having...
2012-02-07
2,396 reads
Building or Buying a Desktop Based Development and Test Database Server
Back in April of 2011, I wrote a post that compared the merits of using an ancient, but actual rack...
2012-02-06
1,424 reads
Why Every DBA is a Clown
It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...
2012-02-06
997 reads
Baton Rouge SQL Server User Group
I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session...
2012-02-06
682 reads
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,719 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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