High Scalability

JUNE 27, 2019

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy?

Open Source 196

Open Source Database Cloud Strategy 196

SQL Shack

NOVEMBER 23, 2021

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93

Servers Cache Availability Performance 93

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

SQL Shack

NOVEMBER 23, 2020

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 76

Tuning Servers Database Development 76

KeyCDN

MARCH 14, 2019

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. It can be used to decouple your frontend from your backend and improve server efficiency.

Development 101

Development Blockchain Serverless Social Media 101

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Redis on Azure service. PALO ALTO, Calif.,

Azure 37

Azure Cloud Open Source Virtualization 37

SQL Shack

NOVEMBER 25, 2019

In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Let’s have a quick recap of the table variable: We can define a table variable and use it similar to a temporary table with few differences. The table […].

Servers 87

Servers Development Performance 87

SQL Shack

MAY 27, 2020

In this article, we will explain batch mode on rowstore feature, which was announced with SQL Server 2019. The main benefit of this feature is that it improves the performance of analytical queries, and it also reduces the CPU utilization of these types of queries.

Servers 64

Servers Analytics Performance Performance Testing 64

Scalegrid

JUNE 6, 2019

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191

AWS Cloud Open Source Virtualization 191

SQL Shack

JULY 10, 2019

By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude. Introduction In-memory technologies are one of the greatest ways to improve performance and combat contention in computing today.

Servers 79

Servers Latency Storage Speed 79

SQL Performance

JANUARY 10, 2020

Earlier this week, Microsoft announced SQL Server 2019 Cumulative Update #1. To download: For Windows, you can always download the latest 2019 CU here. To update your local Docker image: docker pull mcr.microsoft.com/mssql/server: 2019 -latest. The build number is 15.0.4003.23 and there are 83 fixes !

Servers 52

Servers Testing Processing 52

High Scalability

FEBRUARY 1, 2019

ludovicc : We spent many years to remove stored procedures and put business logic in an application server, why do you want to go back to that? Glacier is cheap because it isn't "always ready" storage. and if/when you REALLY need the data, you're gonna be waiting a long time. Nice idea for fast prototyping though.

Internet 146

Internet Internet Scalability Games 146

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. PALO ALTO, Calif., The ScaleGrid platform allows PostgreSQL users to automate their daily operations without having to sacrifice control over their deployments.

Azure 182

Azure AWS Open Source Database 182

Dynatrace

NOVEMBER 19, 2021

This eliminates certain timeout issues with Windows Server 2019 at boot. Problems API v2 now includes event evidence data as part of the event details. With this release, svchost.exe is excluded from injection. This opens the **Add new SLO ** page already filled in with the settings from the cloned SLO.

Metrics 218

Metrics Monitoring Traffic Servers 218

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […].

Servers 69

Servers Availability Virtualization Infrastructure 69

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. autovacuum may have trouble keeping up on a busy server.

Strategy 182

Strategy Cloud Java Open Source 182

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

SQL Performance

OCTOBER 14, 2020

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. Substitution/unnesting. Figure 4: Execution plan for Query 4.

C++ 140

C++ Servers Code Efficiency 140

Scalegrid

JULY 13, 2020

Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. In fact, PostgreSQL is so popular, 11.5% Oracle does offer discounts on their pricing, where you can receive a 10% discount if you purchase online.

Open Source 244

Open Source Tuning C++ Database 244

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 88

Servers Performance Metrics Database 88

The Netflix TechBlog

FEBRUARY 3, 2021

Fitting into the GraphQL Server Ecosystem So how exactly does the DGS framework fit into the existing GraphQL ecosystem? The current ecosystem comprises servers, clients, the federated gateways, and tooling to help with query testing, schema management, code generation, etc.

Open Source 246

Open Source Java Architecture Metrics 246

Dynatrace

MAY 3, 2019

Detected incidents are automatically mapped to existing servers. One of those improvements is the simplified mapping of Dynatrace detected incidents to existing servers within your CMDB. A name lookup is used to check for existing servers within your CMDB whenever Dynatrace reports an incident.

Servers 23

Servers Technology Technology Processing 23

The Netflix TechBlog

MARCH 21, 2019

A researcher found an application that ran on an older Windows server that was deployed in a non-standard way making it difficult for our automated visibility services to detect it. In 2019, we also started publishing quarterly program updates to highlight new product areas for testing.

Entertainment 166

Entertainment Programming Internet Internet 166

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. Dynatrace news. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 156

Monitoring Best Practices Infrastructure Servers 156

SQL Shack

JULY 13, 2020

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases.

Servers 69

Servers Availability Database 69

SQL Performance

OCTOBER 7, 2020

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). The post When Do SQL Server Sorts Rewind? History and my explanation. Perhaps you will find the information useful one day too.

Servers 106

Servers Cache Azure Performance 106

Dynatrace

JUNE 9, 2021

A web application is any application that runs on a web server and is accessed by a user through a web browser. According to the 2019 Verizon Data Breach Investigations Report, web application attacks were the number one type of attack. What is web application security? Why is web application security important?

Open Source 187

Open Source Entertainment Tuning Internet 187

SQL Shack

JULY 13, 2020

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In this article, we […].

Availability 77

Availability Servers Virtualization Network 77

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. Servers provided as seeds that do # not belong to this replica set will be ignored. Whether to connect to the servers via ssl.

C++ 100

C++ Servers Database Testing 100

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit.

Serverless 88

Serverless Architecture FinTech Infrastructure 88

SQL Performance

MARCH 31, 2020

SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The post SQL Server 2019 Cumulative Update #4 appeared first on SQLPerformance.com. The build number is 15.0.4033.1.

Servers 40

Servers Availability 40

SQL Performance

MARCH 13, 2020

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The post SQL Server 2019 Cumulative Update #3 appeared first on SQLPerformance.com. The build number is 15.0.4023.6.

Servers 40

Servers Availability 40

SQL Performance

FEBRUARY 13, 2020

SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. The post SQL Server 2019 Cumulative Update #2 appeared first on SQLPerformance.com. Build # is 15.0.4013.40.

Servers 40

Servers Availability 40

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 189

Cloud Infrastructure Innovation Monitoring 189

SQL Shack

MAY 13, 2020

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019. We will also discuss reasons and the solution method of these latch contention issues.

Database 68

Database Servers Performance Testing Testing 68

Dynatrace

JANUARY 15, 2020

Having released this functionality in an Preview Release back in September 2019, we’re now happy to announce the General Availability of our Citrix monitoring extension. Citrix is a sophisticated, efficient, and highly scalable application delivery platform that is itself comprised of anywhere from hundreds to thousands of servers.

Latency 37

Latency Performance Virtualization Infrastructure 37