SQL Server According to Bob

SEPTEMBER 9, 2019

To track the login statistical information, enable the sp_configure value ‘common criteria compliance enabled ‘ setting and restart SQL Server. The rows shown in this example belong to the sa user on my system. The information flow: Client sends login request to SQL Server. SQL Server creates new session object.

Servers 40

Servers Software Engineering Database Engineering 40

High Scalability

APRIL 14, 2020

has hours of system design content. They also do live system design discussions every week. Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). this is going to be a challenging journey for any backend engineer! PA File Sight monitors file access on a server in real-time. Who's Hiring?

Education 105

Education Software Engineering Scalability Engineering 105

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

High Scalability

MAY 12, 2020

has hours of system design content. They also do live system design discussions every week. Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). this is going to be a challenging journey for any backend engineer! PA File Sight monitors file access on a server in real-time. Who's Hiring?

Education 102

Education Software Engineering Scalability Engineering 102

High Scalability

JANUARY 11, 2022

When the server receives a request for an action (post, like etc.) The streaming data store makes the system extensible to support other use-cases (e.g. FUN FACT : In this talk , Rodrigo Schmidt, director of engineering at Instagram talks about the different challenges they have faced in scaling the data infrastructure at Instagram.

Design 334

Design Media Storage Logistics 334

High Scalability

APRIL 28, 2020

has hours of system design content. They also do live system design discussions every week. Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). this is going to be a challenging journey for any backend engineer! PA File Sight monitors file access on a server in real-time. Who's Hiring?

Education 102

Education Software Engineering Scalability Engineering 102

High Scalability

MARCH 30, 2020

has hours of system design content. They also do live system design discussions every week. Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). this is going to be a challenging journey for any backend engineer! PA File Sight monitors file access on a server in real-time. Who's Hiring?

Education 105

Education Software Engineering Engineering Big Data 105

High Scalability

MAY 26, 2020

has hours of system design content. They also do live system design discussions every week. Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). this is going to be a challenging journey for any backend engineer! PA File Sight monitors file access on a server in real-time. Who's Hiring?

Education 100

Education AWS Software Engineering Scalability 100

SQL Server According to Bob

MARCH 18, 2018

SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. What Is A Small System? It is a best practice keep the setting above 128.

Servers 40

Servers Best Practices Software Engineering Operating System 40

High Scalability

MARCH 24, 2020

Scrapinghub is hiring a Senior Software Engineer (Big Data/AI). You will be designing and implementing distributed systems : large-scale web crawling platform, integrating Deep Learning based web data extraction components, working on queue algorithms, large datasets, creating a development platform for other company departments, etc.

Education 105

Education Software Engineering Engineering Big Data 105

SQL Server According to Bob

JULY 31, 2018

The unlink or remove syscall makes changes to the file system so searching for the file by name returns no entries and when the file descriptor is closed the file is deleted. Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

Adrian Cockcroft

MAY 23, 2022

That got me a job at Cambridge Consultants Ltd as a software engineer writing code (mostly in C) for embedded real time signal processing and control systems. It also got me a side job looking after the new Unix systems they started to use, and in 1984 we were one of the first customers of Sun Microsystems.

C++ 98

C++ Software Engineering Education Engineering 98

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. SQL Server’s NewSequentialId () calls the Windows API UuidCreateSequential , which is limited in SQLPAL, prior to the CU 4 update. Question: What if I change the time of the system clock? Reference: UUID RFC.

Servers 40

Servers Software Engineering Database Network 40

SQL Server According to Bob

DECEMBER 10, 2018

SQL Server Books Online documents Instant File Initialization and the associated security considerations. This blog highlights the underlying file system implementations and differences in behavior between Windows and Linux. SQL Server performs the following API calls when creating or extending (growing) data and log files.

Servers 40

Servers Speed Database Software Engineering 40

SQL Server According to Bob

JANUARY 31, 2017

If my memory serves me correctly SQL Server started using the ReadFileScatter and WriteFileGather APIs in SQL Server 6.5 On Linux the capabilities are called “ Vectored I/O.” – Example writev SQL Server on Linux takes full advantage of vectored I/O, retaining the performance and design benefits.

Servers 40

Servers Software Engineering Operating System Database 40

SQL Server According to Bob

OCTOBER 24, 2019

Unfortunately, the timings were always small and not something the SQL Server engine was doing, instead the client was closing the connection. In fact, I was able to break the reproduction down to a single connection using an idle SQL Server so there was no impact from other workloads. Powershell Script.

Servers 40

Servers Network Software Engineering Traffic 40

High Scalability

MAY 4, 2022

Wynter is looking for system administrators, engineers, and developers to join its research panel. SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

FEBRUARY 1, 2022

Wynter is looking for system administrators, engineers, and developers to join its research panel. DevOps Engineer : At Kinsta , we set out to create the best managed hosting platform in the world. has hours of system design content. They also do live system design discussions every week. Who's Hiring?

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JULY 18, 2022

Wynter is looking for system administrators, engineers, and developers to join its research panel. SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure.

Education 100

Education DevOps Infrastructure Scalability 100

Dynatrace

MAY 13, 2020

A single instance of OneAgent can handle the monitoring of many types of entities , including servers, applications, services, databases, and more. GPU-based machine learning system crashes, and you don’t know why? One of our software engineers, Tomasz Gajger, has been involved in a research project related to GPU performance analysis.

Infrastructure 135

Infrastructure Metrics Monitoring Software Engineering 135

High Scalability

JANUARY 8, 2019

Triplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Get visibility into your production issues without juggling multiple tabs and different services -- all of your logs, server metrics and alerts are in your browser and at your fingertips.

Java 137

Java Metrics Software Engineering DevOps 137

High Scalability

JUNE 10, 2022

Wynter is looking for system administrators, engineers, and developers to join its research panel. SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

DECEMBER 9, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. DevOps Engineer : At Kinsta , we set out to create the best managed hosting platform in the world. has hours of system design content. They also do live system design discussions every week. Who's Hiring?

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. DevOps Engineer : At Kinsta , we set out to create the best managed hosting platform in the world. has hours of system design content. They also do live system design discussions every week. Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

MARCH 3, 2020

Sisu Data is looking for machine learning engineers who are eager to deliver their features end-to-end, from Jupyter notebook to production, and provide actionable insights to businesses based on their first-party, streaming, and structured relational data. PA File Sight monitors file access on a server in real-time. Apply here.

Education 114

Education Games Engineering Java 114

High Scalability

MARCH 17, 2020

Sisu Data is looking for machine learning engineers who are eager to deliver their features end-to-end, from Jupyter notebook to production, and provide actionable insights to businesses based on their first-party, streaming, and structured relational data. PA File Sight monitors file access on a server in real-time. Apply here.

Education 105

Education Engineering Java Software Engineering 105

High Scalability

SEPTEMBER 29, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. DevOps Engineer : At Kinsta , we set out to create the best managed hosting platform in the world. has hours of system design content. They also do live system design discussions every week. Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

JULY 15, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

FEBRUARY 18, 2020

Sisu Data is looking for machine learning engineers who are eager to deliver their features end-to-end, from Jupyter notebook to production, and provide actionable insights to businesses based on their first-party, streaming, and structured relational data. PA File Sight monitors file access on a server in real-time. Apply here.

Education 113

Education Games Engineering Java 113

High Scalability

SEPTEMBER 15, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. DevOps Engineer : At Kinsta , we set out to create the best managed hosting platform in the world. has hours of system design content. They also do live system design discussions every week. Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

JUNE 29, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 8, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week.

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week.

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

DECEMBER 11, 2018

Triplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Get visibility into your production issues without juggling multiple tabs and different services -- all of your logs, server metrics and alerts are in your browser and at your fingertips.

Java 125

Java Metrics Software Engineering DevOps 125

High Scalability

FEBRUARY 9, 2020

Sisu Data is looking for machine learning engineers who are eager to deliver their features end-to-end, from Jupyter notebook to production, and provide actionable insights to businesses based on their first-party, streaming, and structured relational data. PA File Sight monitors file access on a server in real-time. Apply here.

Education 108

Education Games Engineering Java 108

High Scalability

DECEMBER 4, 2018

Triplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Get visibility into your production issues without juggling multiple tabs and different services -- all of your logs, server metrics and alerts are in your browser and at your fingertips.

Java 120

Java Metrics Software Engineering DevOps 120