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.
The database is an important part of any application and setting it up correctly is key to ensuring smooth performance. MySQL, an open-source relational database management system (RDBMS), is widely used in applications ranging from small websites to large enterprise systems. While MySQL is reliable for handling data storage and retrieval, its performance depends heavily...…
The post Introduction to MySQL Shell and Basic Configuration Management (Part 1) appeared first on Simple Talk.
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API development. While Laravel’s popularity lies in its code-centric approach to web development, Frappe simplifies many aspects through configuration and low-code features, making it a suitable choice for rapid application development. This article will be broken...…
The post Frappe’s Configuration vs Laravel’s Code-Centric Customisation appeared first on Simple Talk.
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.
Learn how to encrypt and decrypt SQL Server data using symmetric and asymmetric keys along with several code examples.
In this tip, we show how to create perspectives using Power BI Desktop and Tabular Editor to show only a selection of items to a user.
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on us to determine when to use them based on what they offer. This guide will help you in understanding how views and materialized views work in Snowflake and show you practical examples along with potential...…
The post When Should You Employ Snowflake Materialized Views? appeared first on Simple Talk.
With these various Python examples, learn about linear regression, cost functions, and gradient descent when working with machine learning tools.
Learn how to perform customer churn analysis with Python with a real world example.
What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to get improved into unusable complexity, I’ll need to explain a bit of background. Structured Data Documents come in three different flavors. There are the text files that represent object data, text files that represent tabular...…
The post Data Documents and Common Sense appeared first on Simple Talk.
Learn how to use multi-dimensional arrays when working with Python using the NumPy library.
In this article, we look at how to create an SQL Server database using SSMS and also using T-SQL scripts with several examples.
In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract – transform – load) process. Recently, there has been a shift to ELT processing, where data is first loaded into a data store (this can be a database, but also a data lake or something...…
The post A gentle introduction to dbt appeared first on Simple Talk.
In this article, we look at how to use datasets when developing SQL Server Reporting services reports along with examples.
Many people are confused about monolithic and microservices architectures, and this article will clarify any confusion on the topic.
In this post, we will be checking out the most commonly used oracle tde wallet queries. How to open a TDE wallet in Oracle 12c or 19c Here is how to open a wallet in Oracle 12c or 19c for both CDB and Non-CDB Databases With 12c Non-CDB ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED …
how to open a TDE wallet in Oracle : Status, Open, Close Read More »
The post how to open a TDE wallet in Oracle : Status, Open, Close appeared first on Techgoeasy.
Autotrace is a utility in Oracle that can be used to analyze the execution plan and performance of SQL statements. It is a command-line tool that provides detailed information about how a SQL statement is executed, including the number of rows returned, the amount of time it takes to execute, and the resources used during …
Autotrace Utility in Oracle Read More »
The post Autotrace Utility in Oracle appeared first on Techgoeasy.
Learn about polymorphic associations in SQL Server and how to relate a foreign key reference to multiple SQL Server tables.