Windows 7 Issues
I went to add a few things to the new Windows 7 desktop today, and of course I have installer...
2009-06-24
791 reads
Blog Posts
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
633 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,057 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,023 reads
Spring Cleaning
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
533 reads
What Would You Like to See in a Book on Database Maintenance?
I am working on the outline of a new book I am writing, tentatively called Mastering SQL Server Database Maintenance....
2009-06-23
687 reads
Am I a bad employee if I don't blog?
No.
Blogging is not for everyone and you don't want to give the impression you are something you are not doing...
2009-06-22
1,605 reads
Big Thinker
My friend Robert Cain was kind enough to include me on his list of big thinkers along with my business...
2009-06-22
811 reads
Emergency Procedures
In a followup to Aaron Bertrand's recent blog post on Disaster Recovery, I'd like to mention something I always mention...
2009-06-22
373 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install.
One of the things I always says is...
2009-06-22
3,391 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