Notes on the 2009 South Florida Code Camp
As I mentioned last week I drove to Miramar for the South Florida Code Camp, arriving in time for the...
2009-02-09
528 reads
Blog Posts
SQL Server 2008 Enterprise Edition install - use the "right" version of the Microsoft .NET 3.5 SP1 install
This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise...
2009-02-09
1,805 reads
Reminder: MSDN Tiki Hut Roadshow Coming to Pensacola, Tallahassee, and More
Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming...
2009-02-08
782 reads
Speaking at Community Events - More Thoughts
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to...
2009-02-08
1,274 reads
Challenging the Tyranny of Third-Party Vendors: A DBA’s Manifesto
Over the years, I have dealt with a lot of third-party applications (and their vendors) that use SQL Server as...
2009-02-06
2,846 reads
Interested in Boosting the Performance of SQL Server 2008 Analysis Services?
Microsoft has published a white paper called SQL Server 2008 White Paper: Analysis Services Performance Guide that you might find...
2009-02-06
904 reads
Professional Goals for 2009
Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's...
2009-02-06
1,233 reads
Speaking / Teaching Engagements
I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....
2009-02-06
694 reads
PASS Update #4
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...
2009-02-05
404 reads
SQL Server security bulletin due on Tuesday
As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...
2009-02-05
831 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