https://d2908q01vomqb2.cloudfront.net/887309d048beef83ad3eabf2a79a64a389ab1c9f/2021/10/21/DBBLOG-1602-ARCH-DIAG.png

Configure a standalone SQL Server node as database availability replica of a SQL Server failover cluster instance

AWS provides three ways to create highly available SQL Server databases. Most customers use the single-click Multi-AZ Am...

aws.amazon.com 10 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/automatic-tuning-options.png

26th Oct 2021

Automatic Index advisor in Azure SQL database

This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database. Azure SQL Database ...

sqlshack.com 7 mins

https://juliandontcheff.files.wordpress.com/2021/10/time_out_0.gif

26th Oct 2021

Session settings and timeouts in OCI

The following question in the Oracle Groundbreakers Developer Community forum made me investigate on how to change the s...

juliandontcheff.wordpress.com

26th Oct 2021

What is an In-Memory Database?

Using real-world examples and plain language, Bobby Coates, SingleStore Product Marketer, provides a comprehensive overv...

singlestore.com 3 mins

https://d2908q01vomqb2.cloudfront.net/1b6453892473a467d07372d45eb05abc2031647a/2021/10/12/graphql6.png

26th Oct 2021

Monitoring and tuning federated GraphQL performance on AWS Lambda

This post is written by Krzysztof Lis, Senior Software Development Engineer, IMDb. Our federated GraphQL at IMDb distrib...

aws.amazon.com 6 mins

https://blog.devart.com/wp-content/uploads/2021/08/dbforge-studio-for-mysql-download.png

26th Oct 2021

Different Ways to Back up MySQL Databases and Tables

The article provides an overview of the backup types available in MySQL and describes how-to examples of using the mysql...

blog.devart.com 8 mins

https://www.enterprisedb.com/sites/default/files/edb-og-default-image.jpg

26th Oct 2021

Five Cool Things to Look for in EDB Postgres Advanced Server 14

Check out five of the most significant improvements being added for the benefit of customers of EDB Postgres Advanced Se...

enterprisedb.com

https://mariadb.com/wp-content/uploads/2021/10/maxscale-top-filter-social.png

26th Oct 2021

MariaDB MaxScale Top Filter

In this blog, I am going to discuss using the MaxScale Top filter for query analysis and, in particular, how to use it t...

mariadb.com 6 mins

https://blog.crunchydata.com/hubfs/blog1015.png#keepProtocol

26th Oct 2021

Encrypting Postgres Data at Rest in Kubernetes

Encrypting data at rest is often an important compliance task when working on securing your database system....

blog.crunchydata.com 3 mins

26th Oct 2021

How to Rebuild the SQL Server Tempdb Database

In one of our previous articles, we discussed how to rebuild the SQL Server system databases. However, sometimes it is n...

mssqltips.com 3 mins

26th Oct 2021

Options to Perform backup of Azure SQL Database – Part 1

I am aware that automatic backups occur for Microsoft Azure SQL Database and that we could use the automatic backups to ...

mssqltips.com 6 mins

https://res.cloudinary.com/practicaldev/image/fetch/s--xdl4eDa---/c_imagga_scale,f_auto,fl_progressive,h_500,q_auto,w_1000/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5pfg1g1wx3b2gzdgzx0u.png

26th Oct 2021

Kubernetes Logging in Production

Historically, in monolithic architectures, logs were stored directly on bare metal or virtual machines. They never left ...

dev.to 9 mins

https://sqlperformance.com/wp-content/uploads/2021/10/paul-randal-sync-stats-featured.png

26th Oct 2021

Tracking Synchronous Statistics Updates

The SQL Server query optimizer makes use of statistics during query compilation to help determine the optimal query plan...

sqlperformance.com 5 mins

https://d2908q01vomqb2.cloudfront.net/827bfc458708f0b442009c9c9836f7e4b65557fb/2020/06/03/Blog-Post_thumbnail.png

26th Oct 2021

Introducing geospatial queries for Amazon DocumentDB (with MongoDB compatibility)

Amazon DocumentDB (with MongoDB compatibility) is a database service that is purpose-built for JSON data management at s...

aws.amazon.com 3 mins

https://www.red-gate.com/simple-talk/wp-content/uploads/2021/10/AzureRouting01.png

26th Oct 2021

Routing Access to Azure Services

