Computed Columns and Divide by Zero
I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...
2012-02-07
4,517 reads
Blog Posts
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
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2012-02-07
18,796 reads
Denali
Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...
2012-02-07
855 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
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
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon. I enjoyed reading this book. The story continues from Daemon, but in...
2012-02-07
23 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon.
I enjoyed reading this...
2012-02-07
721 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,711 reads
List failed SQL server Jobs with Powershell
This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to...
2012-02-07 (first published: 2012-02-06)
2,318 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