SQL Performance

AUGUST 11, 2021

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

Azure Code Database Servers 139

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. 2017-07-04 10248 440.00 OrderValues.

Best Practices 108

Best Practices Servers Database Azure 108

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB. looking out for MongoDB Inc.

Open Source 83

Open Source Programming Database Servers 83

Particular Software

AUGUST 8, 2017

The new persister supports multiple database engines and uses raw ADO.NET and native SQL queries, without the need for an intermediate ORM. Up until now, our primary method of persisting data in relational databases used NHibernate, which was making it impossible to realize those dreams.

DevOps 40

DevOps Database Education Engineering 40

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.). Note: SQL Server Azure does not support DTC.

Servers 40

Servers Azure Engineering Java 40

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90

Servers Media Cache Storage 90