Start Using Binlogs: A Quick Guide

Best Online Courses to Learn MySQL

There are many ways for a database administrator to learn how to use a database programming language, including a book or tutorial, such as the one you are reading now. Some people prefer that method and everyone learns differently.

databasejournal.com

T-SQL Comment Best Practices for SQL Server

I need to understand more about commenting my Microsoft SQL Server Transact-SQL (T-SQL) code. What does it mean to comment a SQL query? How do I create comments? What is SQL syntax for comments? Are there any best practices for commenting code in a SQL database?

What Developers Need to Know About Table Partition Pruning

An overview and some solid tips for optimizing your table partitions. Table partitioning is a very handy feature supported by several databases, including PostgreSQL, MySQL, Oracle, and YugabyteDB.

dzone.com

What is SELECT FOR UPDATE in SQL (with examples)?

Relational databases are great for transactional workloads. But things can get messy when multiple transactions start trying to access the same data at the same time. Luckily, in many SQL databases there’s a solution for that: SELECT FOR UPDATE.

cockroachlabs.com

Get SQL Server database size with PowerShell

For various reasons, following the evolution of the data size of databases is interesting for a dba or for the application team. Most of the time, this is something built-in for monitoring tools – convenient to follow the evolution over the time.

dbi-services.com

Creating a Database Audit Specification can create new users & schemas in the background

I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on and off at need once created. That said, they do have a few gotchas. If you want every user put public as the principal.

sqlstudies.com

SQL Server 2022 Parameter Sensitive Plan Optimization: How PSP Works To Solve Some Parameter Sensitivity Issues

There are a bunch of reasons for those things. They’re not important here. What is important is the future, where SQL Server will have some more options for getting out of parameter sensitive jams.

erikdarlingdata.com

What is Elasticsearch and why use it?

Managing big data can be very taxing and stressful, especially when speed, reliability, scalability, and high availability are requirements for your organization.

severalnines.com

Shutting down nodes in Azure Kubernetes Service

A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in an Azure Kubernetes Service cluster.

dbafromthecold.com

Repeating Groups and 1NF (T&N)

Note: Then & Now (T&N) is a new version of what used to be the Oldies but Goodies (OBG) series.

dbdebunk.com

Video : Data Pump Checksums in Oracle Database 21c

In today’s video we demonstrate the use of Data Pump checksums in Oracle Database 21c. The video is based on part of this article.

oracle-base.com

SQL Aggregate Functions Having, Order By, Distinct, Partition By and more in SQL Server, Oracle and PostgreSQL

In the first part of this tip series, SQL Aggregate Functions in SQL Server, Oracle and PostgreSQL, we have seen the basic features of aggregate functions, with an overview of the most used and options such as GROUP BY and DISTINCT.

Security in MySQL: Part One

There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.

red-gate.com

blog.mclaughlinsoftware.com

MySQL Query from JSON

One of my students asked how you could get JSON data out in tabular format. I said they should look at Øystein Grøvlen’s JSON_TABLE – Best of Both Worlds blog post from 2018. Unfortunately, the wanted another example with the Video Store model that we use in class.

Understanding the OPENQUERY function in SQL Server

In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source.

sqlshack.com

Best practices for building a pain-free metadata store

What is metadata, exactly? Metadata is data about other data. That’s a very broad definition, though. When you start trying to get specific, it can get murky pretty quickly.

cockroachlabs.com

blog.mclaughlinsoftware.com

Blind SQL Injection – Threat or Child’s Play?

One of the primary issues in the database world is SQL injection – it’s prevalent to such an extent that even OWASP continuously lists it as the #1 threat targeting web applications.

arctype.com

23rd Jun 2022

Como el cambiar owner de todos nuestros jobs de un plumazo

Continuando con la entrada Listar jobs y su owners , os queremos mostrar cómo cambiar el owner de todos nuestros Jobs a través de T-SQL. Esto es algo que ya nos ha ocurrido en varios de nuestros proyectos con el fin de unificar la configuración de todos los Jobs, por ejemplo.

sicuel.es

23rd Jun 2022

Debugging deadlocks in PostgreSQL

Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some techniques on how to figure out the cause of a deadlock. To provoke the deadlock, we run the following transactions in parallel.

cybertec-postgresql.com

23rd Jun 2022

MySQL JSON Tricks

Are they really tricks or simply basic techniques combined to create a solution. Before writing these mechanics for using native MySQL to create a compound JSON object, let me point out that the easiest way to get one is to use the MySQL Node.

22nd Jun 2022

Ansible: Imagination is the Limit

As you might know, I have discovered Ansible 1 year ago. Since then, I am not using for its main purpose as wikipedia says: Ansible is an open-source software provisioning, configuration management, and application-deployment tool enabling infrastructure as code.

dbi-services.com

22nd Jun 2022

xp_cmdshell and sp_xp_cmdshell_proxy_account stored procedures in SQL Server

This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands. In brief, xp_cmdshell is a system stored procedure in SQL Server.

sqlshack.com

Tous les articles

The next task in my journey with DB2 is to apply a patch. In the world of DB2 there are Modification Packs and Fix packs. As far as I understand it, Modifications Packs come with new features,(…) Hi Team, Sometimes I was struggling with my VM to install and test my favorite software.

blog.dbi-services.com

blog.mclaughlinsoftware.com

MySQL Partitioned Tables

MySQL Partitioned Tables Learning Outcomes Learn about List Partitioning. Learn about Range Partitioning. Learn about Columns Partitioning. Learn about Hash Partitioning. Learn about Key Partitioning. Learn about Subpartitioning. Lesson Material MySQL supports partitioning of tables.

Implement Late Arriving Dimensions on Data Lakehouse using Azure Synapse Mapping Data Flow

This tip is part of the series of posts, dedicated to the building of end-to-end Lakehouse solutions leveraging Azure Synapse Analytics.

4 Database Access Control Methods to Automate

Torq sponsored this post. Regardless of which role a person has in an organization, they will always need access to one or more databases to be able to perform the functions of their job.

thenewstack.io

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

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

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

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.

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

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

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

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

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.

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

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

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

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

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

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

Restore Database or Restore Log?

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

dallasdbas.com

datatechnologytoday.wordpress.com

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.

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.

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

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