Remove 2017 Remove Azure Remove Servers
article thumbnail

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Scalegrid

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% using SQL Server, 17.3% are using public clouds. using DB2, 7.3%

Database 185
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
Insiders

Sign Up for our Newsletter

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

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

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

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 189
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]. 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
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.