VMware vExpert 2016 Announcement
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
463 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
158 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,933 reads
How Much Hospitals Charge For The Same Type Of Cases?
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,222 reads
Spring Training: Developing SQL Queries for SQL Server
Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...
2016-02-09
479 reads
Memory Fundamentals for SQL Server - Process-Thread Model, CPU execution model, CPU scheduling, CPU Architechture, SQLOS
Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html
So how exactly are user applications like SQL server assigned to...
2016-02-09
2,666 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
532 reads
Upcoming SQL Saturday Precon Sessions (Update!!!!)
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
954 reads
Monday Morning SQL Break – February 8, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-08
347 reads
Introduction to SQL Server: The Main Components
There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a...
2016-02-08
889 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