SQL Server According to Bob

JULY 13, 2016

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.

Servers 40

Servers Media Engineering Virtualization 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. Either as a fast in-memory spool that was especially designed for window functions, or as a slow on-disk spool, which is essentially a temporary table in tempdb.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. In 2013, A List Apart published Sustainable Web Design by James Christie. Sustainable Web Design. Write CSS Like Your Grandmother.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. You can take advantage of this effort packaged in SQL Server 2016. SQL 2016 supports 3X more physical memory than previous versions. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. Not all index types support all operator classes, so planning is needed to design your indexes based on the type of operators and queries that you plan on using.

Storage 321

Storage Database Efficiency Processing 321

SQL Server According to Bob

SEPTEMBER 26, 2016

While we were confident in the design of SQL Server 2012, several customers reported to us performance problems that did not appear to be with disk subsystems, CPU, or networks. Our design needed to scale and be adaptable to the modern hardware on the market. First, we looked at the overall architecture of the replica design.

Availability 40

Availability Servers Hardware Benchmarking 40

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Such “torn pages” are corruptions from the database point of view. This is generally referred to as “ partial page writes ” or “ torn pages.”

Database 115

Database Benchmarking Open Source Latency 115

SQL Performance

JUNE 9, 2021

That is, ones that are created as an object in the database, and stay there permanently unless dropped. With the first article on views, I want to start light, focusing on what a view is, using correct terminology, and compare design considerations of views with those of the previously discussed derived tables and CTEs. What is a view?

Database 140

Database Code Design Development 140

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Such architectures bring many benefits (such as scalability and resiliency), but can also bring a lot of pain if incorrectly designed and executed.

Architecture 41

Architecture Database Open Source Internet 41

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 83

Programming Servers Database Hardware 83

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., are then replicated from one or more publishers to one or more subscribers.

Games 88

Games Open Source Tuning Speed 88

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 124

Performance Network Cache Metrics 124

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Whether you're exploring your local #MongoDB database or working with shards and replica sets, @Studio3T allows you to do all of it. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. SQLJDBC uses a slightly different design but again the SQL Server service does not change. Microsoft specific implementation for DTC using (OLE-TX). X/Open Standard for TM to RM communications and behavior. Transaction Monitor/Manager – Coordinator.

Servers 40

Servers Azure Engineering Java 40

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Event-Driven Architecture to the Rescue Event-driven architecture is a software design style that uses messaging techniques to convey events to other services. Because you're on the outside of the monolith, your database technology constraints also disappear.

Architecture 49

Architecture Database Code Systems 49

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Apple's policy against browser engine choice adds years of delays beyond the (expected) delay of design iteration, specification authoring, and browser feature development. But perhaps counting APIs gives a distorted view?

Media 145

Media Games Education Engineering 145

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. It’s fast, too, but it’s not perfect.

C++ 59

C++ Servers Testing Database 59

SQL Performance

APRIL 8, 2019

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The slightly newer Intel Xeon E5-26xx v4 (Broadwell) series which was introduced in Q1 of 2016, increased that to 2400MHz. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article.

Azure 42

Azure Virtualization Storage Benchmarking 42

Smashing Magazine

JANUARY 21, 2019

The term “component” is often used to refer both to functionality and design. Note : Brad Frost’s “ Atomic Design ” is a great methodology for identifying these common patterns and building a reusable design system. Brad Frost identifies five distinct levels in atomic design for creating design systems.

Social Media 64

Social Media Database Media Website 64

Smashing Magazine

OCTOBER 26, 2018

When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. on December 6th, 2016. This will be run on the save_post hook and will overwrite the transient in the database with the JSON data of our post.

Cache 78

Cache Website Speed Database 78

Alex Russell

MAY 9, 2022

Design: Performance is the gap between Figma mockups and the user experience of products for many, but not all , users. The extent to which a product performs well, the higher its likelihood of behaving in accordance to the approved design spec. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016.

Performance 86

Performance Latency Metrics Engineering 86

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. Processed 4.15

Database 40

Database Analytics Blockchain Healthcare 40