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
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
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
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
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
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
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
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
18th Oct 2021 Do Full Backups Break Log Shipping? TLDR: Nope. Keep on doing your full backups.... dallasdbas.com
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
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
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
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
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
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
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
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
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
14th Oct 2021 What is Kubernetes? A Step-by-Step Guide with Real-World Illustrations The word Kubernetes and the technicality involved in it look cryptic for many non-technical professionals and beginners.... blog.cloudthat.com 7 mins
14th Oct 2021 MySQL on Kubernetes demystified Marco, why did you write this long article? Yes, it is long, and I know most of the people will not read it in full, but... tusacentral.com 27 mins
14th Oct 2021 GraphQL 101: What is GraphQL? Most people within the tech world have heard of GraphQL at this point. Adoption is also booming at steady rates. There’s... dgraph.io 12 mins
14th Oct 2021 Migrating MongoDB to Kubernetes This blog post is the last in the series of articles on migrating databases to Kubernetes with Percona Operators. Two pr... percona.com 7 mins
13th Oct 2021 How To Change RMAN Config For Standby DB [[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 12 21:04:04 2021 Versio... mdinh.wordpress.com
13th Oct 2021 SQL Server Network Related Performance Monitor Counters You could have a blazingly fast SQL Server with enough memory and CPU, and fast disk, but if there is a network issue fi... mssqltips.com 4 mins
13th Oct 2021 SQL Server on Physical Machine Best Practices The intent of this post is a quick reference guide based on the recommendation made on Pure Storage Support page in the ... nocentino.com 4 mins
12th Oct 2021 3 Important Queries for Testing Your Availability Group Endpoints Time flies, seasons are flying by and seemingly changing day by day. We have slippery slopes here, there, and everywhere... jasonbrimhall.info 6 mins
12th Oct 2021 Using OSQL.EXE to run a scheduled task on SQL Server Express Edition One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule... stevestedman.com
12th Oct 2021 MySQL Database Service Replication: easy deployment with Terraform Recently, we discovered how to setup Disaster Recovery in OCI MySQL Database Service using inbound/outbound replication.... blogs.oracle.com
12th Oct 2021 Monitoring SQL Server blocking problems In this article, we will learn how to monitor SQL Server blocking issues with different methods. In relational databases... sqlshack.com 6 mins
12th Oct 2021 What is Db2? For regular readers of this blog the title of this particular post might seem to be a bit odd. After all, why visit the ... db2portal.blogspot.com
11th Oct 2021 Linux buffered write latency This blogpost is about doing buffered writes to a linux filesystem, and latency fluctuations that it could show you, esp... dev.to 4 mins
11th Oct 2021 Be Careful Where You Call Inline Table Valued Functions While helping someone tame a bunch of rather unfortunate scalar valued functions, we eventually hit a point where they w... erikdarlingdata.com
11th Oct 2021 Creating Delta Lake Tables in Azure Databricks In this article, we will learn how to create a delta table format in Azure Databricks. In modern data engineering, vario... sqlshack.com 6 mins
11th Oct 2021 KISS principle : SQL patches to the rescue On my last blog post i described a particular problem we faced recently following a database upgrade.... mahmoudhatem.wordpress.com
8th Oct 2021 6 Critical Questions to Boost Your Cloud Database Performance Cloud databases and database-as-a-service (DBaaS) solutions can offer significant advantages over the on-premise databas... enterprisedb.com
8th Oct 2021 Let's learn about Indexes in MongoDB In this article, let us learn about indexes in MongoDB. So let us what an index in database is and what purpose it serve... dev.to 4 mins
8th Oct 2021 An Engineer's Guide to Building a Database for Data-Intensive Applications As a developer you spend a lot of time making choices. Do you use React or Vue for your web app? Will your algorithm run... singlestore.com 17 mins
7th Oct 2021 How to Build a Squad Health Check Application with Redis Squad health checks are crucial for businesses to assess the team chemistry of their workforce. They pave the way for a ... redis.com 6 mins
7th Oct 2021 DB Optimizer I’ve rediscovered this list of articles by Stefan Koehler on my laptop; it has a bias towards SAP users, and it’s severa... jonathanlewis.wordpress.com
7th Oct 2021 The Benefits of a Hybrid Transactional and Analytical Processing Database Hybrid Transactional and Analytical Processing (HTAP) is a defining feature of TiDB. But what is it and why is it so imp... pingcap.com 8 mins
7th Oct 2021 MySQL Database Service inbound replication channel troubleshooting Using a MySQL Database Service instance in OCI as an asynchronous replica is very useful. It allows testing the service ... blogs.oracle.com 11 mins
7th Oct 2021 Restore to SQL Managed Instance Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into sep... blobeater.blog
