Larger & Cheap(er?) Monitors
I stopped by Compusa on the way home to pick up a package of blank DVD's and did the 10...
2009-05-18
787 reads
SQL Server Encryption - Hashing Limitations
As I'm digging more into SQL Server 2008 encryption I'm learning some interesting things about how SQL Server handles encryption....
2009-05-18
2,706 reads
Back in the Top 5
My rolling 30 day post count dropped crazily this weekend. I noticed, but with family committments, I didn't do anything...
2009-05-17
638 reads
The Pro-Active DBA during the Economic Tsunami
As none of us are immune to the current financial crisis, and your development projects have probably come to a...
2009-05-16
771 reads
SQL Injection - Why I Don't Think Parameterization is Enough
Note:Since there have been several comments on this, I'm using parameterization at the application layer in the security sense of...
2009-05-15
2,708 reads
Notes from the May 14, 2009 Space Coast SQL Server User Group Meeting
I went over last night to do a presentation to the group managed by Bonnie and Lynn. Had 11 in...
2009-05-15
646 reads
Tech Ed 2009: Best of Tech Ed Winners Announced
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine,...
2009-05-15
498 reads
Where's the Phantom Power?
Phantom power, also called Vampire power, is power that's used by electronic devices even though they're powered off. I've also...
2009-05-15
916 reads
An Open Letter To Amazon
I sent this to their customer service, but it highlights a problem with the Kindle process.
I have a Kindle, and...
2009-05-14
410 reads
Taking the Hyper-V Plunge
Or at least I’m getting ready to take the plunge into using Hyper-V. In my machine dilemma, I decided to...
2009-05-14
1,662 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