In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.

Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.
The post Using pre-commit to prevent simple mistakes appeared first on SQLServerCentral.

In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.

Learn the basics of the Text Translation services in Azure Cognitive Services.
The post Translate Text Data using Azure Cognitive Services appeared first on SQLServerCentral.

A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.
The post Subqueries in MySQL appeared first on SQLServerCentral.

In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
The post Useful Commands for Snowflake Transactions appeared first on SQLServerCentral.

Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]
The post How to Create a Power BI report using MySQL data appeared first on SQLServerCentral.

If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, many cannot.
The post Converting Data Across Time Zones: An In-Depth Primer appeared first on SQLServerCentral.