Relocating oPASS
I mentioned last week about closing down sqlgroups.com and trying to decide on a new home for oPASS.org. We did...
2009-08-04
359 reads
Another Reason To Install Service Pack 1 CU3 on SQL Server 2008
Microsoft has a new KB article describing a problem where the MAXDOP setting that you specify (whether at the instance...
2009-08-04
827 reads
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is...
2009-08-04
471 reads
Disaster Recovery Scenarios with HP Data Protector
Let's say it is a late Monday morning, because something always comes up before you are required at your vocation,...
2009-08-04
7,959 reads
Looking for Good (and Bad) SQL Server Blogs
I was asked to do an hour presentation during the 24 Hours of PASS, which takes place on Sept 2,...
2009-08-04
517 reads
Agile Practices Meet Database Development: Intro
I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...
2009-08-04
3,501 reads
SQL Saturday - Top 5 Suggestions from the Attendees
After spending much of the last two days reading through over 200 SQL Saturday Event Evaluations I have come up...
2009-08-04
855 reads
Second SW Florida .Net Code Camp Announced for Oct 3, 2009
John Dunagan is the “Chief Organizer” of this event on October 3rd in Estero, FL, just south of Ft Myers....
2009-08-04
328 reads
SQL Bloggers, Make Yourself Known
Are you an active SQL Server blogger? Do you blog regularly about the greatest database technology available? If so, you...
2009-08-04
630 reads
Eval Results from SQLSaturday #7
John finally got things caught up and had time to finish the evals, here’s how I did on my presentation...
2009-08-03
332 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