Plagiarism: A Community Destroyed
Personal Thoughts
Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...
2014-06-23
493 reads
ExpressProfiler: Yet another "when and why" story.
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
755 reads
Microsoft Azure Data Services
Azure Data Services
Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options. ...
2014-06-21
1,137 reads
Clustered Columnstore Indexes – part 31 (“Memory Pressure and Row Group Sizes”)
Continuation from the previous 30 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This blog post is focusing on one of the most important real...
2014-06-21
234 reads
Baton Rouge SharePoint Saturday 2014: SQL Server Best Practices for SharePoint Databases
Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!
Here is my presentation for the 1:15 presentation in...
2014-06-21
645 reads
Clustered Columnstore Indexes – part 30 (“Bulk Load API Magic Number”)
Continuation from the previous 29 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It has been a long time (almost a year) since Microsoft revealed...
2014-06-20
214 reads
Reblog: June 13 to June 19
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-06-20
582 reads
Poecilonym Madness-Question of the Day
Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part...
2014-06-20
612 reads
Partitioning Basics – Part 3 – Switching Data
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,243 reads
Friday Followup For June 20, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-20
299 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers