Locking Hints Make Everything Confusing

Many people will go their entire lives without using or seeing a lock hint other than NOLOCK. Thankfully, NOLOCK only ever leads to weird errors and incorrect results. You’ll probably never have to deal with the stuff I’m about to talk about here.

erikdarlingdata.com

22nd Dec 2020

Top 3 Upgrade & Migration Mistakes

Upgrading and migrating databases can be a daunting exercise if it’s not something you practice regularly. As a result, upgrades routinely get dismissed as “not necessary right now” or otherwise put off until there is not really another option.

dallasdbas.com

22nd Dec 2020

How to install pgAdmin on Fedora, CentOS and Red Hat

Dave Page is Vice President and Chief Architect, Database Infrastructure, currently working in the CTO team on research and development, best practices with Postgres, and providing high-level guidance and support for key customers.

enterprisedb.com

22nd Dec 2020

How to perform a zero-downtime upgrade of Elasticsearch in production

Many users need their Elasticsearch clusters to always be available. And a lot of these same users also want to upgrade their Elasticsearch environment when a new version is released, so they can take advantage of all the new features and functionality.

elastic.co

22nd Dec 2020

Security is hard work

I was once a database administrator in charge of several SQL Servers hosting the databases of vendor apps. Right after taking the job, I began looking at things like backups and security. I was quite shocked to find that one of the most important SQL Servers in the firm had a blank sa password.

red-gate.com

22nd Dec 2020

2020: The year in review for Amazon DynamoDB

2020 has been another busy year for Amazon DynamoDB. We released new and updated features that focus on making your experience with the service better than ever in terms of reliability, encryption, speed, scale, and flexibility.

aws.amazon.com

22nd Dec 2020

SQL Server TCP: Having both Dynamic Ports and Static Port configured

Have you ever seen an SQL Server instance configured to listen on both “TCP Dynamic Ports” and “TCP (static) Port”? The documentation states that a value of “0” is actually enabling “TCP Dynamic Ports”.

blog.dbi-services.com

22nd Dec 2020

MariaDB Xpand for Distributed SQL Now GA

MariaDB Xpand, MariaDB’s new distributed SQL smart engine, has now been released as GA! With the GA release of Xpand, included with MariaDB Enterprise Server 10.5.

mariadb.com

22nd Dec 2020

SQL Server Availability Group Error 35246 missing sqlconf.dll

During a recent SQL Server instance upgrade, I was supposed to upgrade the SQL Server version of a particular instance from 2012 to 2016 which contains an Availability Group.

mssqltips.com

22nd Dec 2020

Edition Upgrade and Downgrade in SQL Server

Have you ever needed to upgrade or downgrade the SQL Server edition you already installed? Maybe you currently have Enterprise Edition and have discovered that you can save money on licensing if you downgrade to Standard Edition.

mssqltips.com

22nd Dec 2020

Orafce 3.14.0 released

I released Orafce 3.14.0. It is mostly bugfix release. Only implementation of unistr function is new. The most important fixed issue was missing dependency between functions (n)varchar2 and (n)varchar2_transform.

okbob.blogspot.com

22nd Dec 2020

ETL Antipattern: Load Processes that Don’t Scale

One of the most significant design considerations in ETL process development is the volume of data to be processed.

timmitchell.net

22nd Dec 2020

Batch Processing Massive Data Much Quicker with TiSpark

TiSpark is an Apache Spark plugin that works with the TiDB platform to answer complex online analytical processing (OLAP) queries. It is widely used by our customers to batch process their massive data and discover analytical insights.

pingcap.com

22nd Dec 2020

Tips for Storing Your MariaDB Backups in the Cloud

Having a good Disaster Recovery Plan is a must in all companies to prevent data loss or reduce downtime in case of failure. For this, backups are a basic point here, and it is essential to define which type of backup you need to create and where to store it.

severalnines.com

22nd Dec 2020

How to schedule Azure Data Factory pipeline executions using Triggers

In the previous articles, we discussed how to use the Azure Data Factory to move data between different data stores, how to transform data before writing it to a predefined sink, how to run an SSIS package using Azure Data Factory and how to use iterations and conditions activities in Azure Data Fac

sqlshack.com

22nd Dec 2020

The top 5 blockers of a Cloud Migration

What are the major blockers to an organisation’s cloud migration? The Flexera State of Cloud Report 2020 lists the 10 top reasons based on their research.

devopsgroup.com

22nd Dec 2020

10 Tips for a Successful Graph Data Science Project

Are you wondering how you can get started with graph data science (GDS)? In this blog post, we’re going to give you 10 project tips and some resources to guide you from the beginning of your graph data science project to its production.

neo4j.com

22nd Dec 2020

Scheduling SQL Scripts Using Jenkins – SQLServerCentral

There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, like when you use SQL Server Express edition. Mostly, the DBAs in this case is will choose to use the Windows task scheduler.

sqlservercentral.com

22nd Dec 2020

mysqldump Best Practices (Part 1): MySQL Prerequisites

What do you need to set up a successful mysqldump? Let's take a look. mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases.

dzone.com

22nd Dec 2020

Why Why Why Why?

Here’s a little puzzle – and if you don’t see the answer almost immediately you did need to read this note. The question comes from a thread on the Oracle Groundbreakers’ Forum – Instead of sysdate if I give date like ‘5-dec-2020’ it’s giving correct.

jonathanlewis.wordpress.com

22nd Dec 2020

Optimizing data warehouse storage

At Netflix, our current data warehouse contains hundreds of Petabytes of data stored in AWS S3, and each day we ingest and create additional Petabytes.

netflixtechblog.com

21st Dec 2020

Migrating an on-premises SQL Server database to Amazon RDS on VMware using SQL Server native backup and restore

Amazon RDS on VMware delivers managed SQL Server databases in on-premises VMware environments. Managing SQL Server can be complex and time-consuming, but RDS on VMware makes it easy to provision, scale, and operate SQL Server in VMware vSphere clusters.

aws.amazon.com

21st Dec 2020

Database Service Availability Summary – Grafana Dashboard

Database landscape become vast and we have seen unprecedented growth and usage of many database technologies in the organizations and no one size fit for all tool is available in the market to monitor all of those databases.

db.geeksinsight.com

21st Dec 2020

Video : Convert CentOS to Oracle Linux

In today’s video we’ll demonstrate how to convert a CentOS installation to an Oracle Linux installation. The video is based on this post.

oracle-base.com

21st Dec 2020

How to track data changes on Azure SQL Database

In this article, we will guide you through tracking data changes on the Azure SQL database and introduce common use case scenarios and learn how to get the most out of system-versioned tables.

sqlshack.com

21st Dec 2020

Disk file operations I/O

When Disk file operations I/O wait event starts showing at the top of the AWR it can consume a lot of CPU and freeze your database.

hourim.wordpress.com

21st Dec 2020

The case for SQL Server Agent 2.0 – SQLServerCentral

SQL Server Agent enables the ease of scheduling routine tasks without leaving the comfort zone of SQL Server Management Studio (SSMS). This system stores all its related data in the msdb database.

sqlservercentral.com

21st Dec 2020

Couchbase Support for Node-to-node Encryption

Couchbase supports node-to-node encryption or Cluster encryption by adding TLS based encryption to the connections between the nodes within a Couchbase cluster.

dzone.com

First 10 11 12 13 Last