article thumbnail

Part 1: How Dynatrace and GitHub help you deliver better software faster

Dynatrace

Since becoming General Availability in the fall of 2019 , GitHub Actions has helped teams automate continuous integration and continuous delivery (CI/CD) workflows for code builds, tests, and deployments. Example #1 – Deploy application code to Kubernetes.

Software 246
article thumbnail

Bucketizing date and time data

SQL Performance

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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Modernize cloud operations to transform the way you work

Dynatrace

” Despite many challenges, when the project concluded in 2019, the team had the confidence and experience to migrate anything to the cloud. “This facilitates what’s known as configuration as code or monitoring as code. . “We kind of did the opposite. How Dynatrace solved VA’s cloud complexity.

Cloud 185
article thumbnail

MSMQ is dead

Particular Software

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

article thumbnail

T-SQL bugs, pitfalls, and best practices – window functions

SQL Performance

Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data. DROP TABLE IF EXISTS dbo. Transactions. (

article thumbnail

What is Azure Functions?

Dynatrace

What is Azure Functions? 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. The growth of Azure cloud computing.

Azure 138
article thumbnail

Matching Supply With Demand — Solutions, Part 1

SQL Performance

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. Auctions ( ID , Code , Quantity ) VALUES. ( Auctions. (

Code 116