SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. A quirk of the implementation means no check is performed when the count of held locks is exactly 1250. The code in HeapDataSetSession::EscalateLocks next calls sqlmin!IsEscalationPossible

Database 98

Database Storage Testing Servers 98

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. The ReportServer and ReportServerTempDB databases are SQL Server databases and should be part of a regular backup process, just like other user databases. In the early days of SSRS, a requirement was to also install and configure Internet Information Services (IIS).

Tuning 67

Tuning Servers Database Best Practices 67

The Agile Manager

JUNE 30, 2020

It's target state one month after launch was to have 5 locations running the new software in parallel with legacy, processing 0.15% of corporate transactions, with another 5 locations ready for go-live the following month. We're all ok here" has been the modus operandi for IT governance for the past two decades.

Government 52

Government Healthcare Programming Software 52

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. Table of Contents.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Alex Russell

AUGUST 30, 2021

Anyone who cares to download and fork the code can do so. From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." This process can be messy and slow, but it never creates a political blockage for developing new capabilities for the web.

Engineering 98

Engineering Open Source Website Operating System 98

SQL Performance

MAY 1, 2020

Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. If you have instances running older versions like SQL Server 2008 R2 (I found one!), And none of these FlushCache messages were ever paired with the 15 second I/O warnings in the error log.

C++ 58

C++ Database Servers Storage 58

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? This command compares the code bytes in the crash dump (some of them are saved in the crash dump, just in case) against those on disk. In this case it said that 9322 bytes in the code in the crash dump were wrong.

Programming 79

Programming Hardware Cache Code 79

SQL Performance

APRIL 26, 2019

The DTU calculator is a free tool you can use to upload performance metrics from your server, and use the data to determine the appropriate service tier if you were to migrate that server to an Azure SQL Database (or to a SQL Database elastic pool ). NOTE : This process is not officially supported by SentryOne.

Azure 40

Azure Database Metrics Servers 40

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Dynatrace

SEPTEMBER 26, 2019

Over the last few years we’ve talked a lot about how at Dynatrace we have changed our development processes in order to deploy new feature releases with every sprint, as well as providing a fast-lane to production that allows us to deploy important updates to our customers within an hour. Dynatrace news. I have a new idea.

Education 35

Education Programming Processing DevOps 35

O'Reilly Software

OCTOBER 23, 2018

In 2008 or so, when data scientist emerged as a job title, it was widely ridiculed as a nonjob: the thought that people who just worked with data could be scientists, or employ the rigors of their time-honored methods, was literally laughable in many circles. Adding security reduces performance. Three concerns of the architect.

Strategy 100

Strategy Architecture Technology Technology 100

The Agile Manager

FEBRUARY 28, 2017

Management textbooks dating at least as far back as the 1980s included stories of employees performing tasks the reasons for which they didn't really understand. Tool 1: Dolly the Sheep Companies that are heavily rule-based - think insurance - eagerly moved their business rules into code.

Strategy 40

Strategy Java Code Systems 40

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 process to enable this for a database is described in our documentation. This might have a performance effect for unencrypted databases on the same instance of SQL Server. Notice what is below it.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

AUGUST 20, 2021

However, unlike the early days of the web, static sites are no longer limited to developers working in a code editor. Piecing together a website using a WYSIWYG editor and seeing the code it generated was a fascinating and educational experience that sparked an initial interest in web design. MovableType really was before its time.

Ecommerce 139

Ecommerce Website Government Internet 139

O'Reilly

JULY 25, 2023

If you’re reading this, chances are you’ve played around with using AI tools like ChatGPT or GitHub Copilot to write code for you. So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. And if I switch tabs to view a paper from 2008, then a song from 2008 could start up.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 11, 2020

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.

Network 40

Network Servers Processing Software Engineering 40

O'Reilly

SEPTEMBER 19, 2023

” Each step has been a twist on “what if we could write code to interact with a tamper-resistant ledger in real-time?” Mental contortions led to code contortions led to frustration. Similarly, Monte Carlo simulations can help us spot trends and outliers in potential outcomes of a process.

Hardware 99

Hardware Storage Big Data Blockchain 99

The Agile Manager

JUNE 29, 2008

This content is derived from material presented in a ThoughtWorks-sponsored webcast in June 2008. Changing the way work is performed is no simple task. Process is important , but we’re on the payroll to deliver solutions ; we’re not on the payroll just to have really great processes.

Code 45

Code Availability Processing Performance 45