Scalegrid

SEPTEMBER 16, 2019

PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? You can remotely access and navigate another database server. The window-based interface makes it much easier to manage your PostgreSQL data.

Open Source 262

Open Source Database Azure Cloud 262

SQL Performance

JULY 13, 2022

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. This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL.

C++ 112

C++ Code Azure Database 112

Percona

JUNE 23, 2023

I’ll explain using a bad analogy: What type of car is best? But you cannot parallel park it or use it to run down to the store for some chips and beer. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing. ” — with no resolution.

Database 118

Database Transportation Servers Cloud 118

SQL Performance

APRIL 13, 2022

The challenge itself isn’t complicated to handle when using well-known techniques, which primarily employ window functions. Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. The challenge. CREATE TABLE dbo.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

NOVEMBER 13, 2019

The ROW_NUMBER window function has numerous practical applications, well beyond just the obvious ranking needs. Most of the time, when you compute row numbers, you need to compute them based on some order, and you provide the desired ordering specification in the function's window order clause. When order matters.

Servers 104

Servers C++ Storage Performance 104

Scalegrid

JULY 13, 2020

In this article, we compare Oracle vs. PostgreSQL, outlining the differences in these SQL database costs, features, and ease of use for both developers and database administrators (DBA’s) alike. Compare Functionality. Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services.

Open Source 244

Open Source Tuning C++ Database 244

SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. Window frame with implicit RANGE option. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

JANUARY 12, 2022

