article thumbnail

Experience SQL Server 2017: Start your journey here

SQL Server According to Bob

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. Brk2051 sql server on linux and docker from Bob Ward. SQL Server 2017 Release Notes. SQL Server on Linux Release Notes.

Servers 40
article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

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

What is cloud application security?

Dynatrace

If your app runs in a public cloud, such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP), the provider secures the infrastructure, while you’re responsible for security measures within applications and configurations. Likewise, attacks on open source libraries have increased.

Cloud 179
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. DATE_BUCKET. Emulating DATE_BUCKET. OrderValues.

Azure 139
article thumbnail

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

SQL Performance

SQL Server 2016 introduces the batch-mode Window Aggregate operator, which removes the performance penalty part of the pitfall, but prior to SQL Server 2019 this operator is used only if you have a columnstore index present on the data. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60

article thumbnail

Microsoft Engineering loves SQLBits

SQL Server According to Bob

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. SELECT * FROM Azure Cosmos DB – Andrew Liu.

article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.