SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. This release includes a number of additional interesting T-SQL improvements, which include: The distinct predicate.

Servers 142

Servers Testing C++ Code 142

SQL Performance

NOVEMBER 10, 2021

Last month I explained when SQL Server inlines iTVFs, it applies parameter embedding optimization by default. Parameter embedding means SQL Server replaces parameter references in the query with the literal constant values from the current execution, and then the code with the constants gets optimized. Constant Folding.

Cache 121

Cache Servers Code Database 121

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. This streamlined process reduces the risk of errors and simplifies the downgrade procedure. implemented improved data integrity checks during the downgrade process.

Database 88

Database Artificial Intelligence Servers Operating System 88

SQL Performance

MARCH 11, 2020

In the previous articles ( Part 1 , Part 2 , and Part 3 ), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that are not yet available in T-SQL. This article is Part 4 in a series about NULL complexities.

C++ 135

C++ Code Servers Database 135

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or APT, it’s easy to manage MySQL with systemctl, but how will you manage it when you install from the generic binaries? Why do you need multiple instances on the same server?

Programming 86

Programming Servers Database Hardware 86

Dynatrace

JULY 7, 2022

Dynatrace news. Many organizations are taking a microservices approach to IT architecture. It’s easy to see why, with benefits such as better testing, easier deployment, faster performance, and more. But nothing is perfect — and microservices is no exception. What is the monolithic architecture approach? Common problems with monolithic architecture.

Architecture 208

Architecture Serverless Azure Programming 208

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ).

C++ 109

C++ Database Servers Code 109

Particular Software

OCTOBER 6, 2020

This is a fairly common pattern for sagas to implement, and we didn’t want our customers to have to change how they model their business process to get around a performance problem, so we decided to fix it. You need a business process to send 1,000 emails, and at the end, report back how many were sent successfully.

Strategy 98

Strategy Database Infrastructure Design 98

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ).

C++ 93

C++ Database Servers Code 93

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. This blog was originally published in November 2021 and was updated in September 2023. What is a Trigger in MySQL?

Cache 61

Cache Database Games Healthcare 61

Dynatrace

APRIL 16, 2019

Many of our customers also run their.NET, ASP.NET,NET Core, SQL Server, CRM, SharePoint … applications on AWS and have reached out to us in the past to ask about best practices around optimizing these workloads in order to run more efficiently and more cost effective. Step #1: Install Dynatrace. Install OneAgents on your EC2 machines.

AWS 128

AWS Best Practices Database Traffic 128

SQL Performance

SEPTEMBER 9, 2020

I describe T-SQL’s support for recursive CTEs, as well as standard elements that are not yet supported by T-SQL. I do provide logically equivalent T-SQL workarounds for the unsupported elements. A classic category of uses has to do with handling of graph structures, like our employee hierarchy. Employees ; GO.

C++ 143

C++ Code Servers Availability 143

HammerDB

FEBRUARY 25, 2021

All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). As we have seen databases are designed to handle multiple database sessions at the same time. For HammerDB both TPROC-C and TPROC-H run all of their workloads on the database being tested in SQL. Basic Benchmarking Concepts.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

AUGUST 15, 2023

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52

Servers Database Availability Traffic 52

SQL Performance

JULY 13, 2022

Generally in life, it’s good to have the perfect tools to handle any given task. The same goes specifically for handling T-SQL querying tasks in terms of supported language elements. T-SQL, the dialect, supports a subset of the features from standard SQL. So you have to come up with a supported alternative.

C++ 112

C++ Code Azure Database 112

Percona

NOVEMBER 1, 2023

Understanding the importance of MySQL backups and how they can reduce these risks will help organizations guarantee data consistency, business continuity, and the assurance that their data is safe and recoverable when needed. The key question related to RTO is, “How quickly must the data on this system be restored?”

Best Practices 80

Best Practices Storage Strategy Database 80

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. © ​​ 2004 Microsoft Corporation. .

Servers 40

Servers Cache Media Hardware 40

SQL Performance

APRIL 5, 2019

