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
877 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2015-05-19
1,520 reads
Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
2015-05-18
83 reads
Testing Simple Calculations and UDFs with tSQLt
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
2015-05-18
5,589 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
680 reads
Learn tSQLt and Unit Testing in Philadelphia
SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not...
2015-05-15 (first published: 2015-05-06)
5,734 reads
Quick Installs with Chocolatey–Screen Capture
I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...
2015-05-15
914 reads
Searching for Plans
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
2015-05-15 (first published: 2010-09-13)
289 reads
2015-05-15
1,754 reads
Getting Database Properties – DatabasePropertyEx()
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-05-14
2,741 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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