A Solid Laser Printer
I bought a Brother 2060 about 5 years ago to serve as our primary printer at the ranch. It was...
2012-03-01
971 reads
Blog Posts
Checking Your Service Account with T-SQL
Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect...
2012-03-01 (first published: 2012-02-22)
2,823 reads
Choosing the Right Microsoft Reporting Technology Part 1: Report Services
As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data...
2012-03-01
1,468 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...
2012-03-01
17 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are?
Finding...
2012-03-01
1,113 reads
March Question: What tool(s) do you use to help you identify and tune slow performing queries?
Tuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s...
2012-03-01
1,213 reads
Smart Car Charging
I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...
2012-03-01
889 reads
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,032 reads
SQL Saturday # 103 in Curacao a Success
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,347 reads
sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,301 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