Getting to Know the CIS Benchmarks

When the Center for Internet Security (CIS) was formed in 2000, the IT and cybersecurity industries identified a clear need to understand how to secure IT systems and data. This need highlighted a lack of hardening recommendations, particularly prescriptive and industry-recognized standards.

cisecurity.org

https://sqlstudiesdotcom.files.wordpress.com/2018/08/blackboadicon.jpg?w=159

18th May 2022

Getting a list of the articles in a publication.

The other day I was asked to supply a list of all of the tables being replicated into a given database.

sqlstudies.com

https://s33046.pcdn.co/wp-content/uploads/2022/05/using-extended-properties-in-sql-server.png

18th May 2022

How to write readable T-SQL queries

This article intends to give some beneficial suggestions that help to write a more readable T-SQL query. The major expectation from a code is that it works properly and generates the expected outputs.

sqlshack.com

18th May 2022

Getting Started with Query History and Table Designer in Azure Data Studio

Developers and DBAs run multiple queries while connecting to a SQL Server, so how can you view a history of the queries executed? Similarly, you might be familiar with table designers in SSMS.

mssqltips.com

18th May 2022

Kubernetes 1.24: Prevent unauthorised volume mode conversion

Kubernetes v1.24 introduces a new alpha-level feature that prevents unauthorised users from modifying the volume mode of a PersistentVolumeClaim created from an existing VolumeSnapshot in the Kubernetes cluster.

kubernetes.io

16th May 2022

Introducing CIS Workbench

Communities are vital to the work we do at the Center for Internet Security (CIS). For years, expert IT volunteers from around the world have helped us develop, review, edit, and maintain the secure configuration recommendations contained in every CIS Benchmark.

cisecurity.org

https://www.virtual-dba.com/media/Difference-between-Blocking-and-Deadlocks.jpg

16th May 2022

The Difference Between Blocking and Deadlocks

When I was learning about Microsoft SQL Server issues a DBA needs to understand, I was reading about deadlocks. At first, I was confused because it sounded like the definition of blocking, which I was already more familiar with. I re-read it a couple of times and still wasn’t getting it.

virtual-dba.com

https://www.red-gate.com/simple-talk/wp-content/uploads/2019/06/SimpleTalk.png

16th May 2022

The nuances of MySQL indexes

Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.

red-gate.com

16th May 2022

Recover Recently Closed Tab in SSMS

If you work with SQL Server, it's highly likely you work with SQL Server Management Studio (SSMS). And if you use it with any frequency, it's also highly likely you've run into one of these annoying scenarios before. It may appear you've lost your work and need to start over.

mssqltips.com

16th May 2022

Queries in PostgreSQL: 4. Index scan

In previous articles we discussed query execution stages and statistics. Last time, I started on data access methods, namely Sequential scan. Today we will cover Index Scan. This article requires a basic understanding of the index method interface.

postgrespro.com

https://dev.to/social_previews/article/1084275.png

16th May 2022

When are you running too much on linux?

In the old days, things were simpler. Computer systems were running in the server room in the office building, hopefully the server was carefully sized, unix operating systems ran processes, and when a server was overloaded, processes waited in the runqueue. In todays world, this is different.

dev.to

https://dz2cdn1.dzone.com/storage/article-thumb/15882408-thumb.jpg

16th May 2022

Rebuild System Databases in SQL Server

Learn about system database corruption and what it means. If corruption in system databases occurs, is a problem because it will cause the SQL Server to stop. In this article, we will talk about system database corruption. It means that one or more system databases are corrupted.

dzone.com

https://assets.zilliz.com/Deep_Dive_7_baae830823.png

16th May 2022

How Does the Database Understand and Execute Your Query?

This article is transcreated by Angela Ni. A vector query in Milvus is the process of retrieving vectors via scalar filtering based on boolean expression. With scalar filtering, users can limit their query results with certain conditions applied on attributes of data.

milvus.io

https://i0.wp.com/lefred.be/wp-content/uploads/2022/05/graph_a_day.png?fit=1024%2C576&ssl=1

16th May 2022

A graph a day, keeps the doctor away ! – MySQL Checkpoint Age

In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs.

lefred.be

https://www.scylladb.com/wp-content/uploads/1200x628-fb-what-do-you-mean-distributred.png

16th May 2022

Distributed Databases Compared

The past decade saw the rise of fully distributed databases. Not just local clustering to enable basic load balancing and provide high availability — with attributes such as rack awareness within a datacenter.

scylladb.com

http://dallasdbas.com/wp-content/uploads/2018/08/LinkedIn-150x150.jpg

16th May 2022

Restore Database or Restore Log?

How long has this worked, and why didn’t anyone tell me? Thanks for reading!

dallasdbas.com

https://datatechnologytoday.files.wordpress.com/2022/05/fiber-optic-wires-in-light-uid-2-edited.jpg

