Flyway with SQLite for Those of a Nervous Disposition
Get started with running Flyway migrations on SQLite databases, using PowerShell.
2021-08-27
Vendors/3rd-party Products
Getting Started with Flyway Migrations on PostgreSQL
Phil Factor brings us yet another lesson in Flyway and database migrations. Learn how to use PowerShell with Flyway to run SQL migration scripts that will build, fill and modify a PostgreSQL database.
2021-08-23
Testing SQL Server Databases Using SQL Test
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
2021-08-20
Microsoft at PASS Data Community Summit 2021
We're thrilled to welcome Microsoft as the Premier Sponsor at this year's PASS Data Community Summit. The Microsoft team will be a fundamental part of the conference program and activities through educational sessions, product deep-dives and announcements, Microsoft-focused workshops, keynotes, and more. We're excited to continue this relationship in support of the global data community.
2021-08-18
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? Phil Factor explains.
2021-08-16
Using Multiple Azure DevOps Organizations with SQL Source Control
Describing a database version control system using an Azure DevOps-hosted Team Foundation Version Control repo and SQL Source Control, and a workaround for authentication problems when connecting to multiple Azure DevOps organizations.
2021-08-13
3 ways MSPs can offer more value
In the Global State of the MSP Report from Datto, cloud and cybersecurity were identified as two key areas for growth. In this blog we cover three wants Managed Service Providers can offer more value in this areas.
2021-08-11
Managing, Editing and Comparing SQL Code Analysis Settings
If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.
2021-08-06
Using Data Scanning to Identify and Classify Sensitive Columns
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
2021-08-04
Overcoming Database DevOps challenges - Part 1
When integrating database changes into a DevOps process, the biggest challenge is to standardize and coordinate the different approaches to application and database development. Discover the key tools & training resources to help you and your team.
2021-08-02
Blogs
Daily Coping 21 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a...
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Forums
Managed Instance, cross-database queries. What are the hidden requirements?
Have a managed instance with 2 databases. In theory I should be able to...
Need the (default) port to connect - why is this not implicit.
So I have 2 instances (1 x 12, 1 x 19). Both have the...
Extract data from XML field
Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an...
Ask SSC