Azure is part of the Microsoft Global Network. Applications in the Azure environment can receive access from the entire ...

red-gate.com 3 mins

https://stevestedman.com/wp-content/uploads/2021/09/Generic_error_message.png

25th Oct 2021

Cannot resolve the collation conflict

One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t ...

stevestedman.com 3 mins

https://www.red-gate.com/simple-talk/wp-content/uploads/2021/10/word-image-16.png

25th Oct 2021

Introduction to SQL Server sequence objects

SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set u...

red-gate.com 12 mins

25th Oct 2021

Kubesail's PiBox mini 2 - 16 TB of SSD storage on a Pi

Many months ago, when I was first testing different SATA cards on the Raspberry Pi Compute Module 4, I started hearing f...

jeffgeerling.com 3 mins

https://www.percona.com/blog/wp-content/uploads/2021/10/Comparing-Graviton-Performance-to-Intel-and-AMD-for-MySQL.png

25th Oct 2021

Comparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 2)

Recently we published the first part of research comparing Graviton (ARM) with AMD and Intel CPU on AWS. In the first pa...

percona.com 4 mins

25th Oct 2021

Db2Night Show #Z120: Building Blocks of Db2

100% of our studio audience learned something!Jim provided an excellent introduction and refresher of Db2 access paths. ...

dbisoftware.com

https://stevestedman.com/wp-content/uploads/2021/10/cyclone_bomb.png

25th Oct 2021

Pulling PSE Outage Data Into SQL Server

As part of documenting the craziness of this storm I have created a script that I run every 5 minutes that pushes data i...

stevestedman.com

25th Oct 2021

Video : DBMS_CLOUD : External Tables

In today’s video we’ll demonstrate the functionality of the DBMS_CLOUD package, with specific reference to external tabl...

oracle-base.com

https://s33046.pcdn.co/wp-content/uploads/2021/10/azure-data-factory-portal.png

25th Oct 2021

Creating metadata-driven data pipelines using Azure Data Factory

In this article, we will learn how to build metadata-driven pipelines using Azure Data Factory....

sqlshack.com 7 mins

https://www.microsoft.com/security/blog/uploads/securityprod/2021/10/Untitled-6175d431a6a9f.png

25th Oct 2021

NOBELIUM targeting delegated administrative privileges to facilitate broader attacks

The Microsoft Threat Intelligence Center (MSTIC) has detected nation-state activity associated with the threat actor tra...

microsoft.com 15 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/welcome-screen-of-psqlodbc-setup.png

22nd Oct 2021

Configure ODBC drivers for PostgreSQL

In this article, we are going to understand the process to configure the ODBC driver for PostgreSQL. For the demonstrati...

sqlshack.com 4 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/high-availability-approach.png

21st Oct 2021

High Availability in Azure Database for PostgreSQL

In this article, we will learn about the high availability features recently introduced in Azure Database for PostgreSQL...

sqlshack.com 6 mins

https://www.red-gate.com/simple-talk/wp-content/uploads/2021/10/word-image-13.png

21st Oct 2021

Performance of querying blob storage with SQL

It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares sever...

red-gate.com 11 mins

https://sqlperformance.com/wp-content/uploads/2021/09/0-vs-null-featured.png

21st Oct 2021

Bad Habits: Avoiding NULL in SQL Server

A long time ago, I answered a question about NULL on Stack Exchange entitled, “Why shouldn’t we allow NULLs?” I have my ...

sqlperformance.com 5 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/database-creation-is-in-process.png

19th Oct 2021

Creating databases in Oracle 19c using the Database Configuration Assistant

In this article, we understand how to create a new database in Oracle 19c using a database configuration assistant. The ...

sqlshack.com 7 mins

19th Oct 2021

How Do You Store Boolean Data in Db2?

Recently, I was reading an article written by Ben Brumm on using Boolean data in SQL and it got me thinking about Db2 an...

db2portal.blogspot.com

https://postgres.ai/assets/thumbnails/postgresql-query-for-lock-trees-analysis-2.png

19th Oct 2021

Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues)

For OLTP workloads (such as web and mobile applications), it is important to understand object-level and row-level locks...

postgres.ai

19th Oct 2021

SQL Server Availability Group Maintenance with Distributed Availability Groups

In a previous tip on Configure Distributed Availability Groups for SQL Server Disaster Recovery with Failover Clustering...

