DBplatz

21st Jul 2022

New Wait Stats In SQL Server 2022

This is just a quick post to list out new wait stats in SQL Server 2022. How many will be useful, time will tell.

erikdarlingdata.com
21st Jul 2022

How to Resolve “Error Reading Relay Log Event” After Relay Log Corruption

In this blog, I explain how to recover from a replication failure caused by a corrupted relay log file. MySQL replica stores data received from its source binary log in the relay log file. This file could be corrupted due to various reasons, mostly hardware failures.

percona.com
21st Jul 2022

How to configure gremlinPool in Db2 Graph to prevent pod restart when excuting long-running queries

On CP4D, the default value of gremlinPool is not sufficient for long-running queries and the health-check code that automatically runs against the pod. When the long running loop query is running, THE value for gremlinPool is not sufficient to continue your query and respond to the health checks.

ibm.com
20th Jul 2022

PerfMon: Using SQL Server Performance Counters

Performance Monitor (PerfMon) is an inbuilt Windows Tool for monitoring all aspects of Windows and hosted applications such as SQL Server. Performance Metrics in PerfMon are referred to as counters. PerfMon counters can be visualized in real time.

sqlservercentral.com
20th Jul 2022

Per Key-Value Checksum

Silent data corruptions can severely impact RocksDB users. As a key-value library, RocksDB resides at the bottom of the user space software stack for many diverse applications. Returning wrong query results can cause unpredictable consequences for our users so must be avoided.

rocksdb.org
20th Jul 2022

The SQL Server Transaction Log, Part 4: Log Records

Previously I’ve talked about why logging is required and the architecture and circular nature of the log, so now it’s time to look at the real heart of the logging system—the log records themselves. As always, I recommend you read the previous posts in the series before reading this one.

sqlperformance.com
20th Jul 2022

Identify and Correct a Large SQL Server Error Log

Problem A customer sent an email complaining the drive on a Windows server was full and a lot of space was taken up by a folder that SQL Server uses. I did a little investigation and found what the issue was and how to resolve as shown below.

mssqltips.com
8th Jul 2022

ORA-00054 pt.2

This is the follow-up to an initial post that covered some details of using the errorstack and ksq traces as and aid to finding the cause of an intermittent ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

jonathanlewis.wordpress.com
8th Jul 2022

MySQL: Compression, Indexes, and Two Smoking Barrels

Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit. Now, what happens when that doesn’t happen?

percona.com
8th Jul 2022

Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022

This blog post is part of the SQL Server 2022 blog series. Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly improve the performance of your database workloads.

cloudblogs.microsoft.com
7th Jul 2022

SQL Server 2022 Parameter Sensitive Plan Optimization: How PSP Can Help Some Queries With IF Branches

I’ve spent a bit of time talking about how IF branches can break query performance really badly in SQL Server. We’re going to use a simple one parameter example to illustrate the potential utility here.

erikdarlingdata.com
7th Jul 2022

Improve SQL Server Performance for Large Log Table Queries using a Goal Posts Table

Many of us deal with logging tables that grow unchecked for years, while reporting queries against them are expected to continue running quickly regardless of the size of the table.

mssqltips.com
7th Jul 2022

Three NoSQL Challenges That Can Be Solved with Distributed SQL

In this section, we walk through the three challenges of using current generation NoSQL databases: operational complexity, frustrating application development, and inconsistent customer experiences.

blog.yugabyte.com
7th Jul 2022

PostgreSQL Replication and Conflicts

Replication sits at the core of database high availability (HA). While on-disk data can be replicated through various methods, whether hardware or software, disk, file, or block-based solutions, without an online copy of the database, HA setup cannot be achieved.

percona.com
7th Jul 2022

Automate the SSL Certificate Lifecycle of your Percona Monitoring and Management Server

We highly value security here at Percona, and in this blog post, we will show how to protect your Percona Monitoring and Management (PMM) Server with an SSL certificate and automate its lifecycle by leveraging a proxy server.

percona.com
6th Jul 2022

New Database Job – Understand What You Have

In my previous post, I expounded on my first 30 days I had at four jobs in the last four years. and how to setup your jobs box. I commented and got quoted on the fact that if it’s documented I don’t support it.

tracyboggiano.com
6th Jul 2022

CIS Benchmarks July 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.

cisecurity.org
6th Jul 2022

PowerShell for the DBA - Performing DBA tasks using SQL Server CMDLETs

Throughout this series we've been learning basic elements of PowerShell that will allow you, the star SQL Server DBA, to craft useful scripts that will help you in your daily tasks.

mssqltips.com
6th Jul 2022

Understanding SQL Server T-SQL Configuration Functions

There are a lot of configuration settings in SQL Server which we update based as needed. SQL Server provides many ways to check these configuration settings. One such way to check these configuration settings is by using configuration functions.

mssqltips.com
6th Jul 2022

Extended Events for Anything But Query Tuning: Unique Constraint Violations

Most of the time when I talk about or demo Extended Events, I spend more time talking about query tuning (I have a problem). However, there are tons of things that you can do with Extended Events. Here’s a little one that came up, auditing unique constraint violations.

scarydba.com
6th Jul 2022

How to use Amazon RDS and Amazon Aurora with a static IP address

When you use Amazon Relational Database Service (Amazon RDS) and Amazon Aurora, you may have noticed that the IP addresses of your database instances keep changing. There are several reasons for this. The IP address changes when the primary database of Amazon RDS fails over to a standby database.

