SQL Server MVP Deep Dives
I’ve been reading through this book and it really does have something for everyone at any level.
I think it...
2009-09-29
1,463 reads
I’ve been reading through this book and it really does have something for everyone at any level.
I think it...
2009-09-29
1,463 reads
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use...
2009-09-29
1,831 reads
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,742 reads
create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
@id int
as
insert MyTable select @id
insert #test select...
2009-09-29
1,706 reads
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....
2009-09-28
956 reads
OK, there was something that Microsoft did to tick me off. SQL Server 2005 introduced us to so many exciting...
2009-09-28
6,205 reads
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,351 reads
I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a...
2009-09-28
1,103 reads
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going...
2009-09-28
571 reads
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
426 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