Search

Tag: sql

View:
Paolo Valsecchi
  • Paolo Valsecchi
  • September 24, 2024

Configure PostgreSQL database for Horizon 8 events

Did you know you can store Horizon 8 event logs on Postgre SQL using Linux Ubuntu? It’s a great way to reduce costs by avoiding Windows licenses while maintaining high performance.
Read more
Daryna Havrada
  • Daryna Havrada
  • September 19, 2024

8 Most Common Types of Data Breaches and How to Prevent Them

Ransomware, phishing, insider threats – data breaches come in many forms. Learn how they happen and the steps you can take to stay secure in the new article.
Read more
Karim Buzdar
  • Karim Buzdar
  • February 8, 2022

How to Install and Use Osquery on Ubuntu and Linux Mint

Osquery is an open-source security compliance agent. It uses SQL to leverage a relational data model to describe a device. It’s great at providing all the contextual OS-related information you need in a simple, visually appealing form. Osequery is an all-time favorite compliance tool that is pleasant to use and great for security hardening.
Read more
Mikhail Rodionov
  • Mikhail Rodionov
  • October 12, 2021

Azure Key-Value Data Store Services Overview

 Azure key-value store services comprise a subset of NoSQL (non-relational) data services for semi-structured data, which offer you a key-value data store. Common use cases would be when you need: simplest and fastest NoSQL data store; fast, high-volume data ingestion; quick read-write operations; or when data structure/number per entity is varied. Sounds complicated, but we’ve laid it all out in simple terms.
Read more
Karim Buzdar
  • Karim Buzdar
  • September 21, 2021

How to install and use DBeaver in Linux

DBeaver is an open-source, free multi-platform database management software. It’s also an SQL client for developers and database administrators that has a user-friendly UI. It can be used as an alternative for MySQL-Workbench and PGAdmin to work with various databases, like MySQL, PostgreSQL, Greenplum, and others.
Read more
Florent Appointaire
  • Florent Appointaire
  • July 27, 2021

SQL Tools on a pod on AKS to manage your Azure SQL databases

Azure Kubernetes Service (AKS) is incredibly multifaceted. For example, you can test the connectivity of an SQL server that’s using a private endpoint connection to your AKS cluster using a pod. You can even manage SQL databases without deploying a VM or installing SQL Server Management Studio or other software.
Read more
Mikhail Rodionov
  • Mikhail Rodionov
  • October 15, 2020

Installing Oracle Database 19c on Windows Server 2019

Having an Oracle Database on hand for testing purposes is a handy endeavor. For example, if you want to test software integration capabilities or work with PL/SQL scripts. We’re not talking about configuring a full-blown production-ready Oracle. Just something useful and easy to have for you to test the work stuff that you need.
Read more
Volodymyr Perishko
  • Volodymyr Perishko
  • June 15, 2019

Can SQL Server Failover Cluster Instance run twice as fast as SQL Server Basic Availability Groups in 2-node cluster? Part 2: Studying FCI performance

In my previous article, I measured SQL Server Basic Availability Groups (BAG) performance. This, as it comes from the name, addresses SQL Cluster Failover Cluster Instance (FCI) performance. I expect SQL Server FCI to exhibit two times higher performance than BAG. Before I start, I’d like to tell you one important thing about this measurement. SQL Server FCI database resides on a StarWind virtual device. Why did I choose StarWind? Because I got their NFR license some time ago and decided to give this software-defined storage solution a shot. Let’s just hope that it won’t limit SQL Server FCI performance.
Read more
Didier Van Hoye
  • Didier Van Hoye
  • February 14, 2018

Replacing a Veeam Agent for Windows host while preserving existing local or share backups

Imagine you have a server with data source volumes that are backed up to local (or a share) target backup volumes with Veeam Agent for Windows (VAW). You might or might not backup the OS as well. That server is old, has issues or has crashed beyond repair and needs to be replaced. You don’t really care all that much about the server OS potentially but you do care about your data backup history! You don’t want to lose all those restore points. Basically, we try to answer how do you replace the backup server when it’s a local Veeam Agent for Windows 2.1 deployment.
Read more