SQL Server According to Bob

NOVEMBER 8, 2016

Create / Alter Database … LOG ON. When you create or alter the SQL Server database you simply add the LOG ON clause, pointing to the DAX enabled volume. SQL Server will detect the request on the DAX based volume and create the non-volatile, tail of log cache of fixed size for the database.

Cache 40

Cache Servers Media Storage 40

The Agile Manager

AUGUST 31, 2020

Decades of upstream and downstream systems resulted in point-to-point and often database-level integrations to legacy systems. Something often overlooked is that the tight coupling of software assets is a mirror of the tight coupling of business functions.

Architecture 52

Architecture Code Strategy Programming 52

VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. You want to shift some of these servers to create a disaster recovery site. This has always been a supported configuration of VoltDB database replication.

Hardware 40

Hardware Database Servers Tuning 40

The Agile Manager

NOVEMBER 30, 2015

In the early 1970s, biologists Humberto Maturana and Francisco Varela coined the term autopoiesis to define the self-maintaining nature of living cells: biological cells produce the components that maintain the structure that creates more components (in this case, more cells).

Systems 45

Systems Storage Programming Infrastructure 45

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Tasktop

JULY 20, 2021

The latest evolution of our enterprise toolchain integration solution further optimizes the day-to-day lives of software delivery teams, creating a seamless workflow that maximizes efficiency. Containing mirroring improvements. is a database backoff configuration. Container Mirroring Improvements. Also new in 21.3

Software 52

Software Software Government Database 52

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. Bounce the database, replacing the binaries with the older release. Remove backward-incompatible features.

Metrics 98

Metrics C++ Storage Database 98

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. The data needs to be stored in a search database for quick retrieval.

Cache 240

Cache Database Servers Latency 240

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 104

Availability Database Open Source Hardware 104

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

O'Reilly

APRIL 5, 2023

Things will become more difficult when AIs begin creating their own biases,” she says. Worse yet, the AI’s bias would likely find its way into the system’s database and follow the students from one class to the next. The goal isn’t creating neutral AI. The goal is creating tunable AI,” she says.

Artificial Intelligence 110

Artificial Intelligence Energy Government Virtualization 110

O'Reilly

JULY 15, 2020

This roughly mirrors usage on the O’Reilly learning platform. Perhaps; we’ll take a look at that next, specifically with respect to containers, centrally managed databases, and monolithic UIs. Use of a Central, Managed Database. What percentage of your microservices share a centrally-managed database?”)

Database 135

Database Architecture Education Systems 135

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. The data needs to be stored in a search database for quick retrieval.

Cache 112

Cache Database Servers Latency 112

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. The data needs to be stored in a search database for quick retrieval.

Cache 100

Cache Database Servers Latency 100

SQL Server According to Bob

FEBRUARY 13, 2020

The introduction of VDI also allowed for the proper split mirroring and snapshot backups such as in Microsoft Data Protection manager (DPM.) ​​ Prior to the introduction of the VDI feature the dbcc freeze/thaw TSQL commands were used to stop and start database writes/reads.

Servers 40

Servers Availability Transportation Database 40

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. However HammerDB will not be able to connect to a database yet and the librarycheck command included with the CLI gives an indication why. HammerDB CLI v3.1 HammerDB CLI v3.1 Oratcl 4.6.

Architecture 40

Architecture Virtualization Open Source C++ 40

O'Reilly

MARCH 23, 2023

2 However, you don’t need to know how Transformers work to use large language models effectively, any more than you need to know how a database works to use a database. You could even create digital clones of yourself 5 that could stand in for you in consulting gigs and other business situations. What will we build?

Google 105

Google Open Source Programming Code 105

SQL Performance

NOVEMBER 4, 2021

Here’s an example using the AdventureWorks2017 sample database and the following indexing trick by Itzik Ben-Gan to get unconditional consideration of batch mode execution: -- Itzik's trick. CREATE NONCLUSTERED COLUMNSTORE INDEX BatchMode ON Sales. on Database Administrators Stack Exchange by Erik Darling. A Worked Example.

Servers 98

Servers Design Database Code 98

Smashing Magazine

JANUARY 21, 2019

A component is simply a set of pieces of HTML, JavaScript and CSS code put all together to create an autonomous entity. This can then wrap other components to create more complex structures, and be itself wrapped by other components, too. Brad Frost identifies five distinct levels in atomic design for creating design systems.

Social Media 64

Social Media Database Media Website 64

Strategic Tech

APRIL 27, 2019

This organisational pattern can be mirrored in the software architecture, emphasising the sociotechnical nature of systems. Consumer-specific Endpoints in the Government When working for the UK government on a digital tax system, I remember an intriguing case of creating consumer-specific endpoints. The rules were moderately intricate.

Software Architecture 58

Software Architecture Architecture Government Design 58