SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.
Update: Since...
2016-11-21
17 reads
SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article,...
2016-11-29 (first published: 2016-11-21)
2,926 reads
Query Data Store Data
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...
2016-11-28 (first published: 2016-11-21)
1,284 reads
Reload a table quickly.
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....
2016-11-28 (first published: 2016-11-21)
2,908 reads
Associative Analytics: Two sample T Test
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,578 reads
An early Christmas present - Great Value SQL Server Training the Decemeber
No No, not my new hat, although it is rather splendid. I have received the weekly email from Learning Tree listing...
2016-11-21
453 reads
Monday Coffee 2016-11-21
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made...
2016-11-21
355 reads
Task Manager is a liar
I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try...
2016-11-21
578 reads
Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)
Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of...
2016-11-20
624 reads
Custom indexes on VMware vCenter database breaks 6.5 upgrade
Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before...
2016-11-20
627 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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