SQL Server 2012: Business Intelligence Edition
Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for...
2011-11-03
2,722 reads
sqlchicken
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,449 reads
We Are Community
Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused...
2011-10-19
1,151 reads
PASS Summit Keynote Day 1 Highlights
CLOUD! BIG DATA! EXCEL! CLOUD! CLOUD! Okay, recap done. Not really…sort of. In all honesty, while delivered in a fairly...
2011-10-13
717 reads
Expiring Databases and Policy-Based Management
Today on Twitter my friend Jes “Run Forrest Run” Schultz Borland (Blog | Twitter) asked the Community “How do you clean...
2011-10-06
1,262 reads
Small Business Hardware
[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.
This is the...
2011-09-26
1,428 reads
SQL University: SQL Server Editions for Small Businesses
In our last session we talked a little bit about the different options you have in regards to SQL Server...
2011-09-21
1,101 reads
SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at...
2011-09-19
836 reads
SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in...
2011-07-27
692 reads
OMG I’m an MVP!
I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week...
2011-07-25
792 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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