The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts. When IGNORE_DUP_KEY is OFF , the first duplicate encountered results in an error , and none of the new rows are inserted. Article Summary.

Storage 53

Storage Servers Engineering Testing 53

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40

SQL Performance

APRIL 14, 2021

I keep being shocked by his discoveries, and wonder how the heck he figures out what he does. I keep being shocked by his discoveries, and wonder how the heck he figures out what he does. This is the fourth part in a series about solutions to the number series generator challenge. I love Paul White ’s work. DROP TABLE IF EXISTS dbo.

C++ 112

C++ Servers Testing Code 112

SQL Performance

JANUARY 8, 2020

Last month I introduced the NULL as SQL's marker for any kind of missing value. I explained that SQL doesn't provide you with the ability to distinguish between missing and applicable (A-values) and missing and inapplicable (I-values) markers. This article is the second in a series on NULL complexities.

Design 65

Design C++ Code Database 65

SQL Server According to Bob

JANUARY 24, 2017

In my last post I highlighted the marriage of PE and ELF images within the same process space to build SQL Server on Linux. The dbgbridge (Debugger Bridge) is a critical component in the SQL Server on Linux evolution. As you would imagine, the ability to debug SQL Server on Linux, end-2-end, was among the top of our list.

Servers 40

Servers Open Source Software Engineering Processing 40

SQL Performance

APRIL 22, 2020

In part 1 of this series, I explained how I arrived at the conclusion that we should disable the default trace. FROM src ; Now, when someone wants to review recent file size change events on any server, they run: SELECT < cols > FROM UtilityDatabase. Digestible views. Digestible views. vwFileSizeChanges. EndTimeUTC = x.

Database 55

Database Servers Availability Monitoring 55

Enprowess

OCTOBER 7, 2021

This testing confirms user interface, database APIs, Client/Server communication, security, and other app features under test. 8 Functional Testing types. This blog will explain each functional testing type and when it should be performed during the software development life cycle. What is Functional testing?

Testing 52

Testing Software Software Systems 52

Smashing Magazine

APRIL 1, 2020

With a traditional CMS, changes can be time-consuming, for example, to tweak a part of your site, you need to re-implement the entire CMS. Blessing Krofegha. 2020-04-01T11:30:00+00:00. 2020-04-01T14:46:06+00:00. In this tutorial, you’ll learn what Headless CMS is, and the pros and cons of Headless CMS. and GraphQL queries.

Open Source 103

Open Source Website Mobile Code 103

Sutter's Mill

MARCH 11, 2024

In that context, I’ll focus on C++ and try to: highlight what needs attention (what C++’s problem “is”), and how we can get there by building on solutions already underway; address some common misconceptions (what C++’s problem “isn’t”), including practical considerations of MSLs; and leave a call to action for programmers using all languages.

C++ 139

C++ Programming Code Java 139

The Symphonia

DECEMBER 13, 2017

that it will automatically scale a thousand or more instances wide to handle incoming load. —?that that it will automatically scale a thousand or more instances wide to handle incoming load. A thousand-times scaled Lambda could easily cause significant performance problems to a modest SQL database server.

Lambda 40

Lambda AWS Architecture Database 40

Alex Russell

JUNE 20, 2020

The web is a meta-platform. Like other meta-platforms the web thrives or declines to the extent it can accomplish the lion's share of the things we expect most computers to do. Adjacency to the current set of capabilities provides a disciplined way to think about where to invest next when working to stave off irrelevance. Chromium's Project Fugu ??

Hardware 55

Hardware Games Java Media 55

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query.

Efficiency 40

Efficiency Code Servers Cache 40

O'Reilly

MARCH 23, 2023

What is it, how does it work, what can it do, and what are the risks of using it? It’s clear that ChatGPT is not your run-of-the-mill automated chat server. It’s clear that ChatGPT is not your run-of-the-mill automated chat server. A quick scan of the web will show you lots of things that ChatGPT can do. It’s much more.

Google 104

Google Open Source Programming Code 104