The nuances of MySQL indexes
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.
2022-05-16
Additional Articles
Webinar: Introducing Database DevOps
Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.
2022-05-16
Summit Learning Pathways Announced
Whatever your learning objectives or career goals are, Summit has the guided learning pathways you need to achieve them. Summit attendees can choose from 9 learning pathways, featuring over 40 industry-leading speakers, which have been designed to walk you through a specific set of learning outcomes to ensure that you leave Summit with the skills you need to make an immediate impact in your organization. Presenters include Ginger Grant, John Morehouse, Erin Stellato, Dustin Vannoy, and many more!
2022-05-13
The ins and outs of joining tables in SQL Server
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.
2022-05-13
A MySQL story: Can system engineers solve database issues using system tools?
A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan
2022-05-11
DevOps 101: Introducing Database DevOps
Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.
2022-05-11
Flyway How-tos: a User’s Perspective
Flyway provides a database-independent way for a team to track, manage and apply database changes, while maintaining strict control of database versions. It updates a database by running a series of versioned migration scripts, in order, and keeps track of all the changes in a special "schema history" table. It sounds simple, but it is easy to derail this team discipline if you don't find the right answers to the following questions…
2022-05-09
Working with Firebase Version 9 Modular SDK and React Typescript
Firebase is a SaaS platform that provides developers with many services to improve productivity and reduce build time. In this article, Goodness Woke demonstrates working with Firebase Version 9 and React Typescript.
2022-05-09
Database Development Visibility using Flyway and PowerShell
The payback of DevOps is not simply in automation but in using that automation to increase the visibility of the development processes. This article demonstrates way to make Flyway developments more visible, regardless of your RDBMS, such as by providing a detailed migration history, and change reports that reveal detail of what is going on to all involved.
2022-05-06
How to automate table level refresh in Power BI
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.
2022-05-06
Blogs
SQL Saturday Jacksonville Slide Decks
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
Power BI connectors to Azure Synapse
By James Serra
When using Power BI and pulling data from Azure Synapse, you will use the...
Snowflake + Azure Privatelink
By MAMIR
Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...
Forums
Filetred index
\hello Guys, Mayyou help wuth the corect index filetred creation using modulo? ...
Monitor SQL Server Job Failures
Ahoi, i am usually working with SSIS and SSAS, but since there is no...
DateDiff - Data Type conversion Issues
Hi Experts Not able to do DATEDIFF between two dates, but it works when...
Ask SSC