Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
594 reads
Learn How to Use the SQL Server 2008 Transact-SQL Debugger
Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server...
2009-04-15
861 reads
Richmond, VA Code Camp to be Held April 25
The Richmond Code Camp 2009.1, will be held on Saturday 25, 2009 at the J. Sargeant Reynolds Community College in...
2009-04-15
639 reads
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
426 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,249 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
305 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
405 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
649 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
296 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers