Columnstore Indexes – part 62 (“Row Groups Trimming”)
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
573 reads
oPASS & MagicPASS Meeting Tonight
David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL...
2015-08-12
566 reads
Here’s the New #Excel 2016 Chart Types!
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,167 reads
Hadoop and Microsoft
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of...
2015-08-12
3,196 reads
Please Welcome Our New Certified SQL Server DBA’s!
Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people...
2015-08-12
629 reads
Open SQL Server Virtualization Q&A Webinar – 8/19
Next Wednesday, August 19th, at noon Eastern the PASSVirtualization Virtual Chapter will be holding an open questions and answers session...
2015-08-12
528 reads
Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better
[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...
2015-08-12
1,307 reads
Farewell Scott McKenzie
Scott McKenzie was the DJ of Mix 105 here in Orlando for an astounding 24 years and that’s been the...
2015-08-12
638 reads
Red Gate SQL Source Control v4 offers schema locks
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
286 reads
System databases maintenance in SQL Server
Let’s talk about maintenance of system databases in MS SQL Server. There are a few differences from user databases.
At first let`s remember...
2015-08-12
2,042 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