Being a Better IT Pro – Keep It Short
Keep your emails and communications as short as possible.
Make sure you cover everything you absolutely need to, but nothing more....
2014-01-08
400 reads
Sausage Making
For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...
2014-01-15 (first published: 2014-01-08)
2,043 reads
Changes to PASS Voting Eligibility
There was a blurb in the Connector today about an eligibility change for voting. The “change” is a requirement to...
2014-01-08
396 reads
Understanding the Copy_Only option in Backups for SQL Server
The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of...
2014-01-08
1,074 reads
Powershell – Age of File Report – Local or Remote
Here’s a very quick post by request.I just had a request for searching the file system for files matching certain...
2014-01-08
1,665 reads
Reporting Services Parameter Assumptions
Ran into a new-to-me quirk this week while putting together a couple of reports. I have a summary report (essentially...
2014-01-08
525 reads
Retrofit a VM with the VMware Paravirtual SCSI Driver
For those of you with your mission-critical servers already virtualized on a VMware-based virtual infrastructure, are you using the VMware...
2014-01-08
2,132 reads
Transactions: What are they?
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,417 reads
[Video] ApexSQL Log – Software Review
Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery....
2014-01-08
814 reads
Apply SP1 to SQL Server 2012 on active/active Windows Server 2012 cluster.
A while ago I blogged my about my approach to service packing a SQL Server 2008R2 active active cluster. Time...
2014-01-08
1,595 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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