aws.amazon.com
6th Jul 2022

Columnstore Indexes are Finally Sorted in SQL Server 2022.

There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column. So essentially, every column has a whole bunch of indexes on it.

brentozar.com
6th Jul 2022

Introducing Buffered Error Logging in Percona Server for MySQL

The MySQL error log is usually used to store and later analyze error and warning messages, but in some cases, it is also used for high throughput debug messages for analyzing complex issues.

percona.com
5th Jul 2022

Contained Availability Groups error

During my testing about the new SQL Server 2022 feature Contained Availability group I faced an issue during the creation of the system databases on the secondary instance.

dbi-services.com
5th Jul 2022

SQL Server 2022 Parameter Sensitive Plan Optimization: A Missed Opportunity For PSP To Make A Query Go Faster

The index and proc creation script for this are a bit on the long side, so I’m going to stick them in a GitHub gist to keep the post concise, since we have some other ground to cover here. The histogram matches the row counts from the table precisely. Thanks, full scan!

erikdarlingdata.com
5th Jul 2022

Website and Forum Restart!

Dear Volunteers, we are thrilled to announce that our website and forums have finished rebuilding and testing, and are both available for public access. The website and forums are back with full functionality.

worldcommunitygrid.org
5th Jul 2022

SQL Server 2022 Parameter Sensitive Plan Optimization: Does PSP Work With Dynamic SQL?

When I talk to clients about using dynamic SQL, they’re usually under the misconception that those plans can’t get reused. Under more favorable circumstances, dynamic SQL gets run, executed, and plans cached and reused with the same frequency as stored procedures.

erikdarlingdata.com
5th Jul 2022

Enabling and Enforcing SSL/TLS for PostgreSQL Connections

Enabling SSL in PostgreSQL is very straightforward. In just three steps we can make sure the connections to it are more secure, using in-transit encryption via SSL/TLS:

percona.com
5th Jul 2022

Interactively explore & visualize your MySQL HeatWave data with Apache Zeppelin

MySQL – The world’s most popular open source database – is a very good and safe choice as a transactional database, on-premise and in the cloud.

dasini.net
5th Jul 2022

SQL Server 2022 Restore a database from AWS S3 bucket - Part 3

SQL Server 2022 lets you create native backups directly to an AWS S3 bucket. In part 1 and part 2 we explored how you can configure the AWS S3 bucket. Further and create SQL database backups. In this tutorial, we look at how to restore SQL Server backups stored in an S3 bucket.

mssqltips.com
5th Jul 2022

Understanding pg_stat_activity – select * from depesz;

With newer pgs it's rather wide (22 columns as I write this). And, it's not always obvious what all this means. So let's try to figure it out. First thing that I noticed are the values in query column: <insufficient privilege>.

depesz.com
5th Jul 2022

SQLServerCarpenter Tools

Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the community but due to my other commitments, I couldn’t write any new posts in the past couple of months.

sqlservercarpenter.com
5th Jul 2022

How to obtain SQL Execution Plans using different methods

In this article, we will learn various methods of how to get an SQL execution plan of a query. Azure Data Studio is a new generation database development environment that can be used for on-premises and cloud data platforms.

sqlshack.com
5th Jul 2022

How to Migrate From PostgreSQL to SingleStoreDB

The global Postgres community boasts tens of thousands of users and several thousand enterprises.

singlestore.com
5th Jul 2022

Introducing the SQL Server 2022 blog series

Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL Server 2022, now in public preview, is our most Azure-enabled release yet, with continued innovation across performance, security, and availability.

cloudblogs.microsoft.com
5th Jul 2022

A Simple SQL Server Health Checklist

Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best practices and monitor server health across over 20 environments.

straightpathsql.com
5th Jul 2022

Understanding Database High Availability

Downtime, whether scheduled or unplanned, is barely, if at all, tolerated by end users. The consequences of downtime can be severe and may include things like loss of customers, damage to your reputation, or penalties for not meeting Service Level Agreements (SLAs).

percona.com
5th Jul 2022

How to set up Log Shipping as HA or DR Solution for SQL Server on Linux

Log Shipping is a convenient disaster recovery method without complex infrastructure requirements. Log shipping allows you to sync a warm standby replica of your database with the Primary instance. It is available in the Enterprise, Standard, and Development editions of SQL Server.

severalnines.com
5th Jul 2022

Database Corruption: An Overview

Though I am writing this post being a PostgreSQL DBA, this page can be read by anyone because the concept of corruption is the same in every database. After reading this blog post, one should understand what database corruption is and how it may occur.

percona.com
5th Jul 2022

Managing Kubernetes Just Got a Lot Simpler

Today we are opening up DigitalOcean Kubernetesto everyone! Over the last few months, we have been inspired to see more than 30,000 developers use our platform to learn Kubernetes and deploy web applications, microservices, CI/CD pipelines, IoT applications, blockchain-based services, CDNs, VPNs, an

digitalocean.com
29th Jun 2022

Start Using Binlogs: A Quick Guide

Binary logs play an important role in replication and data recovery. In replication, source databases communicate data changes recorded in its binary logs to the replica’s relay logs. They can also be used to repair a replica experiencing data drift.

virtual-dba.com
29th Jun 2022

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
29th Jun 2022

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?

mssqltips.com
29th Jun 2022

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
29th Jun 2022

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
28th Jun 2022

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
28th Jun 2022

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
28th Jun 2022

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

  • About
  • Blog
  • Privacy Policy
Twitter Instagram
2021 © DBplatz