As usual, the scripts in this post can be found HERE on our Git Hub repo If your SQL Server comes across something that it’s not happy about, it...
2020-01-30
312 reads
1. Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/
2. Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/
3. Amazon RDS SQL Server now supports high availability in...
2020-01-29
432 reads
AWS RDS SQL Server Announcements - 2019
1. Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/
2. Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/
3. Amazon RDS SQL...
2020-01-29
9 reads
AWS RDS SQL Server 2017 Builds
RDS SQL Server version SQL Server Build KB / Description
SQL Server...
2020-01-29
2,281 reads
AWS RDS SQL Server 2017 Builds
RDS SQL Server version SQL Server Build KB / Description
SQL Server...
2020-01-29
16 reads
I don’t know how many of you are working with Windows Core these days but personally I think it’s a ... Continue reading
2020-01-29 (first published: 2020-01-20)
441 reads
Inspiration: The process of being mentally stimulated to do or feel something, especially to do something creative. a person or ... Continue reading
2020-01-29
21 reads
Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is...
2020-01-29 (first published: 2020-01-21)
920 reads
We know that sorting can be one of the most expensive things in an execution plan as shown below. However, we continue to do ORDER BYs repeatedly. Yes, I...
2020-01-29
56 reads
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have I Been Pwned (HIBP) for a number of years now. For the record, “pwned” is...
2020-01-29
192 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item 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