24th Sep 2021 Restarting a sequence: how hard could it be? (PostgreSQL and Oracle) In the above piece of code, I’ve created a batch_seq and queried it one hundred times, so that the current value of the ... fluca1978.github.io
24th Sep 2021 How to Design Backups in SQL Server? The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be... practicalsqldba.com 3 mins
24th Sep 2021 RetroPie Cyberdeck | HackSpace #47 You know we love a good cyberdeck around here, and we think you’ll love this video game emulator fresh from the latest i... raspberrypi.org
23rd Sep 2021 Some basics about time zones in PostgreSQL As soon as you have an application which works across time zones you will have to deal with that properly in the databas... blog.dbi-services.com 4 mins
23rd Sep 2021 Oracle Database 21c Express Edition (XE) : Article and Vagrant Builds You probably saw a stream of Tweets yesterday mentioning the release of Oracle database 21c Express Edition (XE) for Lin... oracle-base.com
23rd Sep 2021 MySQL Upgrade Checker, Review the Report, Before you Upgrade. MySQL introduced the MySQL “Upgrade Checker” initially to support upgrades from MySQL 5.7 to 8.0 series. However, the co... thesubtlepath.com 15 mins
23rd Sep 2021 SQL Constraints Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a... dev.to 4 mins
22nd Sep 2021 Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever ... stevestedman.com 3 mins
22nd Sep 2021 What Is a Cost-Based Optimizer? For even the simplest queries, there are usually several possible ways to get the job done. The database server has to f... brentozar.com 5 mins
22nd Sep 2021 Enhanced Password Management Systems in MySQL 8: Part 1 MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put toge... percona.com 3 mins
22nd Sep 2021 Automate Amazon Aurora Global Database endpoint management Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud. Aurora combines the performa... aws.amazon.com 10 mins
22nd Sep 2021 Why Single Key Column Indexes Aren’t Good Choices Most tables you encounter in SQL Server will have a clustered row store index on them, and probably some nonclustered ro... erikdarlingdata.com
22nd Sep 2021 Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period. Azure S... sqlshack.com 6 mins
22nd Sep 2021 Modern Web-Based Application Architecture 101 This article is meant to provide a high-level overview of how a web-based application is commonly structured nowadays. K... percona.com 3 mins
22nd Sep 2021 Medium Cross-post – CodeIgniter 4 CRUD: Update In some applications, data may never change. Yet, in others, data changes numerous times in its lifecycle. In SQL the UP... joshuaotwell.com 3 mins
22nd Sep 2021 HomeLab: Create a Virtual Machine with Hyper-V Today, I'm creating a new Windows 2019 VM using Hyper-V for my home lab. The goal is to create a new SQL Server AlwaysOn... blog.dbplatz.com
22nd Sep 2021 Cybersecurity Compliance: Start with Proven Best Practices As a security professional, you may be tasked with achieving SOC2 compliance for your organization, adopting a NIST fram... cisecurity.org 3 mins
22nd Sep 2021 Quick SQL Server CPU Comparison Tests Sometimes I have a need to run a quick CPU comparison test between two different SQL Server instances. For example, I mi... erikdarlingdata.com 5 mins
22nd Sep 2021 Building an Oracle to PostgreSQL migrator: Lessons learned Moving from Oracle to PostgreSQL has become a popular sport, widely adopted by many who want to free themselves from lic... cybertec-postgresql.com 7 mins
22nd Sep 2021 The Different Versions of the Raspberry Pi In this guide, we will explore the different versions of the Raspberry Pi released over the years. The Raspberry Pi is a... pimylifeup.com 15 mins
22nd Sep 2021 Use SQLAlchemy ORMs to Access MongoDB Data in Python – SQLServerCentral The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use th... sqlservercentral.com 3 mins
22nd Sep 2021 Speeding up data analysis with TimescaleDB and PostgreSQL Time-series data is everywhere, and it drives decision-making in every industry. Time-series data collectively represent... blog.timescale.com 14 mins
21st Sep 2021 Making Aurora Write Latency 15x Higher (or More!) by Choosing a Bad Primary Key Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact o... percona.com 4 mins
21st Sep 2021 #PowershellBasics: Bulk insert. In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql file.... sqlstudies.com
21st Sep 2021 Catching the big fish: Analyzing a large-scale phishing-as-a-service operation In researching phishing attacks, we came across a campaign that used a rather high volume of newly created and unique su... microsoft.com 13 mins
21st Sep 2021 I/O Bound vs CPU Bound Queries When you’re looking for queries to tune, it’s important to understand which part is causing the slowdown. That’s why Act... erikdarlingdata.com 3 mins
21st Sep 2021 Defragmentation of Column-Organized Tables with Db2 11.5.4 When you run an SAP Business Warehouse system on IBM Db2 and IBM Db2 BLU Acceleration, it might happen that the column-o... blogs.sap.com 4 mins
21st Sep 2021 Discovering MySQL Database Service – Episode 8 – Connect to MySQL Database Service Using MySQL Shell MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastruc... dasini.net 4 mins
21st Sep 2021 What is the difference between a blockchain and a traditional database? Blockchain technology, which joined the ranks of high-speed digital technologies in 2008 with the advent of bitcoin, soo... dev.to 4 mins
21st Sep 2021 SQL Injection Attacks and How Developers Can Prevent Them This week during my 100 Days of Hacking challenge, I learned how hackers can infiltrate applications that are vulnerable... dev.to 7 mins
20th Sep 2021 Critical Patches Issued for Microsoft Products, September 14, 2021 MS-ISAC ADVISORY NUMBER: 2021-113 DATE(S) ISSUED: 09/14/2021 OVERVIEW: Multiple vulnerabilities have been discovered in ... cisecurity.org
20th Sep 2021 How to Fix Recovery Pending State in SQL Server Database Fix the issue of recovery pending state in SQL server database by running queries in SQL Server Management Studio (SSMS)... dzone.com 3 mins
20th Sep 2021 Azure SQL Migrations using Azure Data Studio – SQLServerCentral Database migrations to the cloud can be a daunting proposition for many database administrators and data stewards. A new... sqlservercentral.com 8 mins
19th Sep 2021 The DB2Night Show #237: Db2 REST — From Movie Recommendation to… Shazam!? 91% of our studio audience learned something!Tanmay discussed Db2 Rest and gave a great demo. Watch the replay... Tanmay... dbisoftware.com
19th Sep 2021 A Detailed Comparison: Unit Testing vs. Functional Testing The main goal of any testing is to deliver a quality product with find the right job balance between unit testing and fu... dzone.com 3 mins
19th Sep 2021 Introduction to Data Structures & Algorithms Greetings everyone, and thank you for joining me on this new playlist of mine, Data Structures, and Algorithms. You’ll l... dev.to
17th Sep 2021 Migration of a MySQL Database to a Kubernetes Cluster Using Asynchronous Replication Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are ... percona.com 5 mins
17th Sep 2021 Replication Deadlocks Replication is one of my least favorite things, and I go out of my way not to deal with it. I have had a few clients now... erikdarlingdata.com
17th Sep 2021 A Guide to Transparent Data Encryption in PostgreSQL In the past decade, Data Security has become one of the biggest concerns for both small and large organizations. With mo... arctype.com 9 mins
17th Sep 2021 SQL Server 2017 Cumulative Update 26 On July 12th, 2021, Microsoft released SQL Server 2017 Cumulative Update 26. This is Build 14.0.3411.3. By my count, the... glennsqlperformance.com
17th Sep 2021 Enhance your Log Analytics data exploration in Azure Data Studio The Azure Monitor Logs extension in Azure Data Studio is now available in preview. The extension is supported in Azure D... cloudblogs.microsoft.com
17th Sep 2021 How to Fix Recovery Pending State in SQL Server Database? Getting recovery pending state in SQL Server Database is a common query asked by users. Read this article to get rid of ... dzone.com 5 mins
17th Sep 2021 Disaster Recovery (DR) for a Third-party Interactive Voice Response on AWS Voice calling systems are prevalent and necessary to many businesses today. They are usually designed to provide a 24×7 ... aws.amazon.com 4 mins
16th Sep 2021 sp_RestoreScript 1.9 – a dirty little bug squished! It look like we had a little bug in sp_RestoreScript that was putting a rogue 0 after the backup file name. That’s now b... sqlundercover.com
16th Sep 2021 PostgreSQL schedulers: comparison table Hello, my name is Pavlo Golub, and I am a scheduler addict. That began when I implemented pg_timetable for PostgreSQL. I... cybertec-postgresql.com 4 mins
16th Sep 2021 Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server This article explores the Azure built-in policies and implements them to check and fix Azure SQL Database and Azure SQL ... sqlshack.com 6 mins
16th Sep 2021 Broken indexes after Linux upgrade Upgrading one’s operating system to new major version is an important system maintenance task and it’s usually a good th... elephanttamer.net 3 mins
16th Sep 2021 SQL Server Latches – Other Latches To Know About To finish up my short series of articles on latches, this time I’m going to discuss a few other latches in SQL Server yo... sqlperformance.com 5 mins