11th May 2022

Bad Database Standards

Several years ago I wrote a series of blog posts on bad database standards, that is, things you should avoid doing when creating the standards for your organization regarding database systems and development.

datatechnologytoday.wordpress.com

11th May 2022

How to Encrypt and Decrypt CSV File in SSIS

You have a SSIS Package that extracts data from a SQL Server database and saves it to a csv file for your customer to pick up at a secure SFTP location. Now your customer asks you to encrypt the file before you drop it in the SFTP location as it is sensitive data.

mssqltips.com

11th May 2022

How to run Kubernetes clusters locally on Windows

Kubernetes production clusters are typically run on cloud platforms. However, running and deploying Kubernetes applications on cloud platforms such as Google Kubernetes Engine is costly. These high costs can restrict the Kubernetes learning process for beginners.

red-gate.com

https://cdn.thenewstack.io/media/2022/05/e1180b33-architecture-g7d57697cc_640.jpg

11th May 2022

5 Best Practices for Securing Kubernetes Runtime Monitoring

The Cloud Native Computing Foundation sponsored this post in anticipation of KubeCon + CloudNativeCon EU 2022 on May 16-20, in Valencia, Spain.

thenewstack.io

https://www.brentozar.com/wp-content/uploads/2021/06/Brent_Ozar_Luftgekuhlt.jpg

11th May 2022

Don’t Treat SQL Like a Programming or Scripting Language.

In a programming language like C# or Java, you tell the computer what to do, in order. Get the customers from California, then get their invoices, then sum the total.

brentozar.com

10th May 2022

Crazy Interview Questions

Redgate had a discussion recently among our developers about our interview process and questions. There has been a standard question asking candidates about 2D arrays, but as one developer pointed out, we don’t use these in our code base. So, why do we ask candidates about this topic?

voiceofthedba.com

https://stevestedman.com/wp-content/uploads/2022/05/common-database-mistakes.png

10th May 2022

3 Common Database Mistakes Business Owners Make

Stedman Solutions Posted on Posted in Backup, Classes, Corruption, Database Health, Performance, Ransomware, Recovery Tagged with cyber attack, database maintenance, ransomware, sql server backup, SQL server corruption, SQL Server maintenance

stevestedman.com

https://devclass.com/wp-content/uploads/2022/05/brackets.jpg

10th May 2022

Visual Studio Code update: First steps with profile support

Microsoft and the Visual Studio Code (VS Code) team have rolled out version 1.67 of the Electron-based editor that has become the world’s favorite IDE – StackOverflow’s last survey reckoned it was used by 71.06% of respondents, more than double the usage of second-placed Visual Studio.

devclass.com

https://www.cybertec-postgresql.com/wp-content/uploads/2022/04/timezone.png

10th May 2022

Time zone management in PostgreSQL

Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL’s implementation of timestamp with time zone is somewhat surprising.

cybertec-postgresql.com

https://blog.dbi-services.com/wp-insides/uploads/sites/2/2022/05/MySQLK8s.png

10th May 2022

Installing MySQL InnoDB Cluster in OKE using a MySQL Operator

During previous months, I’ve had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes.

blog.dbi-services.com

10th May 2022

Moodle PostgreSQL load balancing with HAProxy and Patroni

Moodle is a popular Open Source online learning platform. Especially since the beginning of the COVID-19 pandemic the importance of Moodle for schools and universities has further increased.

credativ.de

https://www.red-gate.com/simple-talk/wp-content/uploads/2022/05/word-image.png

10th May 2022

Working with MySQL stored functions

Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.

red-gate.com

9th May 2022

Video : Ansible Playbooks : Tags

In today’s video we demonstrate how to use handlers in Ansible Playbooks. The video is based on the following article.

oracle-base.com

9th May 2022

Search all String Columns in all SQL Server Tables or Views

Back in 2015, I wrote a tip called Search all string columns in all SQL Server databases. That tip focused on finding strings within string-based columns in all tables across all user databases.

mssqltips.com

9th May 2022

Easily Deploy SQL Server Failover Cluster Instance on AWS

For this article, I will share with you how you can launch your SQL Server Failover Cluster instance complete with shared storage on Amazon FSx via the AWS Launch Wizard.

mssqltips.com

7th May 2022

The DB2Night Show #245: Db2U Current Capabilities and Future Direction

100% of our studio audience learned something!Aruna & Janpreet described the capabilities and intended direction for Db2U and containerization. Watch the replay... This show has valuable info and demos. Search #DB2Night to learn more.

dbisoftware.com

https://dist.neo4j.com/wp-content/uploads/20220506092830/10-Things-You-Can-Do-With-Cypher.png

7th May 2022

10 Things You Can Do With Cypher That Are Hard With SQL

