Rebooting SQLNewBlogger in November
I ran into Ed Leighton-Dick last week at the PASS Summit and we were chatting about the SQLNewBlogger challenge he...
2015-11-13 (first published: 2015-11-06)
1,024 reads
DirectQuery in Power BI Desktop
In the latest Power BI Desktop a new Preview features was released that now allows you to connect using DirectQuery...
2015-11-06
1,975 reads
New Series 2 at a Time
Hi all
i have posted quite a few blogs till now, all of them were individual post except a short series...
2015-11-06
387 reads
Hekaton Part 11 :- Finding row count in memory table
Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and...
2015-11-06
955 reads
Blocking SSDT Deployments When You Don't Like Something
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
392 reads
Blocking SSDT Deployments When You Dont Like Something
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for a little while, if anyone else has one they...
2015-11-06
9 reads
Blocking SSDT Deployments When You Dont Like Something
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
29 reads
Blocking SSDT Deployments When You Dont Like Something
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
30 reads
SQL Server Edition aware SSDT deployment scripts
Another day another deployment contributor for the project: https://github.com/DacFxDeploymentContributors/Contributors.
This one came about because I was talking to Peter Schott (b|t)...
2015-11-05
367 reads
SQL Server Edition aware SSDT deployment scripts
Another day another deployment contributor for the project: https://github.com/DacFxDeploymentContributors/Contributors.
This one came about because I was talking to Peter Schott (b|t) over at the deployment contributor gitter room and he...
2015-11-05
4 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
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...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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