Portland, OR Code Camp Set for May 30, 2009
The Portland Code Camp will be held at Reed College on Saturday, May 30, 2009. This free event will include...
2009-04-15
423 reads
Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance
Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for SQL Server 2008, which is available at:
Troubleshooting...
2009-04-15
1,246 reads
Last Call for Speakers for SQLSaturday #7 in Birmingham on May 30
I just had a call with John Baldwin who is leading the effort in Birmingham and there plenty of action...
2009-04-15
304 reads
Tax Day
A reminder of one of the downsides of working is today: Tax Day. In the US, income tax filing is...
2009-04-15
868 reads
Do You Take Notes?
I happen to notice this in a class recently that I had the rare student - one that could take notes...
2009-04-14
403 reads
Taking Advantage
I read SQLBatman's post about his first week as an MVP, and it really resonated well with me. I think...
2009-04-14
648 reads
PASS Connector Editorial for April 8, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-13
295 reads
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 Update #9
Time has flown by since my last update, busy time at work and struggling to get that done and find...
2009-04-13
399 reads
SQL Server 2005/8 Database Compression Presentation in Burlington, Vermont - April 15th
Yesterday, I drove the Smart down to Burlington/Colchester, Vermont to meet up with MVP Roman Rehak and speak to the local...
2009-04-13
1,084 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