SQLSaturday #13 in Atlanta - Another Update & Shared Knowledge
Stuart says that as of Feb 20 registration is at 150 with a cap of 200, and plenty of speakers...
2009-02-22
676 reads
Database Mirroring FAQ: Will the Mirror automatically fail back to the original Principal when it comes back online?
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,496 reads
Mapping Database Principals to Server Principals
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL...
2009-02-22
9,891 reads
Looking Forward to Getting My Kindle 2
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,372 reads
You HAVE to Trust, you MUST Verify -and that may still not be enough!
In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL...
2009-02-20
419 reads
You Must Trust Your DBAs
This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being...
2009-02-20
1,957 reads
Adobe Acrobat/Reader 0day - Disable JavaScript
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,071 reads
Want Information on Data Dude, Check Out DBProj.Com
If you use Data Dude (Visual Studio 2008 Team System Database Edition GDR), you might want to check out Gert...
2009-02-20
656 reads
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across...
2009-02-20
3,114 reads
How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III
How do I ... Determine Database Growth If I Am Not Tracking It?
If your database has grown considerably and you're not...
2009-02-20
5,972 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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