SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

J. Paul Reed

AUGUST 7, 2023

The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning. Even though that remediation task was pretty minor — tweaking some low-level hardware settings on each physical server and rebooting — and could have been done quickly enough, there was intense debate on whether it should be done.

Engineering 52

Engineering Hardware Games Infrastructure 52

O'Reilly

JUNE 13, 2023

After fixing some obvious errors, I ran the program–and while it told me (correctly) that my number was non-prime, when compared to a known good implementation of Miller-Rabin, ChatGPT’s code made many mistakes. It didn’t generate any code, but provided a link to the Wolfram Alpha result page that described how to test for primality.

Google 83

Google Programming Database Testing 83

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 109

C++ Database Servers Code 109

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!

C++ 111

C++ Database Servers Code 111

Particular Software

DECEMBER 9, 2019

I once had a client who started out with a very noncomplex server infrastructure. The hosting provider had given them ownership of an internal IP subnet, and so they started out with two load-balanced public web servers: X.X.X.100 It's easy enough to upgrade load-balanced web servers. It's not so easy with a junk drawer server.

Wireless 52

Wireless DevOps Infrastructure Network 52

MachMetrics

JANUARY 4, 2019

Basically, Google offers a foundational code package called a module that you can then remake to suit your needs. This PageSpeed service offers two types of package for web servers: Apache module and Nginx module. Work with a test box first before actually implementing the module into your server architecture.

Speed 60

Speed Website Open Source Google 60

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name , [ Object ] = o. name , [ Column ] = c.

C++ 58

C++ Database Servers Performance 58

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 93

C++ Database Servers Code 93

Sutter's Mill

JANUARY 11, 2021

Assertions have been a foundational tool for writing understandable computer code since we could write computer code… far older than C’s assert() macro, they go back to at least John von Neumann and Herman Goldstine (1947) and Alan Turing (1949). Run-time errors should be reported using exceptions, error codes, or similar.

C++ 66

C++ Programming Code Testing 66

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement.

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. I've used sp_prepare less in my career than plan guides, and I wouldn't recommend using it for application code.

Cache 59

Cache Tuning Database Performance 59

The Agile Manager

SEPTEMBER 30, 2012

It's easy to assume that we're hiring competent developers who write high quality code, and most buyers don't know what to look for or how to look for technical quality. We can invest in people to become mobile solution developers who can write client and server code. Stronger hand-offs will slow down coding.

Mobile 49

Mobile Code Java Software 49

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. But changing this is possible only at the server startup. But they are generally used by client tools.

Database 104

Database Servers Open Source Tuning 104

Dynatrace

MAY 15, 2020

How to assess an environment’s security posture, risk and threat profile, and possible attack vectors, where perhaps you didn’t code the application or build the infrastructure, and where new code is deployed frequently, and the infrastructure is constantly changing? And this poses a significant risk. Showing a list of key processes.

Government 225

Government DevOps Infrastructure Network 225

O'Reilly

JANUARY 17, 2023

Figuring out what kinds of problems are amenable to automation through code. So it behooves a software developer to spot what portions of human activity can be properly automated away through code, and then build that. Because if companies use code to automate business rules, they use ML/AI to automate decisions.

Tuning 130

Tuning Open Source AWS Software 130

The Agile Manager

NOVEMBER 26, 2008

User Interface, middle tier, server side, database, specialists in things like ERP systems) or by component (e.g., This means that lots of development tasks may be flagged as “complete” but they’re complete only by assertion of a developer, not by “fact” of somebody who has exercised the code from end-to-end. The QA tester?

Code 40

Code Servers Engineering Programming 40

Percona

AUGUST 8, 2023

Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. Does your traffic increase come with updated code changes that change the queries? Do these queries use more caches?

Traffic 89

Traffic Cache Monitoring Database 89

SQL Performance

APRIL 14, 2021

Use the following code to test the function with the variable assignment technique: DECLARE @n AS BIGINT ; SELECT @n = n FROM dbo. Here’s the code that creates the table and populates it using an INSERT statement with 102,400 rows to get it to be compressed: DROP TABLE IF EXISTS dbo. NullBits102400 ; GO. CREATE TABLE dbo.

C++ 112

C++ Servers Testing Code 112

CSS - Tricks

APRIL 1, 2021

With all of this in mind, I thought improving the speed of my own version of a slow site would be a fun exercise. The code for the site is available on GitHub for reference. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM).

