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
article thumbnail

What is cloud application security?

Dynatrace

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 168
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

Serverless at re:Invent 2017

The Symphonia

Specific improvements include A new code editor for those who write their Lambda functions in Javascript and Python, far superior to the old inline code-editor. we have powerful laptops and are perfectly happy with a combination of IntelliJ and the rapidly evolving VS Code editor from Microsoft. But we’re keeping an open mind.

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]. 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 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60

article thumbnail

Updates in ServiceControl 4.13

Particular Software

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
article thumbnail

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

SQL Server will ship Azure SQL Database Edge: [link]. As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. SQL Server 2017. 1A6BE00 size of code.

IoT 61
article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments. 2017: MongoDB goes public, trading as MDB. Under the SSPL, a company can take MongoDB’s code and deploy it, but that company cannot offer it as a service.