SQL Performance

AUGUST 2, 2019

From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Some information is available in the SQL Server 2019 release notes , and there was a demo from Bob Ward and Conor Cunningham during the first day of the PASS Summit keynote. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

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

NOVEMBER 1, 2019

I helped Bob Ward ( @bobwardms ) with technical editing for his most recent book, " SQL Server 2019 Revealed ," and have been actively engaged with the product teams and my MVP peers throughout the CTP and RC cycles. Accelerated Database Recovery is in Standard Edition. Transparent Data Encryption (TDE) is now in Standard Edition.

Servers 40

Servers Hardware Database Availability 40

Alex Podelko

APRIL 18, 2021

Blog post from April 30, 2019, Reducing variability in performance tests on EC2: Setup and Key Results , address that specific issue. The paper Creating a Virtuous Cycle in Performance Testing at MongoDB and pre-recoded video are already available. The latest update will be presented at ICPE 2021 by David Daly on April 21, 2021.

Performance Testing 182

Performance Testing Performance Testing Education 182

Scalegrid

JUNE 18, 2019

The connection options available for the driver are documented here , and the options we will need are: :ssl. First, find and copy your MongoDB connection string from the cluster details page on the ScaleGrid console: The CA certificate file is also available for download from the cluster details page. The user's database roles.

C++ 100

C++ Servers Database Network 100

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. SAP database performance: Query response time, percentage of time spent in the database, and the number of database calls executed by the SAP server.

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

MachMetrics

DECEMBER 27, 2019

It is one of the most complete “state of the web” reports currently available. TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes. The post Year in Web Performance: 2019 appeared first on MachMetrics Speed Blog. First Input Delay.

Performance 52

Performance Speed Website Mobile 52

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. How-to documentation is readily available. It’s well-suited for organizations that require mission-critical applications with high availability.

Open Source 76

Open Source Healthcare Social Media Database 76

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js client is now generally available. in November 2019 as it reached end-of-life on June, 27th 2019. support has been extended and will reach end-of-life in November 2019. and lower (End of maintenance support by Red Hat ended in July 2019). Dynatrace news.

Java 101

Java Traffic AWS Monitoring 101

Dynatrace

MAY 9, 2019

supports the tracing of database requests.NET. support has been extended and will reach end of life in November 2019. support will reach end of life in April 2019. x—(Pivotal support for this version ended in April 2019. We’re happy to announce the general availability of Cloud Foundry monitoring integration.

Java 100

Java AWS Cloud Monitoring 100

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Dynatrace

APRIL 15, 2022

” Despite many challenges, when the project concluded in 2019, the team had the confidence and experience to migrate anything to the cloud. VA also used Dynatrace to instrument its Consolidated Mail Outpatient Pharmacy Application, a mission-critical app with a heavily distributed database hosted in seven locations across the U.S.

Cloud 176

Cloud Infrastructure Innovation Monitoring 176

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. Was it the server, the network, or the database that caused the degraded response time? Support and availability. Dynatrace news.

Monitoring 153

Monitoring Performance Infrastructure Network 153

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. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

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. Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. NULL as a marker for a missing value.

Best Practices 117

Best Practices C++ Database Code 117

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

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

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. 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.

Azure 139

Azure Code Database Servers 139

The Netflix TechBlog

OCTOBER 15, 2019

No need to acquire locks on tables, which is essential to ensure that the write traffic on the database is never blocked by our service. High availability, via standby instances across AWS Availability Zones. Historically, message publishing at Netflix is optimized for availability instead of durability (see a previous blog ).

Transportation 192

Transportation Architecture Processing Storage 192

Dynatrace

MAY 6, 2019

For IBM CICS and IMS SDK, avail of the SDK with our CICS and IMS code modules, which allows you to seamlessly integrate customized technologies (e.g., This is available 24×7 for all transactions in your production environments. CICS and IMS support is available with Dynatrace SaaS and Managed versions 1.164. CICS sockets).

Java 117

Java Programming Technology Technology 117

SQL Performance

AUGUST 27, 2021

The instance-wide versioning timestamp is incremented whenever a new statement or batch begins, or a new version of a record is created, in any database where either form of snapshot isolation is enabled. One other potential area that could be impacted by this bottleneck is availability group readable secondaries.

Database 56

Database Storage Availability Servers 56

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. Redis, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 37

Azure Cloud Open Source Virtualization 37

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. 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? pgAdmin Cost: Free (open source).

Open Source 262

Open Source Database Azure Cloud 262

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. Unfortunately, this clause is not yet available in T-SQL. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

SQL Performance

APRIL 10, 2019

You can find coverage of RPR, including illustrated examples, in a 90-page technical report ISO/IEC TR 19075-5 (available for free). You can also find it as part of the document ISO/IEC 9075-2:2016, Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) (available for purchase).

C++ 73

C++ Virtualization Servers Code 73

Scalegrid

APRIL 2, 2019

PostgreSQL is an open source 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 185

Database Cloud Open Source Azure 185

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users.

Big Data 187

Big Data Database Open Source Azure 187

O'Reilly

MAY 25, 2021

GPT-3 is essentially an auto-complete bot whose underlying Machine Learning (ML) model has been trained on vast quantities of text available on the Internet. Note that the dataset on which GPT-3 trained terminated around October 2019. OpenAI’s text generating system GPT-3 has captured mainstream attention.

Social Media 138

Social Media Media Internet Internet 138

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. Environment for Demos. I’ll remind you at the end.

C++ 133

C++ Database Servers Code 133

O'Reilly

OCTOBER 31, 2019

Most of what we do on our computers—fancy graphics, email, databases, building websites, data analysis, digital signal processing—can’t be done with quantum computing. Yes, there have been some small quantum computers available; IBM has quantum computers available in the cloud , including a 5-qubit machine that anyone can try for free.

Artificial Intelligence 53

Artificial Intelligence Google Software Architecture Cloud 53

High Scalability

OCTOBER 3, 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. Redis, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 23

Azure Cloud Open Source Cache 23

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 81

Availability Open Source Architecture Database 81

Smashing Magazine

OCTOBER 29, 2018

2019-04-29T18:34:58+00:00. For a typical site, that might involve routing the request to the correct part of the application, authenticating the request, making multiple calls to backend systems such as databases and so on. You’ll need to do the timing yourself using whatever toolset your backend platform makes available to you.

Servers 87

Servers Performance Metrics Database 87

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

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. IBM, Microsoft, and Amazon are all exploring new ways to use blockchains in 2019.

Development 101

Development Blockchain Serverless Social Media 101

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. Still cloud-y, but with a possibility of migration.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

Smashing Magazine

JANUARY 15, 2019

2019-01-15T13:30:32+01:00. 2019-04-29T18:34:58+00:00. The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. How Improving Website Performance Can Help Save The Planet. Jack Lenox.

Website Performance 73

Website Performance Website Energy Performance 73