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
311 reads
We can now pass dynamic values to linked services at run time in Data Factory. This enables us to do things like connecting to different databases on the same...
2020-02-05 (first published: 2020-01-30)
1,200 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
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
429 reads
Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering!...
2021-05-03 (first published: 2020-01-29)
321 reads
AWS RDS SQL Server 2017 Builds
RDS SQL Server version SQL Server Build KB / Description
SQL Server...
2020-01-29
14 reads
AWS RDS SQL Server 2017 Builds
RDS SQL Server version SQL Server Build KB / Description
SQL Server...
2020-01-29
2,278 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
191 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
53 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
20 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers