Flyway with MariaDB for Those of a Nervous Disposition
The post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral.
Views in SQL Server 2019 with SSMS
In SQL Server, a view is a virtual table with contents that you define by means of a query. The structure of a view is similar to a table. The contents of a view comprise a set of named columns and rows of data, that are generated dynamically whenever …
CData Connect: Derived Views and Query Federation
Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through vi …
Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow
The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral.
Bulk Loading Data via a PowerShell Script in Flyway
The post Bulk Loading Data via a PowerShell Script in Flyway appeared first on SQLServerCentral.
The SQL Server Posts You Read the Most in 2021
I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to b …
[Video] Office Hours: SQL Server at Sunset
Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: https://youtu.be/hwRAwhcgCGU Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How t …
Unity state machine behaviours
The post Unity state machine behaviours appeared first on SQLServerCentral.
Adding Test Data to Databases During Flyway Migrations
The post Adding Test Data to Databases During Flyway Migrations appeared first on SQLServerCentral.
Check Your SQL Server Backup Performance & Safety with sp_BlitzBackups
Out of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you’ve used the least. Let’s talk about what comes out of it, and why you should use it more often. First, let’s define two terms: Recovery …
Why cloud and hybrid estates are important – but bring complexity
The post Why cloud and hybrid estates are important – but bring complexity appeared first on SQLServerCentral.
Is SQL Server Profiler in Azure Data Studio?
Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS and Azure Data Studio. Now we will compare the new SQL Profiler against the old one. If you check the SQL Server Profiler documentation, you will fin …
Working with PowerShell strings
The post Working with PowerShell strings appeared first on SQLServerCentral.
Performance Tuning Using Free Tools
Do you frequently upgrade your on-premises hardware in order to keep a certain level of performance? Are your Azure SQL bills bigger than you expected? Are your databases wasting money through inefficiency? You can keep expenses under control by improv …
Did you know SQL Monitor supports Azure databases, too?
The post Did you know SQL Monitor supports Azure databases, too? appeared first on SQLServerCentral.