mssqltips.com 5 mins

https://www.red-gate.com/simple-talk/wp-content/uploads/2021/09/PortalView01.png

19th Oct 2021

Creating Views in Azure Portal

Resource groups and subscriptions sometimes are not enough to organize the content of our Azure Portal. I was preparing ...

red-gate.com

https://i1.wp.com/lefred.be/wp-content/uploads/2021/10/mysql_shell_PIP.png?fit=1030%2C575&ssl=1

18th Oct 2021

MySQL Shell and extra Python modules

When you use MySQL Shell with extra Python plugins (like these available on GitHub), sometimes, you could need extra Pyt...

lefred.be

https://dallasdbas.com/wp-content/uploads/2021/10/tugboat-4891606.jpg

18th Oct 2021

Do Full Backups Break Log Shipping?

TLDR: Nope. Keep on doing your full backups....

dallasdbas.com

https://stevestedman.com/wp-content/uploads/2021/10/Question-Mark-4.png

18th Oct 2021

How Do I Get Started with SQL Server?

The question comes up occasionally about how people can get started with Microsoft SQL Server? This is often people who ...

stevestedman.com

18th Oct 2021

First contact with OCI’s Autonomous Database

Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But w...

blog.dbi-services.com 4 mins

18th Oct 2021

The DB2Night Show #238: Lessons Learned: Building Db2 HADR Clusters on AWS

100% of our studio audience learned something!Phil gave a detailed presentation the how-tos of using Db2 in the cloud. W...

dbisoftware.com

18th Oct 2021

What’s in your SQL Server error log?

This is my 50th blog post! I’m going to do something a bit special. I’ve found the SQL Server error log to be slightly u...

erikdarlingdata.com

https://i0.wp.com/lefred.be/wp-content/uploads/2021/10/mysql_shell_report.png?fit=1030%2C575&ssl=1

18th Oct 2021

Best way to start a thread when looking for MySQL Help and more

I’m active on multiple platforms (mail, slack, forums, …) and often, when people are looking for help, the first 5 or 10...

lefred.be 4 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/how-to-check-constraints-improve-query-performance-1.png

18th Oct 2021

How to use SQL Check Constraints

This article intends to give comprehensive information about the usage and other details of SQL check constraints. The c...

sqlshack.com 4 mins

https://cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/4b674f37-c893-4139-9101-7643ca30cb7d/File/e42c371d1008c3d3c82f215536f78316/mds_inbound_terraform_2_6x4.png

15th Oct 2021

MySQL Database Service Replication: deployment with Terraform

In the previous post we saw how to easily deploy (in just some mouse clicks) MySQL Database Service on two different reg...

blogs.oracle.com 4 mins

15th Oct 2021

Cosmos DB Data Migration Between Containers using Databricks and PySpark

Azure Cosmos DB is a fully managed, fast and cost-effective NoSQL database with multi write data distribution to any Azu...

mssqltips.com 7 mins

https://arctype.com/blog/content/images/2021/10/enable-mysql-replication-730x410.png

15th Oct 2021

Set Up MySQL 8 Master-Slave Replication on Ubuntu 20.04

MySQL is an open-source and one of the most widely used relational database management systems. Setting up a separate My...

arctype.com 4 mins

https://blog.yugabyte.com/wp-content/uploads/2021/10/1014-Secondary-Index-Queries-Social.png

15th Oct 2021

How a Distributed SQL Database Boosts Secondary Index Queries with Index Only Scan

A distributed SQL database reads from remote nodes, which increases the need for optimal data access....

blog.yugabyte.com 11 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/view-event-sequence.png

15th Oct 2021

SQL Server Extended Events Causality Tracking

This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulnes...

sqlshack.com 6 mins

https://s33046.pcdn.co/wp-content/uploads/2021/10/sysprocesses-details-for-backup-database-statement.jpeg

15th Oct 2021

Performance impact analysis of enabling Transparent Data Encryption (TDE) on SQL Server

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to s...

sqlshack.com 7 mins

https://cdn.thenewstack.io/media/2021/10/80b93065-blog-banner.png

15th Oct 2021

Chaos Engineering for Cloud Native

ChaosNative sponsored this post. In today’s eCommerce world, customer retention, customer acquisition and customer satis...

thenewstack.io 7 mins