Editor’s note: This presentation was given by Michael Hunger in December 2021 at Neo4j Connections: Graphs for Cloud Developers. SQL has been around for a long time; it’s a powerful query language, but there are some things that just make more sense in Cypher.

neo4j.com

https://www.highgo.ca/wp-content/uploads/2022/05/2pc2.png

7th May 2022

Atomic Commit with 2 Phase Commit in FDW Distributed Setup

PostgreSQL’s 2 phase commit (2PC) feature allows a database to store the details of a transaction on disk without committing it. This is done by issuing PREPARE TRANSACTION [name] command at the end of a transaction block.

highgo.ca

7th May 2022

The benefits of database change management

Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.

red-gate.com

https://scalegrid.io/blog/wp-content/uploads/2022/04/MySQL-DigitalOcean-Guide-ScaleGrid-280x150.jpg

7th May 2022

How to Deploy MySQL on Ubuntu and Fully Managed

In this blog post, we will show you a step-by-step guide on how to install and set up a MySQL server both manually on the Ubuntu 20.04 operating system, as well as by using ScaleGrid’s managed database service.

scalegrid.io

https://s33046.pcdn.co/wp-content/uploads/2022/05/sql-query-to-create-postgresql-database.png

5th May 2022

Learn PostgreSQL: Managing PostgreSQL databases

In this article, we will be learning how we can manage the PostgreSQL database. I am covering the following topics. I have installed PostgreSQL on my workstation. You can read the How to install PostgreSQL on Windows to learn the step-by-step installation of PostgreSQL on windows 10.

sqlshack.com

https://www.brentozar.com/wp-content/uploads/2020/05/Brent-Ozar-Bandanna-Pattern-449x400.png

5th May 2022

The Top Feature Requests for SQL Server

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too. Want to advertise here and reach my savvy readers?

brentozar.com

5th May 2022

PowerShell for the DBA - Basic Functions

Moving forward with the series, I would like to shift attention to functions in PowerShell. Functions can help us encapsulate very specific logic in our applications and re-use that logic in many different places, keeping our code cleaner, more compact and modular.

mssqltips.com

4th May 2022

Investigating Locking in Db2

The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table.

virtual-dba.com

https://joshuaotwell.com/wp-content/uploads/2022/04/substack-mysql-rollup.png

4th May 2022

MySQL GROUP BY WITH ROLLUP – Substack Repost

I recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity…

joshuaotwell.com

3rd May 2022

What's New in MariaDB 10.6

As of January 2022, ClusterControl v1.9.2 introduced support for the latest version of MariaDB — version 10.6. MariaDB 10.6, released in July 2021, will be supported for the next four years or precisely until July 2026. In this post, we will highlight the top features of MariaDB 10.6.

severalnines.com

3rd May 2022

CIS Benchmarks May 2022 Update

The following CIS Benchmarks have been updated or recently released. We've highlighted the major updates below. Each Benchmark includes a full changelog that references all changes. A huge thank you to the CIS Android Community for making this Benchmark happen. Special thanks to Chantel Duckworth.

cisecurity.org

https://www.timescale.com/blog/content/images/2022/05/PIT-PostgreSQL-Database-Query-Monitoring--1-.png

3rd May 2022

Point-in-Time PostgreSQL Database and Query Monitoring With pg_stat_statements

Database monitoring is a crucial part of effective data management and building high-performance applications.

timescale.com

https://sqlundercover.files.wordpress.com/2022/05/pig-g958dcb18e_640.jpg

3rd May 2022

Resource Hog! What’s my busiest database?

Imagine that we’re seeing very heavy load on our SQL server, be it CPU or IO and we need to find out which database is the driver. I’m sure we’ve all been there at some point, sometimes it’s easy to tell.

sqlundercover.com

3rd May 2022

Video : Ansible Playbooks : Files and Templates

In today’s video we demonstrate how to use handlers in Ansible Playbooks. The video is based on the following article.

oracle-base.com

https://images.unsplash.com/photo-1490139753981-d33e0da2c26c?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=MnwxMTc3M3wwfDF8c2VhcmNofDF8fHBhc3Npbmd8ZW58MHx8fHwxNjUxMDYwMTUx&ixlib=rb-1.2.1&q=80&w=2000

2nd May 2022

MariaDB failing over primary to the replica.

In a previous post, we set up replication for MariaDB. This time we are failing over manually from the Primary node (master) to the Replica node (slave). We connect to mariadb01 as Primary.

blog.dbplatz.com

https://www.highgo.ca/wp-content/uploads/2022/04/blog2-Page-7.drawio-3.png

2nd May 2022

Upcoming feature in PostgreSQL 15 – MERGE statement

The MERGE statement is one of the long awaited features and it’s coming in the upcoming Major version of PostgreSQL 15.

highgo.ca