SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

Dynatrace

JANUARY 26, 2021

VMware commercialized the idea of virtual machines, and cloud providers embraced the same concept with services like Amazon EC2, Google Compute, and Azure virtual machines. Within this paradigm, it is possible to run entire architectures without touching a traditional virtual server, either locally or in the cloud. Pay Per Use.

Serverless 243

Serverless Efficiency Lambda Azure 243

ScaleOut Software

JULY 14, 2021

The Microsoft Azure IoT ecosystem offers a rich set of capabilities for processing IoT telemetry, from its arrival in the cloud through its storage in databases and data lakes. Acting as a switchboard for incoming and outgoing messages, Azure IoT Hub forms the core of these capabilities.

IoT 52

IoT Azure Analytics Serverless 52

Dynatrace

OCTOBER 10, 2022

Despite the name, serverless computing still uses servers. This means companies can access the exact resources they need whenever they need them, rather than paying for server space and computing power they only need occasionally. If servers reach maximum load and capacity in-house, something has to give before adding new services.

Serverless 165

Serverless Infrastructure Lambda Latency 165

Dynatrace

JULY 7, 2022

One large team generally maintains the source code in a centralized repository that’s visible to all engineers, who commit their code in a single build. These teams typically use standardized tools and follow a sequential process to build, review, test, deliver, and deploy code. Common problems with monolithic architecture.

Architecture 200

Architecture Serverless Azure Programming 200

Dynatrace

AUGUST 11, 2022

Function as a service is a cloud computing model that runs code in small modular pieces, or microservices. Cloud providers then manage physical hardware, virtual machines, and web server software management. In a FaaS model, developers can write code functions on demand, without being hindered by dependencies on existing applications.

Development 250

Development Serverless Best Practices Lambda 250

Dynatrace

JUNE 7, 2023

This includes OpenAI as well as Azure OpenAI services, such as GPT-3, Codex, DALL-E, or ChatGPT. Our example dashboard below visualizes OpenAI token consumption. How Dynatrace traces OpenAI model requests Let’s use a simple NodeJS example service to show how Dynatrace OneAgent automatically traces OpenAI model requests.

Monitoring 164

Monitoring Latency Metrics Azure 164

Dynatrace

JULY 12, 2022

After moving to Microsoft Azure for many of its production-stage applications, Park ‘N Fly’s IT teams experienced blind spots. “We The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We IT automation speeds code development.

Innovation 219

Innovation Infrastructure DevOps Azure 219

Dynatrace

AUGUST 24, 2020

To make this possible, the application code should be instrumented with telemetry data for deep insights, including: Metrics to find out how the behavior of a system has changed over time. Similarly, integrations for Azure and VMware are available to help you monitor your infrastructure both in the cloud and on-premises.

Analytics 240

Analytics Infrastructure AWS Operating System 240

Dynatrace

SEPTEMBER 29, 2021

A standard Docker container can run anywhere, on a personal computer (for example, PC, Mac, Linux), in the cloud, on local servers, and even on edge devices. These tools integrate tightly with code repositories (such as GitHub) and continuous integration and continuous delivery (CI/CD) pipeline tools (such as Jenkins).

Open Source 301

Open Source Traffic DevOps Cloud 301

Scalegrid

SEPTEMBER 16, 2019

You can remotely access and navigate another database server. The dashboard lets you monitor server activities such as database locks, connected sessions, and prepared transaction. Since pgAdmin is a web application, you can deploy it on any server and access it remotely.

Open Source 262

Open Source Database Azure Cloud 262

Dynatrace

MAY 17, 2023

However, this method limited us to instrumenting the code manually and collecting specific sets of data we defined upfront. It is available for the major OS and cloud platforms (for example, Windows, Linux, Solaris, AWS, Azure, and more) and only requires the deployment of a single service to monitor its environment.

Metrics 171

Metrics Monitoring Database Network 171

Dynatrace

NOVEMBER 15, 2021

Driving this growth is the increasing adoption of hyperscale cloud providers (AWS, Azure, and GCP) and containerized microservices running on Kubernetes. A log is a detailed, timestamped record of an event generated by an operating system, computing environment, application, server, or network device. billion in 2020 to $4.1

Analytics 209

Analytics Monitoring Artificial Intelligence DevOps 209

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. “We used Dynatrace to monitor that large increase in servers. We started out by instrumenting 2,000 servers overnight. Modernize cloud operations with Dynatrace.

Cloud 177

Cloud Infrastructure Innovation Monitoring 177

SQL Performance

OCTOBER 7, 2020

The canonical example of a plan operator that can rewind is the lazy Table Spool. 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). This first example features two table variables.

Servers 106

Servers Cache Azure Performance 106

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

AUGUST 11, 2021

For example, the measurements could be temperature and humidity readings taken every 5 minutes, and you want to group the data using hourly buckets and compute aggregates like average per hour. For example, you might want to organize sales data in fiscal year buckets and compute aggregates like the total sales value per fiscal year.

Azure 139

Azure Code Database Servers 139

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

JUNE 15, 2023

Cloud application security practices enable organizations to follow secure coding practices, monitor and log activities for detection and response, comply with regulations, and develop incident response plans. Recent examples include the Heartbleed vulnerability in 2014, the attacks on Apache Struts in 2017, and Log4Shell in 2021.

Cloud 177

Cloud Open Source Architecture Monitoring 177