Cache 92

Cache Social Media Media Website 92

Dynatrace

APRIL 21, 2022

Using high-fidelity metrics, logs, code-level tracing, and a dynamic topology map of your applications, Davis can identify the precise root cause and prioritize its business impact. With the automated analysis of your code hotspots within Dynatrace, you can quickly identify bottlenecks and help you right-size your cloud resources.

Azure 188

Azure Monitoring Virtualization Metrics 188

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. However, nothing easily allows SQL Server to determine what percentage of the leaf level for each index of a table is already in memory.

Efficiency 54

Efficiency Servers Database Cache 54

O'Reilly

OCTOBER 19, 2021

If you peek under the hood of an ML-powered application, these days you will often find a repository of Python code. Let’s start by considering the job of a non-ML software engineer: writing traditional software deals with well-defined, narrowly-scoped inputs, which the engineer can exhaustively and cleanly model in the code.

DevOps 138

DevOps Software Engineering Infrastructure Open Source 138

Smashing Magazine

AUGUST 5, 2021

We want to ensure that the input is perfectly correct before the data is even sent to the server. And because something is happening, they usually exercise a good amount of patience first. After all, as designers and developers, we want to make it more difficult for our users to make mistakes. The Downsides Of Disabled Buttons.

Design 145

Design Transportation Code Systems 145

SQL Performance

SEPTEMBER 25, 2020

However, the problem still exists in SQL Server 2019. So I wrote some PowerShell code to step through a procedure to see which other tokens were identified. Open Visual Studio Code (or your favorite PowerShell IDE) and save a new file called Test1.ps1. Here’s the only item I’ve found that made it to the new feedback system.).

Code 42

Code C++ Database Servers 42

The Morning Paper

AUGUST 27, 2019

In a distributed setting with weak consistency, an object is replicated across a set of servers. Unfortunately, to date, the task of identifying whether or not an object is actually invariant confluent has remained an exercise in human proof generation… Hand-written proofs of this sort are unreasonable to expect from programmers.

Programming 59

Programming Processing Database Systems 59

O'Reilly Software

MARCH 7, 2018

This is mixing concerns and leads to code that becomes strongly coupled, monolithic, hard to write, hard to read, hard to evolve, hard to test, and hard to reuse. Let’s take a look at a code snippet of a simple streaming pipeline to better understand how these pieces fit together. of ( Invoice. alsoTo ( Sink. of ( Order.

Transportation 72

Transportation Java Programming Architecture 72

The Netflix TechBlog

OCTOBER 21, 2019

Alerting on Log data which detects application errors by processing data from thousands of Netflix servers in realtime. Chaos Experimentation monitoring which tracks user experience during a Chaos exercise in realtime and triggers an abort of the chaos exercise in case of an adverse impact.

Open Source 148

Open Source Metrics Engineering Processing 148

The Netflix TechBlog

OCTOBER 21, 2019

Alerting on Log data which detects application errors by processing data from thousands of Netflix servers in realtime. Chaos Experimentation monitoring which tracks user experience during a Chaos exercise in realtime and triggers an abort of the chaos exercise in case of an adverse impact.

Open Source 101

Open Source Metrics Engineering Processing 101

The Netflix TechBlog

OCTOBER 21, 2019

Alerting on Log data which detects application errors by processing data from thousands of Netflix servers in realtime. Chaos Experimentation monitoring which tracks user experience during a Chaos exercise in realtime and triggers an abort of the chaos exercise in case of an adverse impact.

Open Source 100

Open Source Metrics Engineering Processing 100