PostgreSQL v SQL Server
A site that’s a comparison of the platforms.
http://www.pg-versus-ms.com/
Certainly some good arguments being made, but (admittedly) biased towards specific workload items...
2015-05-19
881 reads
Getting Started with Microsoft Azure
By David Postlethwaite
The URL for Microsoft Azure is http://azure.microsoft.com.
Make sure you have an up to date browser because parts of...
2015-05-19
558 reads
Extended Events to the Rescue
On May 18 I presented a session about Extended Events as part of the Global Hebrew PASS Virtual Chapter. I...
2015-05-19
491 reads
The Case for Optimize for Ad Hoc Workloads
I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server...
2015-05-19
832 reads
ASP.NET 5 Unit Testing With xUnit.net
This post is part of a series on ASP.NET 5, the index for this can be found here ASP.NET 5...
2015-05-19
58 reads
Slides & demos from SQL Saturday Rochester
Slides & demos from my SQL Saturday Rochester presentation “Easing into Scripting with Windows PowerShell” have been posted on the SQL Saturday site.
Thank you to everyone who came out for...
2015-05-19
14 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that...
2015-05-18
11 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...
2015-05-18
485 reads
Why Test Table MetaData Tests with tSQLt
I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...
2015-05-18
681 reads
Counting the number of rows in a table
Don’t be fooled by the title of this post: while counting the number of rows in a table is a...
2015-05-25 (first published: 2015-05-18)
9,274 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