SQL Server 2008 Encryption
I'm embarking on another book project. Not writing this time, but tech editing again. I tech edited a book last...
2009-04-13
624 reads
Blog Posts
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you...
2009-04-13
1,237 reads
PASS Connector Editorial For March 25, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
317 reads
What's my (fully qualified domain) name?
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,501 reads
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,429 reads
No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
801 reads
Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,792 reads
Book Review: Red Lightning
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
297 reads
My Kingdom for a Port
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,078 reads
My Mini Identity Protection
Last week, on April Fool’s Day, I woke up to find quite a few birthday congratulations in my email. I...
2009-04-09
388 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers