SQL Server According to Bob

OCTOBER 26, 2017

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. To find out what’s different and new about SQL Server 2017, go to this documentation page: What’s new in SQL Server 2017. SQL Server on Linux.

Servers 40

Servers Azure Open Source Database 40

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ).

Open Source 76

Open Source Healthcare Social Media Database 76

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. We plan to test this out when we get the chance.

Serverless 40

Serverless Lambda AWS Traffic 40

Dynatrace

JUNE 6, 2019

contributed the containerd container runtime to the Cloud Native Computing Foundation (CNCF) in 2017. Containerd monitoring support is now available in a Beta release for all Kubernetes-based platforms (version 1.11+). Containerd container support is available with the release of Dynatrace OneAgent version 1.169. Dynatrace news.

Monitoring 165

Monitoring Tuning Metrics Analytics 165

VoltDB

JANUARY 12, 2018

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

VoltDB

JANUARY 12, 2018

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

Dynatrace

MAY 6, 2021

Self-service update packages management is now available. You can safe your disk space and have more control over what’s available to your cluster . Linux: Amazon Linux AMI 2017.x. Resolved issue in which incorrect target versions were available for OneAgent update on host, host group, and environment level settings.

Operating System 234

Operating System AWS Metrics Storage 234

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 79

Open Source Programming Database Servers 79

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

Database 40

Database Analytics Blockchain Healthcare 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. In a sharded cluster, each shard acts as an independent database responsible for storing and managing specific data.

Best Practices 70

Best Practices Traffic Database Servers 70

All Things Distributed

OCTOBER 17, 2016

It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint.

AWS 127

AWS Cloud Infrastructure Analytics 127

SQL Performance

JULY 9, 2019

This feature is currently not available in T-SQL. At the date of this writing, there's not much information available out there about the true standard nested window functions. 2 2017-09-18 88.80 10248 85 2017-07-04 440.00 180.000000 10249 79 2017-07-05 1863.40 10248 85 2017-07-04 440.00 1 2018-10-03 878.00

Servers 83

Servers Availability Database Code 83

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

SQL Performance

AUGUST 11, 2021

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

Azure Code Database Servers 139

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 130

Internet Internet AWS Performance 130

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. NULL as a marker for a missing value.

Best Practices 117

Best Practices C++ Database Code 117

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90

Servers Media Cache Storage 90

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. Currently, the optimizer hint for the flag ‘ prefer_ordering_index’ is not yet available till version 8.2.0.

Efficiency 100

Efficiency Database Open Source Performance 100

The Morning Paper

NOVEMBER 8, 2020

USENIX is a nonprofit organisation committed to making content and research freely available – both conference proceedings and the recorded presentations of their events. Back in 2017 the engineering team at Facebook had a problem. Once the database was restored to five replicas, we reconfigured back. Every little helps!

Virtualization 126

Virtualization Latency Storage Systems 126

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. Unfortunately, this clause is not yet available in T-SQL. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

C++ 120

C++ Code Servers Database 120

SQL Performance

JANUARY 23, 2020

Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. There is a single SQL Server database at the heart of every SentryOne monitoring environment, and this customer was monitoring around 600 servers with our software. Query Store 2017 to the Rescue. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. These can be invisible to top(8).

Speed 126

Speed Java AWS Virtualization 126

All Things Distributed

JUNE 30, 2017

When you call for customer assistance, you often need to wait for an agent to become available after navigating a set of menus. Once connected, the systems that power call centers generally don't do a good job of using and sharing available information. " Jeff: "No, actually." Does that work? Virginia) region.

Artificial Intelligence 130

Artificial Intelligence Lambda AWS Virtualization 130

Percona Community

JUNE 8, 2018

Since summer 2017, Amazon RDS supports encryption at rest using AWS Key Management Service (KMS) for db.t2.small medium database instances, making the feature now available to virtually every instance class and type. small and db.t2.medium micro, every other instance class now supports native encryption at rest using KMS.

Virtualization 40

Virtualization AWS Database Availability 40

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ A utility would issue the dbcc freeze to stop the I/O activity for the database. ​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted.

Servers 40

Servers Availability Transportation Database 40

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. Modern network performance and availability. The Moto G4 , for example. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

Abhishek Tiwari

DECEMBER 1, 2017

At re:Invent 2017, Amazon Web Services (AWS) announced Amazon Time Sync Service which provides a highly accurate and reliable global time reference. This service is immediately available in all AWS regions. TrueTime was introduced to support Spanner - Google’s globally distributed, and synchronously-replicated database.

AWS 55

AWS Google Database Virtualization 55

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. Preferred AMD EPYC Processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Particular Software

MARCH 15, 2021

As popular as NoSQL databases have become, you’d be hard-pressed to find a successful business that isn’t running some flavor of SQL somewhere. Unfortunately, that name is not a legal identifier which meant the scripts would not work with SQL*Plus, which is one of the more popular tools used to automate scripts against an Oracle database.

Transportation 52

Transportation Azure Database Servers 52

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. Like any hash join, an adaptive join reads all rows available on its build input and copies the required data into a hash table.

Servers 98

Servers Design Database Code 98

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. Conflict with existing data is unlikely but the new value may sort before those values stored in the database already. Question: What happens to my sequential uuids after an availability group failover?

Servers 40

Servers Software Engineering Database Network 40