Use the following code to create the table and populate it with a small set of sample data: DROP TABLE IF EXISTS dbo. Last month , I also provided code that you can use to populate the Auctions table with a large set of sample data, controlling the number of supply and demand entries as well as their range of quantities. Auctions. (

Code 116

Code Servers Performance Azure 116

Percona

DECEMBER 14, 2023

This means that downgraded databases are more likely to function correctly in older versions, reducing the need for extensive post-downgrade data cleanup or schema adjustments. Me : OK, so if I want to downgrade my MongoDB standalone server from version 7.0 what commands should I use? Server: Stop the MongoDB 7.0

Database 84

Database Artificial Intelligence Servers Operating System 84

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is independent of the database, and external tools can be used to achieve this. This is often done to protect sensitive data from unauthorized access or theft. Cluster-level encryption.

Database 93

Database Storage Servers Strategy 93

SQL Performance

FEBRUARY 12, 2020

This month I describe powerful standard NULL handling features that have yet to make it to T-SQL, and the workarounds that people currently use. I'll continue using the sample database TSQLV5 like last month in some of my examples. That's especially the case when you use them to represent missing but inapplicable values.

C++ 120

C++ Code Servers Database 120

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures.

Benchmarking 62

Benchmarking Database Network C++ 62

SQL Performance

APRIL 8, 2020

This article is the first in a series about the fundamentals of table expressions in T-SQL. I will mainly focus on four types of named table expressions, which are known in T-SQL as derived tables, common table expressions (CTEs), views, and inline table-valued functions (inline TVFs). My expertise is T-SQL.

C++ 143

C++ Azure Database Servers 143

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

Percona

JULY 27, 2023

is an evolution of the MySQL server and related software. CURRENT_USER(), USER(), SESSION_USER(), and SYSTEM_USER() can now be used as default values when defining a table. SQL > EXPLAIN FORMAT=JSON INTO @myvar SELECT * FROM City WHERE District='Texas'; Query OK, 0 rows affected (0.0043 sec) SQL > SELECT @myvarG 1.

Servers 81

Servers Open Source Tuning Cache 81

SQL Performance

MARCH 9, 2022

Auctions ( Code , ID ) INCLUDE ( Quantity ) ; -- Enable batch-mode Window Aggregate. Outer joins are fairly commonly used in SQL querying solutions , but by far when you use those, you use single-sided ones. Brian’s solution is a beautiful example of a practical use case of full outer joins.

C++ 138

C++ Code Efficiency Performance 138

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. Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Randon ASCII

OCTOBER 4, 2020

The behavior of the Windows scheduler changed significantly in Windows 10 2004, in a way that will break a few applications, and there appears to have been no announcement, and the documentation has not been updated. This isn’t the first time this has happened , but this change seems bigger than last time.

Programming 145

Programming Games Hardware Operating System 145

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. This feature allows you to nest two kinds of window functions as an argument of a window aggregate function. You can also use nested window functions to easily emulate other features, like RANGE-based frames.

Servers 83

Servers Availability Database Code 83

SQL Performance

JULY 11, 2019

Last year, I got together with one of my dev teams at SentryOne – they call themselves the SQL Injectors – to talk about the possibility of replicating Plan Explorer functionality inside of Azure Data Studio. or newer ( Windows | macOS | Linux ). Connecting to SQL Server 2012 or better, or Azure SQL Database.

Azure 90

Azure Servers Tuning Operating System 90

SQL Performance

OCTOBER 16, 2020

In part 1 and part 2 of this series, I introduced ParamParser : a PowerShell module that helps parse parameter information – including default values – from stored procedures and user-defined functions, because SQL Server isn't going to do it for us. and places it in the same folder as the other files.

Database 62

Database Code Servers Testing 62

SQL Performance

APRIL 18, 2022

It’s more complicated than you might expect to tell from the information provided in execution plans if a SQL statement uses simple parameterization. It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. DisplayName. Users AS U.

Cache 58

Cache Servers Database Testing 58

HammerDB

NOVEMBER 22, 2021

HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. Additionally, using the Active Session History functionality, it is possible to select a previous time period of statistics in the graph and view the PostgreSQL metrics for this earlier period of time.

Metrics 62

Metrics Benchmarking C++ Database 62

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

Testlodge

APRIL 14, 2021

Configuration testing is performed on a system that is consecutively set up using various combinations of configured hardware and software designed to deliver a specific functionality. The three-tier application should have client, server, and database layer, and each part of it needs to work well across the various platforms.

Testing 89

Testing Hardware Virtualization Operating System 89

Percona

JUNE 27, 2023

In addition to the provided SQL functionality, similar to MySQL, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. is highly recommended for use with MySQL Server 8.0 NOTE: Progress information uses estimated values and may not be accurate.

Database 70

Database Open Source Servers Availability 70

Percona

DECEMBER 15, 2022

In this multi-part blog series, we will start with an overview of using JSON in a relational database. And if you try to put in a string to that column of integers the server will refuse to accept that row of data. The server has many functions to extract data efficiently on the server itself.

Database 91

Database Servers Processing Efficiency 91

HammerDB

APRIL 27, 2021

This post is to give anyone starting out with HammerDB a guide on using the CLI or command line interface for text based environments. As the workflow in the CLI and GUI are the same we will show equivalent commands side by side to help you quickly get up to speed on using the CLI in both interactive and scripted scenarios.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions. Persistency.

C++ 109

C++ Database Servers Code 109

SQL Performance

MAY 13, 2020

Last month I provided a background to table expressions in T-SQL. I explained the context from relational theory and the SQL standard. I explained how a table in SQL is an attempt to represent a relation from relational theory. Window functions can appear only in a query's SELECT and ORDER BY clauses.

C++ 143

C++ Code Design Servers 143

HammerDB

NOVEMBER 30, 2022

HammerDB allows you to run the Command Line Interface in both interactive and scripted sessions using a Python interpreter as an alternative to the default Tcl environment on both Linux and Windows. Use a different Browser. $./hammerdbcli Use a different Browser. Use a different Browser. Use a different Browser.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

SQL Performance

DECEMBER 9, 2020

In Part 5 of my series on table expressions I provided the following solution for generating a series of numbers using CTEs, a table value constructor and cross joins: DECLARE @low AS BIGINT = 1001 , @high AS BIGINT = 1010 ; WITH. Testing different base table cardinalities is just one dimension to try. basecardinality , POWER ( 2.,

C++ 114

C++ Servers Testing Processing 114

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions. Persistency.

C++ 93

C++ Database Servers Code 93

SQL Performance

JULY 1, 2019

The ANY aggregate is not something we can write directly in Transact SQL. It is an internal only feature used by the query optimizer and execution engine. The idea is to number the input set of rows using the ROW_NUMBER window function, partitioned by the grouping column or columns. Numbered AS. ( ORDER BY D.

C++ 58

C++ Servers Database Performance 58

Percona

AUGUST 17, 2023

What is PostgreSQL used for? It’s used for data management (shocker), application development, and data analytics. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). Is PostgreSQL enterprise-ready?

Open Source 76

Open Source Healthcare Social Media Database 76

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. I posted a suggestion to improve SQL Server by adding support for RPR in T-SQL , but I was quite limited in the space that I had to provide the feedback. Background.

C++ 73

C++ Virtualization Servers Code 73