Do You Use Projects/Solutions in SSMS?
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving...
2009-12-10
1,778 reads
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving...
2009-12-10
1,778 reads
This was the first meeting where I really lead most of the meeting. Andy Warren (@sqlandy) did the networking at...
2009-12-09
368 reads
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
466 reads
Alternative title for programmers using C-derivatives and Java:
Good Programmer == Lazy & Dumb?
I read this blog post, Why Good Programmers Are...
2009-12-07
670 reads
Several months ago I received a copy of the Apress book, Pro SQL Server 2008 Administration (Amazon)by Ken Simmons (@kensimmons),...
2009-12-04
987 reads
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,654 reads
I’ve already written four posts (1, 2, 3, 4) that discussed what I did at the Summit, including what I...
2009-11-09
419 reads
After the first 2 official days of the Summit the brain is already on overload and then the second part...
2009-11-07
547 reads
Finally time for the sessions to begin after a day and a half in Seattle being overwhelmed by the people...
2009-11-05
739 reads
I actually slept in on Wednesday until 6am. This was a change from being wide awake at 4am. I made...
2009-11-05
540 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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