SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

FEBRUARY 1, 2022

The transaction log contains virtual log files, which contain log blocks, which store the actual log records. Virtual Log Files. The transaction log is split up into sections called virtual log files , commonly just called VLFs. You’d think the sequence numbers would start at 1 for a brand-new database, but that is not the case.

Architecture 53

Architecture Servers Virtualization Database 53

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

O'Reilly

FEBRUARY 4, 2025

Tim OReilly, Managing the Bots That Are Managing the Business , MIT Sloan Management Review , May 21, 2016 In each of these waves, old skills became obsolescentstill useful but no longer essentialand new ones became the key to success. We still have databases, but they went from ACID to NoSQL. This is not the end of programming.

Programming 145

Programming Google Infrastructure Internet 145

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. The SQL:2016 standard provides two main RPR-related features: Feature R010, “Row pattern recognition: FROM clause”. Feature R010, “Row pattern recognition: FROM clause”.

C++ 73

C++ Servers Virtualization Code 73

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Now in development in WebKit after years of radio silence, WebXR APIs provide Augmented Reality and Virtual Reality input and scene information to web applications. But perhaps counting APIs gives a distorted view?

Media 145

Media Games Education Engineering 145

Alex Russell

MAY 9, 2022

This often happens out of an ad-hoc virtual team that forms in earlier stages but is now formalised and has long-term staffing. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016. When database speed or server capacity is the biggest variable, issues affect managers and executives at the same rate they impact end users.

Performance 99

Performance Latency Metrics Engineering 99

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. But this year?

Serverless 40

Serverless Lambda AWS Traffic 40

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. Microsoft SQL Server Database Engine Input/Output Requirements. product: Virtual Disk. Msft Virtual Disk 1.0 The Back Story. Fua (Forced Unit Access). lshw -class disk.

Servers 90

Servers Media Cache Storage 90