Looking for a Laptop......
Now that the kids have interest in computers, I sometimes find myself competing with them. I recently purchased a business class...
2009-08-29
1,365 reads
Blog Posts
SQL Server Standard Update
We’ve received wonderful support from the community. Brad McGehee has a list with great people on it who have volunteered...
2009-08-29
1,666 reads
Broken - Windows 7
I've been running the Windows 7 RC for a few months, and overall I like it. Many things work well,...
2009-08-28
974 reads
Conditional reIndex and update stats.
Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...
2009-08-28
1,932 reads
Microsoft Has Newly Updated Public MVP Website
Microsoft has recently unveiled their newly updated, public MVP website, that does a great job of explaining exactly what a...
2009-08-28
1,906 reads
Quick 2005/2008 Script to Export Permissions
I had a need to export permissions to be run against the database once an older version was restored (but which didn't...
2009-08-28
13,583 reads
SQL Reporting Services 2008 Upgrade – The Call To Microsoft
I recently submitted an article to SQLServerCentral about my adventures in upgrading my existing SSRS 2005 instance to 2008. In...
2009-08-28
600 reads
SQLLunch.com – Looking for a Website Template
As most of you know I am hosting a bi-weekly Live Meeting event called SQLLunch. I recently purchased www.sqllunch.com and...
2009-08-28
737 reads
SQLSaturday #21 – Orlando Update
Event Record
This is the third year that Orlando has hosted a SQLSaturday. In 2007, I was an attendee; 2008, I...
2009-08-28
345 reads
Analysis Services Memory Limits
I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...
2009-08-27
3,825 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