IO River

NOVEMBER 2, 2023

‍Before we dive into what Terraform is, let's begin with a real-world example of how Terraform code looks and works:‍# Challenge requests coming from known Tor exit nodes.‍‍In ‍In the example above, we're using Terraform to set up an access rule on Cloudflare. ‍Why Manage Infrastructure by Code?

Open Source 52

Open Source DevOps AWS Azure 52

SQL Performance

APRIL 26, 2019

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. DeviceID – This allows you to specify if you want to collect data for a specific SQL Server or everything. The default is -1, which means copy all watched SQL Servers.

Azure 40

Azure Database Metrics Servers 40

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Dynatrace

AUGUST 24, 2020

To make this possible, the application code should be instrumented with telemetry data for deep insights , includin g: . But there are other related components and processes ( for example, cloud provider infrastructure ) that can cause problems in applications running on Kubernetes. Dynatrace Kubernetes documentation .

Analytics 135

Analytics Infrastructure AWS Operating System 135

Abhishek Tiwari

JULY 22, 2023

Pre-deployment policy compliance, supported by policy as code frameworks such as Sentinel, Open Policy Agent (OPA), Conftest, etc. In this article, we will explore into the significance of pre-deployment policy compliance, explore the role of policy as code frameworks, and showcase real-life examples of successful implementations.

AWS 52

AWS Best Practices Infrastructure Traffic 52

Dynatrace

JULY 10, 2019

Just a single OneAgent per host is required to collect all relevant monitoring data, all the way down to specific lines of code. OneAgents are optimized to send data to the Dynatrace servers with the smallest possible impact, querying the metrics every minute, and the data is a first-class citizen for the Dynatrace AI root-cause analysis.

Java 137

Java Best Practices Metrics Azure 137

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. These color-coded states on panels are available in PMM 2.32.0

Cloud 122

Cloud Serverless AWS Storage 122

ScaleOut Software

AUGUST 5, 2020

And how are they different from streaming pipelines like Azure Stream Analytics and Apache Flink/Beam? For example, consider a web-based ad-serving platform that selects ads for users and logs messages containing a timestamp, user ID, and ad ID every time an ad is displayed. An Example.

Analytics 69

Analytics Azure Processing Speed 69

IO River

NOVEMBER 2, 2023

Before we dive into what Terraform is, let's begin with a real-world example of how Terraform code looks and works:‍# Challenge requests coming from known Tor exit nodes.‍‍In the example above, we're using Terraform to set up an access rule on Cloudflare. This rule challenges requests coming from known Tor exit nodes.

Open Source 40

Open Source DevOps AWS Azure 40

Particular Software

JUNE 1, 2020

One of our recent clients—a government agency—was already using NServiceBus and wanted to migrate their system to Azure. The steps we took to get NServiceBus ready to run in Azure may be helpful to you as you map your own cloud moves. The natural replacement for MSMQ in Azure is Azure Service Bus.

Cloud 52

Cloud Transportation Azure Government 52

ScaleOut Software

APRIL 6, 2021

With the ScaleOut Digital Twin Streaming Service , an Azure-hosted cloud service, ScaleOut Software introduced breakthrough capabilities for streaming analytics using the real-time digital twin concept. The management console installs as a set of Docker containers on the management server.

IoT 52

IoT Azure Analytics Healthcare 52

Particular Software

JANUARY 27, 2020

It is preceded in death by Windows Communication Foundation and Windows Workflow Foundation, and survived by Azure Queues and Azure Service Bus. 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 Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

Dynatrace

MAY 31, 2021

Cloud-native refers to cloud-based, containerized, distributed systems, made up of cooperating microservices, dynamically managed by automated infrastructure-as-code. Kubernetes is designed to deal with failures, which can and will happen: servers can go down, processes run out of memory and crash, network becomes unreliable, and so on.

Virtualization 133

Virtualization DevOps Infrastructure Cloud 133

SQL Performance

JANUARY 12, 2022

Because you can still learn a lot from them; for example, by identifying anti-patterns. Use the following code to create the table and populate it with a small set of sample data: DROP TABLE IF EXISTS dbo. ( ID INT NOT NULL IDENTITY ( 1 , 1 ) CONSTRAINT pk_Auctions PRIMARY KEY CLUSTERED , Code CHAR ( 1 ) NOT NULL.

Code 116

Code Servers Performance Azure 116

SQL Performance

APRIL 8, 2020

As Grant repeatedly points out, many who use common table expressions in T-SQL think that SQL Server persists the inner query result set, and that the reason for this belief is the use of the term table in the construct's name. In my examples I'll use a sample database called TSQLV5. Date (O'Reilly 2015). Physical data independence.

C++ 143

C++ Azure Database Servers 143

KeyCDN

FEBRUARY 22, 2023

Another benefit is cost savings associated with server and data center setup and maintenance. Developers can easily share and access code and other resources regardless of their location. There are several popular cloud-based platforms for web development and deployment, such as AWS , Azure , and Google Cloud Platform.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Dotcom-Montior

OCTOBER 19, 2021

A typical SRE is busy automating, cleaning up code, upgrading servers, and continually monitoring dashboards for performance, etc., It also extremely fast since it is a compiled language, meaning that the code written is converted automatically into machine code immediately. Kubernetes.

Engineering 86

Engineering Open Source Programming Monitoring 86