Power BI CONCATENATE Function: How and When to Use it
In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.
2021-11-26
Articles
Tracking SQL Server Configuration Across All Your Servers Using SQL Monitor
The Estate Configuration reports SQL Server configuration across all your servers, so you can quickly investigate ad-hoc or unauthorized changes to any settings that might affect their performance, stability, or security.
2021-11-24
Using Power Apps Patch Function with SQL Server
In this article we look at how to create a basic Power App that allows saving data to a database table.
2021-11-24
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.
2021-11-23 (first published: 2008-08-19)
127,222 reads
A Comparison of Database Drivers for MySQL
MySQL is "The world's most popular open source database" and it is widely-used to store and access your data. In fact, there are many cloud and on-premise databases (like MemSQL and Google Cloud SQL) that use the MySQL interface. Several native, open-source drivers are available for connecting to your MySQL data from other applications. In […]
2021-11-22
981 reads
Working with an Azure Data Factory Meta-data Driven Pipeline
This article shows how to create a data driven ADF pipeline.
2021-11-22
6,277 reads
Learn how to use Flyway for Automated Database Migrations
Here's your one-stop-shop for Flyway learning resources, curated by Tony Davis. Check out this handy learning pathway for managing and automating database deployments, from version control, using Flyway.
2021-11-22
Ransomware: A world under threat
Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware and what needs to be done to protect against it.
2021-11-22
SQLFacts - A Free Toolkit for SQL Server Database Engineers
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
9,741 reads
CRUD Operations on a SharePoint List using Python
This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.
2021-11-19
Blogs
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
Forums
Issues with SQL Server 2022 Server
Hello, At my work place I recently migrated our test environment to SQL Server...
Remote query is taking 99% cost of local sp execution
So we have local sp in which remote table is udpated.this remote query part...
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers