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. That is to ensure your database is encrypted at the file level. The process to enable this for a database is described in our documentation. What does encrypted mean at this point?

Servers 40

Servers Database Azure Cache 40

SQL Performance

MAY 29, 2019

From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Performance

OCTOBER 29, 2019

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. DMV data is always available, so very often it's the easiest method to get a quick first look at query performance. Example Scenario. ORDER BY qs.

C++ 74

C++ Database Servers Tuning 74

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. This feature is currently not available in T-SQL. At the date of this writing, there's not much information available out there about the true standard nested window functions. What nested window functions are not about.

Servers 83

Servers Availability Database Code 83

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

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Code that had duplication all over the place? Chances are you were dealing with legacy code that was written years ago. In my 15+ years of coding, every single time I've dealt with legacy code, fear, anger, hate, and suffering were pretty common.

Architecture 49

Architecture Database Code Systems 49

SQL Performance

MAY 7, 2019

The execution of SQL Server’s internal code is done using a mechanism called threads. Each thread can be executing SQL Server code, and multiple threads coordinate together when a query runs in parallel. These threads are created when SQL Server starts, depending on the number of processor cores available for SQL Server to use.

Servers 40

Servers Azure Metrics Tuning 40

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. You can find coverage of RPR, including illustrated examples, in a 90-page technical report ISO/IEC TR 19075-5 (available for free). Ticker ; CREATE TABLE dbo. STOCK1 2019-02-12 150.00

C++ 73

C++ Servers Virtualization Code 73

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

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

Smashing Magazine

JANUARY 21, 2019

A component is simply a set of pieces of HTML, JavaScript and CSS code put all together to create an autonomous entity. Following, the API will add the database object data. In other words, database object data is normalized. Recommended reading : A GraphQL Primer: Why We Need A New Kind Of API.

Social Media 64

Social Media Database Media Website 64

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. Red Hat, SUSE, HPE, Intel helping and confirming Linux behaviors and making file system code changes. The Back Story.

Servers 90

Servers Media Cache Storage 90

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. Specific improvements include A new code editor for those who write their Lambda functions in Javascript and Python, far superior to the old inline code-editor. We plan to test this out when we get the chance.

Serverless 40

Serverless Lambda AWS Traffic 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

Smashing Magazine

OCTOBER 26, 2018

Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code). Before we delve deeper in the code, a couple more things about WordPress REST API. on December 6th, 2016. Large preview ). Transients API.

Cache 78

Cache Website Speed Database 78

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. instructions are available. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available. SQL Server does not cross a 64-bit boundary when packing bits.

Servers 67

Servers Testing Metrics Storage 67

Alex Russell

MAY 9, 2022

Who owns this code? It's challenging for teams climbing the maturity ladder to sift through the many available browser and tool-vendor data points to understand which ones to measure and manage. They are charting a course based on better information because they are cognizant that it is both valuable and potentially available.

Performance 86

Performance Latency Metrics Engineering 86

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions. MSDTC can also be used as the XA TM if so desired (see example code at end of this post.). Transaction Monitor/Manager – Coordinator.

Servers 40

Servers Azure Engineering Java 40