Remove 2016 Remove Availability Remove Azure Remove Code
article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

Let’s start with this: MongoDB is accurately referred to as source-available software. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments. 2016: The company adds service-loaded MongoDB Professional to its mix.

article thumbnail

Bucketizing date and time data

SQL Performance

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. DATE_BUCKET. Emulating DATE_BUCKET.

Azure 139
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The SQL Server Basic Installer: Just Install It!

SQL Server According to Bob

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
article thumbnail

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

SQL Server According to Bob

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. At first glance in SQL Server 2016, you can see if a database is encrypted for TDE by looking at sys.databases.is_encrypted. I then verified my findings in the source code. Notice what is below it.

Servers 40
article thumbnail

Introduction to Wait Statistics

SQL Performance

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
article thumbnail

Serverless at re:Invent 2017

The Symphonia

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.

article thumbnail

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

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.). This means there are no DTC components available for SQL Server 2017 on Linux. Helpful References.

Servers 40