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

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. 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

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Suppose for example that you want to query the Sales.Orders table in the TSQLV5 sample database. Implicit grouping with PIVOT. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

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

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. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

AUGUST 11, 2021

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. An event that took place on July 14 th , 2018 belongs to fiscal year 2017. 2017 343 495118.14

Azure 139

Azure Code Database Servers 139

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

All Things Distributed

OCTOBER 17, 2016

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. It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. The Ohio Region is no different.

AWS 127

AWS Cloud Infrastructure Analytics 127

Dynatrace

MAY 6, 2021

Linux: Amazon Linux AMI 2017.x. Fixed an issue in which database conditions in tagging and management zone configurations were evaluated incorrectly. Operating systems support. Future Dynatrace Managed operating systems support changes. The following operating systems will no longer be supported starting 01 September 2021.

Operating System 234

Operating System AWS Metrics Storage 234

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. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. DISTINCT predicate. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

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? Enhanced security is another advantage MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB.

Open Source 80

Open Source Programming Database Servers 80

SQL Server According to Bob

FEBRUARY 15, 2018

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. Adaptive query processing in SQL databases – Bob Ward and Conor Cunningham.

Engineering 40

Engineering Azure Best Practices Servers 40

SQL Performance

MAY 1, 2020

Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. Change the Target Recovery Time of a Database. STATE = START ; I marked the time that I changed each database, and then analyzed the results from the Extended Events data using a query published in the original tip.

C++ 58

C++ Database Servers Storage 58

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 Unless you are running Previous Generation DB Instances or you can only afford to run a db.t2.micro,

Virtualization 40

Virtualization AWS Database Availability 40

The Netflix TechBlog

OCTOBER 19, 2020

By 2017, open source projects like Open-Tracing and Open-Zipkin were mature enough for use in polyglot runtime environments at Netflix. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Brendan Gregg

NOVEMBER 29, 2017

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. This finally came to storage-optimized instance types in 2017 with the [i3 instance type], which used SR-IOV and the nvme storage driver.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. Last October we released SQL Server 2017 including support for Linux and Docker Containers. docker pull microsoft/mssql-server-linux:2017-latest. As I moved to other jobs, the PC was becoming very popular as was the Windows Operating System.

Servers 40

Servers Internet Internet Open Source 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

All Things Distributed

JUNE 30, 2017

So much so, that in March 2017, we announced Amazon Connect, which is the result of nearly ten years of work to build cloud-based contact centers at scale to power customer service for more than 50 Amazon teams and subsidiaries, including Amazon.com, Zappos, and Audible.

Artificial Intelligence 130

Artificial Intelligence Lambda AWS Virtualization 130

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. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

MachMetrics

DECEMBER 14, 2019

In 2017, mobile internet usage passed desktop as the majority. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. What is the number of resources I should stay under? How fast is the average time to first byte (server delay)? What impact does the increased use of mobile devices have?

Best Practices 105

Best Practices Speed Mobile Google 105

SQL Server According to Bob

FEBRUARY 10, 2019

SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. This means we are reading database pages from the master, acquiring locks, and making calls to the domain controller (DC/KDC.). 512 byte response (use database context xxxxxx, default language xxxxxxx, test size xxxxx). wait_info*.

Servers 40

Servers Network Database Systems 40

SQL Performance

OCTOBER 26, 2021

However, that column in the event output was only added in SQL Server 2017, and you’d also have to configure an action that captured something to identify the query involved. Checkpoint the database and execute DBCC DROPCLEANBUFFERS. Update twenty thousand rows.

Servers 55

Servers Metrics Database Performance 55

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. secrets/instance_id file. Question: What if I change the time of the system clock?

Servers 40

Servers Software Engineering Database Network 40

Adrian Cockcroft

JANUARY 29, 2023

Bill Kaiser of NewRelic published this blog in 2017 which goes some way towards what I’m talking about, but since then I have figured out a new way to interpret the data. What Is the Expected Distribution of Website Response Times? That’s why an algorithm is needed to take out the guesswork.

Lambda 98

Lambda Latency Cache Traffic 98

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. 38% of all sites measured in Sept 2017 (~500K) are more than 75% 3rd party content.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Particular Software

AUGUST 8, 2017

The new persister supports multiple database engines and uses raw ADO.NET and native SQL queries, without the need for an intermediate ORM. Up until now, our primary method of persisting data in relational databases used NHibernate, which was making it impossible to realize those dreams.

DevOps 40

DevOps Database Education Engineering 40

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 74

Open Source Database Storage Scalability 74

Scalegrid

APRIL 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 185

Database Cloud Open Source Azure 185

Brendan Gregg

NOVEMBER 28, 2017

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. This finally came to storage-optimized instance types in 2017 with the [i3 instance type], which used SR-IOV and the nvme storage driver.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JUNE 5, 2019

Reminder: Do not run ALTER DATABASE <YourDBName> SET QUERY_STORE CLEAR; against your production database unless you want to remove everything from Query Store. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE = ON ; GO. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE CLEAR ; GO.

Servers 41

Servers Cache Database Metrics 41

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

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

High Scalability

NOVEMBER 30, 2018

during the 2017-18 academic year, on top of a 3.3% The scalability of a native graph database. They'll love it and you'll be their hero forever. 8 : successful Mars landings; $250,000 : proposed price for Facebook Graph API; 33 : countries where mobile internet is faster than WiFi; 1000s : Facebook cache poisoning; 8.2

Internet 28

Internet Internet Scalability Blockchain 28

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Use the following code to create the Employees table in the tempdb database, populate it with sample data, and create a supporting index: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Employees ; GO. CREATE TABLE dbo. Employees. (

C++ 140

C++ Servers Code Efficiency 140

KeyCDN

NOVEMBER 8, 2018

We also recommend using a free program like KeePass or KeePassX which allow you to generate secure passwords and store them in a database locally on your computer. Varonis) In 2017 there was a 13 percent overall increase in reported system vulnerabilities.

Transportation 47

Transportation Website Google Infrastructure 47