SQL Performance

NOVEMBER 1, 2019

As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features. I wrote about this in a post entitled, " A Big Deal : SQL Server 2016 Service Pack 1."

Servers 40

Servers Hardware Database Availability 40

SQL Performance

FEBRUARY 22, 2021

We pay a lot of attention to latency here, along with any long-running transactions, because of downstream impact to technologies that use the log reader – like Availability Groups and transactional replication. Recently one of our teams was investigating a log reader latency issue.

Latency 57

Latency Servers Monitoring Systems 57

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”.

C++ 73

C++ Servers Virtualization Code 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

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 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. Many efforts are afoot to improve the situation on the web.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Server According to Bob

SEPTEMBER 26, 2016

The rapid acceleration in technology brought on a new discovery and paradigm. The result is a design for SQL Server 2016 that provides high availability for the most demanding workloads on the latest hardware with minimal impact and scalable for the future. Direct seeding of new database replicas. . one without a replica).

Availability 40

Availability Servers Hardware Benchmarking 40

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

O'Reilly

APRIL 5, 2023

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. In 2016, Microsoft’s Tay chatbot was shut down after making racist and sexist comments. .” But is that too simple an approach?

Artificial Intelligence 110

Artificial Intelligence Energy Government Virtualization 110

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. The first was c3.

Virtualization 111

Virtualization AWS Hardware Storage 111

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. Windows New Technology File System. The Back Story. Common File Systems Used For SQL Server Deployments.

Servers 90

Servers Media Cache Storage 90

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. " Technology is much better than it was all those years ago when that legacy project began. If the multi-year rewrite plan does get approved by the business, what's to say you won't be making the same mistakes as your predecessors but with the technology of today?

Architecture 49

Architecture Database Code Systems 49

SQL Performance

JULY 16, 2019

If you have been paying attention to the technology press over the past 12-18 months, you may have noticed a rather large number of negative stories about Intel's processor business. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. We usually relate SQL to querying tables in relational databases. The adoption of fast data technologies is on a steep rise.

Architecture 80

Architecture Scalability Google Operating System 80

Alex Russell

MAY 9, 2022

Panglossian nonsense. --> Organisations that serve their tools tread water no matter how advanced their technology, while groups that intentionally manage systems can succeed on any stack. [1]. Teams that achieve Level 4 maturity are cautious acquirers of technology. Value Propositions #. What's the problem? Management Attributes #.

Performance 86

Performance Latency Metrics Engineering 86

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

The Symphonia

DECEMBER 6, 2017

It’s no longer a niche technology for enthusiasts?—?it’s Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. It’s still in early access, so no concrete news to report here, but a lot of people will be happy to be able to use a SQL database that has the operational properties of DynamoDB.

Serverless 40

Serverless Lambda AWS Traffic 40

Smashing Magazine

JANUARY 21, 2019

Following, the API will add the database object data. This information is not placed under each module, but under a shared section called databases , to avoid duplicating information when two or more different modules fetch the same objects from the database. In other words, database object data is normalized.

Social Media 64

Social Media Database Media Website 64

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. SQL Server uses Vertipaq technology to determine a good way of sorting columns in each row group to give a good overall compression result. Things should work just fine on the latest build of SQL Server 2016 as well.

Servers 67

Servers Testing Metrics Storage 67