SQL Performance

AUGUST 14, 2019

2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60 2017-07-08 10251 654.06 2017-07-09 10252 3597.90 Observe the difference in the results for the rows where the same order date appears more than once, as is the case for July 8 th , 2017. 2017-07-05 10249 1863.40 2017-07-05 1863.40

Best Practices 108

Best Practices Servers Database Azure 108

Scalegrid

APRIL 2, 2019

These results are pretty on-par with a 2017 survey by the Uptime Institute which found that 65% of enterprise workloads were still running in data centers owned and operated by those enterprises. Microsoft Azure and Google Cloud Platform tied neck and neck at 17.5% are using public clouds. each amongst PostgreSQL public cloud users.

Database 185

Database Cloud Open Source Azure 185

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] , Nov 2011 [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] , Feb 2012 [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] , 2013 [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 52

Performance Latency Cache Virtualization 52

Particular Software

DECEMBER 14, 2020

In ServiceControl 4.13, we’ve made updates that make saga auditing more useful, provide better support for Azure Service Bus, simplify license management, and make it easier to keep ServiceControl up to date. When using Azure Service Bus as the transport, a topic (named bundle-1 by default) is used for these pub/sub operations.

Azure 52

Azure Transportation Tuning Processing 52

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) SQL Server 2017. SQL Server 2019. OPTIONAL HEADER VALUES. 20B magic # (PE32+).

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be The trace flag does not apply to SQL Server on Linux SQL 2017 RTM thru CU5.

Servers 90

Servers Media Cache Storage 90

Percona

APRIL 12, 2023

2017: MongoDB goes public, trading as MDB. MongoDB Enterprise editions and MongoDB Atlas — which integrates with Amazon Web Services (AWS), Microsoft Azure, and the Google Cloud Platform (GCP) — are not free. The company also releases MongoDB Atlas, promoting it as the most cost-effective way to run MongoDB in the Cloud.

Open Source 83

Open Source Programming Database Servers 83

Particular Software

MARCH 15, 2021

The other was added in October 2017 and is compatible with PostgreSQL. This is a good compromise for SQL Server on-premises, but we found that on SQL Azure these LOB pages appear to be managed differently and their count grows constantly. Aurora currently offers two different interfaces. It turns out this is the best solution.

Transportation 52

Transportation Azure Database Servers 52

SQL Performance

MAY 7, 2019

You can also get wait statistics using the Server Reports add-in to the new Azure Data Studio tool, and using Query Store from SQL Server 2017 onwards. A better way is to track waits over small intervals, say half an hour, and a script to do that is here. Waits Resources. You can get to the library at [link].

Servers 40

Servers Azure Metrics Tuning 40

SQL Server According to Bob

JANUARY 28, 2018

This means there are no DTC components available for SQL Server 2017 on Linux. There is a technique that can be used with SQL Server (Windows, Azure or Linux) to support some DTC capabilities. Note: SQL Server Azure does not support DTC. However, this technique can be used with SQL Server Azure as well.

Servers 40

Servers Azure Engineering Java 40

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

The Symphonia

MAY 22, 2018

Gojko Adzic has done some great speaking and writing on his experience here, and I included the link to his talk from late 2017. Lambda and Azure functions both now offer some amount of local-integration testing. Debugging has improved massively in the Azure world … and somewhat in the Lambda world?—?I

Serverless 40

Serverless Architecture Lambda Azure 40

Enprowess

JANUARY 12, 2022

Twitter Lite PWA : It was integrated as the standard User Interface in 2017. IBM OpenWhisk, Microsoft Azure, AWS Lambda, and Google Cloud Functions are famous names that provide server-less services. Here are a few examples of famous businesses that used PWA’s latest web development technology and increased revenue. Image Source.

Blockchain 59

Blockchain IoT Development Serverless 59

Particular Software

AUGUST 8, 2017

Update Dec 5, 2017: SQL Persistence now also supports PostgreSQL too.) This gives you the freedom to use the database engine you feel most comfortable supporting, whether on-premises or with cloud databases through Microsoft Azure or Amazon RDS.

DevOps 40

DevOps Database Education Engineering 40

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ Another example would be backup to Azure Storage using the rest interface to read and ​​ write data to/from Azure Blob Storage.

Servers 40

Servers Availability Transportation Database 40