Ingesting Data from Google Drive to Azure Data Lake Gen2 ...
The post Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory appeared first […]
sqlservercentral.com
Backup Directly to a GCS Bucket in SQL Server 2022
SQL 2022 is here! Lets back up our databases directly to GCS! This new release of SQL Server […]
Dealing with Mutually Dependent Databases in Flyway
The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.
Encrypt SQL Server Stored Procedures to Protect Source Code
The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.
Publishing a Public Power BI Report from Google Sheets
I find Power BI to be a neat way to visualize data, one that allows interactivity to help […]
Dealing with Cross-Server Database Dependencies in Flyway Projects
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.
Configure Contained Availability Groups for High Availability in SQL Server ...
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.
Dynamic ELT with Azure Data Factory – Part 3 of ...
In Part 1 of this series, we talked about the art of data ingestion where we discussed the […]
DevOps Process Improvement Course
The post DevOps Process Improvement Course appeared first on SQLServerCentral.
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python […]
A Version Control Strategy for Database DevOps
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, […]
Technical Considerations for Data Ingestion – Part 2
In part one of this series, we discussed how to prepare for the ingestion of data. In this […]
Understanding Windows Server Cluster Quorum Options
The post Understanding Windows Server Cluster Quorum Options appeared first on SQLServerCentral.
How to work with web information, maps, and images in ...
Introduction Sometimes, we need to work with images in Power BI. This tip will be about the FIFA […]
Bucket Sort Algorithm in Python to Sort a List of ...
The post Bucket Sort Algorithm in Python to Sort a List of Array Values appeared first on SQLServerCentral.
Database Sharding to help Improve Performance and Maintenance Tasks
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.
Using pre-commit to prevent simple mistakes
There is no level of experience or intelligence where we cease to make mistakes. The simpler the mistake […]
How to Create a Box and Whisker Plot in Power ...
The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.
Translate Text Data using Azure Cognitive Services
Executive Summary Microsoft Azure has several capabilities, including support for Machine Learning (ML) and Artificial Intelligence (AI). One […]
Useful Commands for Snowflake Transactions
The post Useful Commands for Snowflake Transactions appeared first on SQLServerCentral.
How to Create a Power BI report using MySQL data
Introduction In this article, we will learn to create a Power BI report using MySQL data. The article […]
Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools
The post Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools appeared first on SQLServerCentral.
Using sp_prepare and sp_execute to utilize prepared SQL statements
The post Using sp_prepare and sp_execute to utilize prepared SQL statements appeared first on SQLServerCentral.
Cross-RDBMS Code Quality Reports in Flyway
The post Cross-RDBMS Code Quality Reports in Flyway appeared first on SQLServerCentral.
Ethical Hacking Tutorial
Are you afraid of the word hacking? Ironically, it is legal hacking that is benefiting us. If this […]
Setting up for Team-based Database Development using Flyway Desktop
The post Setting up for Team-based Database Development using Flyway Desktop appeared first on SQLServerCentral.
The Importance of a Good Data Model in Power BI ...
The post The Importance of a Good Data Model in Power BI Desktop appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022 Part 3
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This […]
Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
The post Secure File Transfer Protocol (SFTP) support for Azure Blob Storage appeared first on SQLServerCentral.
Enabling digital transformation – and data modernization – with DevOp
The post Enabling digital transformation – and data modernization – with DevOp appeared first on SQLServerCentral.
Executing Optional Code in Flyway Callbacks
The post Executing Optional Code in Flyway Callbacks appeared first on SQLServerCentral.
The Lock Escalation Threshold – Part 3
The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.
Building a SQL Computational Framework for MACD Indicators
The post Building a SQL Computational Framework for MACD Indicators appeared first on SQLServerCentral.
Flyway Desktop in Database Development Work: An Overview
The post Flyway Desktop in Database Development Work: An Overview appeared first on SQLServerCentral.
Heapq Module in Python: Using Heaps and Priority Queues
The post Heapq Module in Python: Using Heaps and Priority Queues appeared first on SQLServerCentral.
Maintaining a Utilities Schema in a Flyway Project
The post Maintaining a Utilities Schema in a Flyway Project appeared first on SQLServerCentral.
Artificial Intelligence with Power BI
Executive Summary Artificial intelligence is transforming businesses across the world. There are several tools and technologies to realize […]
SSIS Bad Habits: Decreasing SSIS Package Performance
The post SSIS Bad Habits: Decreasing SSIS Package Performance appeared first on SQLServerCentral.
Setting SQL Deadlock Priority to Control the Transaction that is ...
The post Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back appeared first on SQLServerCentral.
Deploy and Configure Azure SQL Managed Instance
The post Deploy and Configure Azure SQL Managed Instance appeared first on SQLServerCentral.
How to create a Power BI report using REST API ...
Introduction In this article, we will learn how to create a Power BI report using a REST API. REST […]
Reviewing SQL Migration Files Before a Flyway Migration
The post Reviewing SQL Migration Files Before a Flyway Migration appeared first on SQLServerCentral.
Automate Power BI desktop data model with a PowerShell script
Waiting for PBI desktop « working on it » When you know the host and port of SSAS Tabular instance, […]
Exploring Hive Tables with Spark SQL
The post Exploring Hive Tables with Spark SQL appeared first on SQLServerCentral.
New DevOps Process Improvement Course
The post New DevOps Process Improvement Course appeared first on SQLServerCentral.
The Enterprise Roadmap to Reducing Costs (While Increasing Value)
The post The Enterprise Roadmap to Reducing Costs (While Increasing Value) appeared first on SQLServerCentral.
Connect to SQL Server with Python to Create Tables, Insert ...
The post Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String appeared […]