Testing Flyway Migrations Using Transactions
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
2021-06-30
Additional Articles
Creating and Maintaining a SQL Code Snippet Library
How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.
2021-06-28
Getting Started with Azure Purview for Data Governance
In this article we will explore how to get started with Azure Purview and then explore some of the features within Purview Studio.
2021-06-28
Opening JSON Data with T-SQL
The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.
2021-06-25
Running SQL Clone on an Azure VM with Azure File Storage
How to use SQL Clone in the Azure Cloud, installing it on an Azure Virtual Machine, storing a copy of your SQL Server database as an 'image' on an Azure File Share, and then deploying multiple clones to another Azure VM or to a remote machine.
2021-06-25
Notify Users of Power BI Dataset Changes
In this article we cover the steps on how to send notifications to business users when a change in a dataset used for Power BI has occurred.
2021-06-23
Who is responsible for building tests?
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, you'll pretty quickly come to the question: who is responsible for building tests?
2021-06-23
How DevOps can enable the evolving insurance landscape
The insurance landscape is evolving, and customer demands are far from where they used to be, with some of the biggest changes happening in the last year. James Boother from COEO covers how database DevOps can enable the evolving insurance landscape.
2021-06-21
Move SQL Server Files for Master Database
In this second part of this article we look at how to move the SQL Server master database files to a different location.
2021-06-21
Azure Databricks Access Controls and Row Level Security
Azure Databricks has a number of Access Controls and Row Level Security options that we will explore in this article.
2021-06-18
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers