See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
2022-08-10
Learn how to use statistical functions in Python with data from a SQL Server database along with several different examples.
2022-08-10
Learn how Splunk can be used to get information from application logs or a SQL Server database.
2022-08-08
1,548 reads
Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.
2022-08-08
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle
2022-08-08
In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]
2022-08-06 (first published: 2022-07-27)
1,971 reads
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
21,461 reads
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
2022-08-05
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
2022-08-05
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]
2022-08-03
3,155 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Comments posted to this topic are about the item String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers