SQL Server 2014 Service Pack 1 (SP1) Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for...
2015-05-25
864 reads
CDO Summit Toronto June 4th
I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th. My session is on...
2015-05-24
446 reads
Azure Columnstore, part 3 – Modern Segment Elimination and Set Statistics IO
Welcome to the 3rd blog post in the Azure Columnstore series, this one is dedicated to one very important improvement...
2015-05-24
477 reads
Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)
Continuation from the previous 52 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a very small blog post...
2015-05-22
463 reads
How I Got Started in Software Development-A Tribute to Ed
Steve:
Happy Memorial Weekend everyone. This is a time to remember those who have gone before and in some cases have...
2015-05-22
436 reads
Unit Testing in Philadelphia
I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an...
2015-05-22
691 reads
VM Memory Counters Lie for SQL Server VMs
A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the...
2015-06-03 (first published: 2015-05-22)
2,412 reads
004 – Cracked Foundation - WaterOx Consulting
Reading Time: 4 minutesDo You Have a Cracked Foundation? in WOxPod!, episode # 004 –...
The post 004 – Cracked Foundation appeared first...
2015-05-22
354 reads
An Extended Event script
I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...
2015-05-22
161 reads
Speaking at SQLSaturday Rheinland, Germany 2015
It is always a very special moment whenever you receive a notification of being selected to present at any event....
2015-05-22
360 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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