As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also MariaDB, MySQL, and PostgreSQL so...
2020-11-03
59 reads
If you ask any senior IT person What is the most important tool you have? there is a decent chance that ... Continue reading
2020-11-10 (first published: 2020-11-03)
590 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-03
26 reads
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of...
2020-11-10 (first published: 2020-11-03)
627 reads
It is a really common requirement to add specific libraries to databricks. Libraries can be written in Python, Java, Scala, and R. You can upload Java, Scala, and Python...
2020-11-03
40 reads
Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
Some do.
Recently, by far the most frequent and common disaster recovery...
2020-11-09 (first published: 2020-11-03)
730 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-02
27 reads
The purpose of a foreign key is to ensure data integrity by making sure that data added to a child table actually exists in the parent table and preventing...
2020-11-09 (first published: 2020-11-02)
267 reads
I was in a webinar recently and saw a note about variable groups. That looked interesting, as I’ve started to find that I may have lots of variables in...
2020-11-06 (first published: 2020-11-02)
243 reads
2020-11-01
16 reads
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
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