Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps usually differ based on their scope. Is it limited to a certain SQL/process/task, or is it perceived as a database-wide slowdown?…

Read More >

An Introduction to Chrome Browser Management

Knowledge is power. The more information you can gather as an admin, the easier it is to manage the browsers that power your organization’s work. To simplify browser management and increase security, Google offers its Chrome Browser Cloud Management tool….

Read More >

Postgres Covering Indexes and the Visibility Map

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams has in progress. It seemed like some covering indexes weren’t working. I’ve been reading a book called Curious Moon,…

Read More >

How to Improve Healthcare Security With Google Chrome Security

The healthcare industry has become a huge target for cybercrime due to the overwhelming amount of critical patient information. To protect your patients and staff, the tech you use must have the highest level of security. Chrome Enterprise is widely…

Read More >

Chrome Enterprise in Healthcare: Positively Impacting the End-User Experience

The goal of technology in a healthcare setting is to simplify a care team’s work, not make it more complex. Plus, it should do its part in securing critical patient data. Google Enterprise and Chrome devices are a simple solution…

Read More >

Five ways to migrate your on-premises SQL database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

Read More >

The OCIDTAB – A solution to make OCI CLI scripting easier

This article is about working effectively with multiple OCI Environments via OCI CLI and encourages the use of an environment variable file called ocidtab, however before we look into it’s working the next couple of sections would give an understanding…

Read More >

VPN Options with Azure, Part 1: Azure to Site

As business entities move some of their services to Microsoft Azure Cloud (Azure), we see hybrid networks emerge that can span multiple physical sites and multiple cloud environments. Connecting those network segments securely can present some challenges. I’ve encountered two types…

Read More >

PostgreSQL Backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and third-party tools. For each, notes on the recovery point objective (or RPO, which is a measure of how up-to-date your application…

Read More >

SQL Encryption 101

Over the past month, I organized #DataSessions for the Singapore SQLPASS group. Singapore SQLPASS is the data platform user group community in Singapore. In June, we held free live webinars every Tuesday and live-streamed it on Facebook and YouTube. I…

Read More >
Page 5 of 365« First Page...34567...10...Last Page »