Azure SQL Database Compatibility with SQL Server
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
2,171 reads
gorandalf
The value of mentoring
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
217 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
140 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
48 reads
Connect() live stream for Developers around the World
Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.
The Connect(); 2017...
2017-11-13
291 reads
Windows Tips and Tricks – Why do I Have Trouble Ejecting USB Hard Drives?
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
399 reads
SQL Server 2017 is coming
It’s official: the next version of SQL Server, planned to be released this year, will be called SQL Server 2017....
2017-04-19
3,405 reads
Windows Tips and Tricks – Quick Screen Clipping
It’s quite easy to hit the PrintScreen key and capture the whole screen. But how do we quickly capture a...
2017-04-07 (first published: 2017-03-22)
2,432 reads
Here I go again
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when...
2017-03-21
311 reads
Dynamic Data Masking
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses,...
2016-03-04 (first published: 2016-02-29)
2,167 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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