MySQL Shell and Basic Configuration Management (Part 2 – Memory and CPU)
Updated: 2025-01-17 20:33:57
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL configurations. We discussed how to install the Shell, connect to the MySQL server, and modify basic configuration parameters. Now, we’re into...…
The post MySQL Shell and Basic Configuration Management (Part 2 – Memory and CPU) appeared first on Simple Talk.
Problem We are currently evaluating Microsoft Fabric to see if it fits our needs. It seems the warehouse might be a bit overkill as it’s more geared towards…
The post What is SQL Database in Microsoft Fabric? appeared first on MSSQLTips.com.
At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have Data Pipelines for the Copy Activity and also a Copy Assistant to help us configure it. What’s new about the Copy Job? Spoiler: It’s much more than a new UI The new Copy Job Object...…
The post Fabric Copy Job: What’s new in it appeared first on Simple Talk.
A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in the standards is to make it behave as much like a base table as possible. Creating a View The syntax of course uses the CREATE keyword because it is persisted in the schema, but not...…
The post VIEW Objects appeared first on Simple Talk.
This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.…
The post I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It appeared first on Simple Talk.
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for storing analytic data when it does not already reside in a native analytic data store, such as a data lake, data warehouse, or an Azure managed service. Both Python and the Parquet file format are...…
The post Customizing the Export and import of Parquet Files in SQL Server appeared first on Simple Talk.
Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution activity. However, every time a data pipelines executes a notebook, it creates a completely new session and spark pool. This makes the Data Pipeline very slow and expensive. How bad it can be Imagine your...…
The post High Concurrency Data Pipelines in Fabric appeared first on Simple Talk.
I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix doesn’t fit every workload or server, but for the limited use cases described below, it’s a simple configuration change. The general best practice for server level configurations is to leave things at default, unless there...…
The post A Use Case for Memory-Optimized Tempdb Metadata appeared first on Simple Talk.
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but understanding where Oracle has been and where it’s going is essential to us building the best products to support this enterprise, robust RDBMS platform. I was disappointed by many of the documents out on the...…
The post Oracle Architecture Overview appeared first on Simple Talk.
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, you know, new beginnings. So here are a...…
The post Five changes to SQL Server I’d love to see appeared first on Simple Talk.