Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. Our yml file: development: # Configure available database clients. The user's database roles. The user's database roles.

C++ 100

C++ Servers Database Network 100

Dynatrace

APRIL 15, 2022

The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud. ” Despite many challenges, when the project concluded in 2019, the team had the confidence and experience to migrate anything to the cloud.

Cloud 174

Cloud Infrastructure Innovation Monitoring 174

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. of enterprise organizations on average.

Strategy 182

Strategy Cloud Java Open Source 182

SQL Performance

FEBRUARY 1, 2022

This is done to make managing operations in the transaction log easier for the log manager in SQL Server. You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it.

Architecture 53

Architecture Servers Virtualization Database 53

Dynatrace

JANUARY 20, 2020

Having released this functionality in a Preview Release back in October 2019, we’re now happy to announce the General Availability of our SAP ABAP real user monitoring. Aggregated T-code scorecards give you immediate insights (for example, the slowest performing T-code) so you always know where to look first. Dynatrace news.

Monitoring 152

Monitoring Performance Infrastructure Network 152

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries.

C++ 140

C++ Servers Code Efficiency 140

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

SQL Performance

OCTOBER 13, 2021

In my examples I’ll use a sample database called TSQLV5. Like views, iTVFs are created as a permanent object in the database, and therefore are reusable by users who have permissions to interact with them. Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO.

Cache 144

Cache Strategy C++ Code 144

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. 2019-04-29T18:34:58+00:00. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. The Server Timing Header. Drew McLellan.

Servers 87

Servers Performance Metrics Database 87

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js TL9 SP9 as well as massive improvements in OneAgent deployment and automatic instrumentation of technologies with deep code monitoring modules. TL9 SP9 as well as massive improvements in OneAgent deployment and automatic instrumentation of technologies with deep code monitoring modules.

Java 101

Java Traffic AWS Monitoring 101

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Votes AS V.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

OCTOBER 7, 2020

If you’re interested in table-valued function rewinds, please see my Q & A on Database Administrators Stack Exchange. The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database). Sort Rewinds.

Servers 106

Servers Cache Azure Performance 106

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. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

Dynatrace

APRIL 5, 2021

Similar to AWS Lambda , Azure Functions is a serverless compute service by Microsoft that can run code in response to predetermined events or conditions (triggers), such as an order arriving on an IoT system, or a specific queue receiving a new message. Dynatrace news. What is Azure Functions? The growth of Azure cloud computing.

Azure 136

Azure Serverless IoT Lambda 136

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. DROP TABLE IF EXISTS dbo. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. That community spans expertise and industries, putting diverse skill sets and fresh perspectives into the review and improvement of code.

Open Source 80

Open Source Healthcare Social Media Database 80

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5. This code generates the following output: 2021-02-12 00:00:00.0000000. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. The main benefit of the PIVOT operator is that it tends to result in shorter code. Implicit grouping with PIVOT. So you're expecting to see only three rows in the result.

Best Practices 103

Best Practices C++ Code Design 103

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access.

Virtualization 80

Virtualization Speed Database Efficiency 80

Particular Software

JANUARY 27, 2020

Microsoft Message Queuing, better known by its nickname MSMQ, passed away peacefully in its hometown of Redmond, Washington on October 14, 2019, at the age of 22. Since it exists in Windows 10 and Windows Server 2019, MSMQ will continue to live on until at least 2029—and much longer assuming it isn't removed from future versions of Windows.

Transportation 98

Transportation Azure Open Source Systems 98

The Morning Paper

JULY 11, 2019

View-centric performance optimization for database-backed web applications Yang et al., A web page instrumented by Panorama looks like this: Parts of the page are colour-coded heat-map style to indicate how costly they were to generate. Cost estimation. cant portion of the page load time. (In

Database 47

Database Performance Speed Servers 47

Percona

APRIL 13, 2023

was released in August 2019. Since Percona Server for MongoDB (PSMDB) is a fully compatible replacement for the upstream MongoDB Community Edition, we try to follow the same EOL date as the upstream vendor. Don’t leave your database vulnerable because this version has gone on to the database software wasteland.

Servers 70

Servers Database Processing Systems 70

Dynatrace

MAY 6, 2019

We recently introduced several code modules that provide out-of-the-box code-level insight for each mainframe transaction. Here’s what you can do with our GA code modules for z/OS: Gain insight into the CICS Transaction Server on z/OS with our CICS code module. In-depth analysis at the source-code level.

Java 116

Java Programming Technology Technology 116

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Dynatrace

JULY 3, 2019

For instance, if a problem is caused by incorrect data returned by the server, Dynatrace full-stack insights can be used to follow the problem through the entire stack down to the single line of code or database statement. Usability analytics with rage clicks will be publicly available towards the end of June, 2019.

Analytics 120

Analytics Tuning Mobile Monitoring 120

Scalegrid

MAY 2, 2019

It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements. It is also recommended that SSL connections be enabled to encrypt the client-database traffic. Testing Failover Behavior.

Testing 55

Testing Network Database Servers 55

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. According to the standard, you would use the following code with the DISTINCT predicate to handle this need: SELECT orderid , shippeddate FROM Sales.

C++ 120

C++ Code Servers Database 120

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. Web scraping is a way to grab data from websites without needing access to APIs or the website’s database. When building our scrapers, we also need to make sure that we do not overwhelm a server with requests that it can’t handle. We’ll start with a basic spider.

Scalability 87

Scalability Website C++ Servers 87

SQL Performance

MARCH 29, 2022

When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. The bigint type isn’t used for server-side parameterization.

Cache 90

Cache Servers Database Testing 90

Percona

MARCH 7, 2019

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. In other words, the time the CPU was executing user code, such as MySQL. There could be more, but this particular query was definitely hurting the performance of the server.

C++ 101

C++ Traffic Servers Monitoring 101

Scalegrid

AUGUST 15, 2019

In this article, we are going to compare 6 of the top MongoDB Graphical User Interfaces that help developers increase their productivity and manage their database. Read on to find out which is the best MongoDB GUI for you, updated for 2019, that contain these key features: A good visual editor to write and edit queries faster.

Database 40

Database Servers Monitoring Availability 40

Smashing Magazine

MAY 5, 2021

Usually, the HTML code size is not a big issue, especially for small pages, not data-intensive, or pages that are not SEO-oriented. However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. Now it kicks into play in the server. React got the data.

Google 110

Google Architecture Servers Speed 110

SQL Performance

SEPTEMBER 6, 2022

Let’s look at some examples using a fresh database. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists.

Database 98

Database Storage Testing Servers 98