3rd Aug 2021 SQL Database Schema: The Absolute Beginner’s Guide What is a database schema? That’s actually a bit of a difficult question to answer! Like many database terms, term datab... cockroachlabs.com 7 mins
3rd Aug 2021 Use Extended Statistics For Better SQL Execution Plans This is a follow-on from a previous blog about plan stability. It is worth looking at this first if you haven't already.... blogs.oracle.com 9 mins
3rd Aug 2021 AzureFunBytes Episode 49 – Intro to @Azure SQL with @StevenMurawski AzureFunBytes is a weekly opportunity to learn more about the fundamentals and foundations that make up Azure. It’s a ch... devblogs.microsoft.com
3rd Aug 2021 Finding problematic SQL NOLOCK patterns for UPDATE and DELETE – Part 2 In Part 1 of this series, I showed how to use a Visitor pattern to walk through one or more T-SQL statements to identify... mssqltips.com 7 mins
3rd Aug 2021 Audit your VMware vCenter Server using Ansible vCenter has a graphical user interface if you want to interact with it, but what if you manage multiple vCenter servers ... ansible.com 5 mins
3rd Aug 2021 How to write subqueries in SQL This article briefly explains how to write a subquery in SQL by providing examples. The following sections explain how t... sqlshack.com 4 mins
3rd Aug 2021 Deploying MariaDB Sharding with Spider using ClusterControl NoSQL ("not only SQL") is an approach to database design that enables the storage and querying of data outside the tradi... severalnines.com 6 mins
3rd Aug 2021 Web scraping data with Azure Data Factory This article will show you how to web scrape data using Azure Data Factory and store the data on one of the Azure data r... sqlshack.com 7 mins
3rd Aug 2021 Deploying a KVM-based virtualized X8-2M ODA Until now, High-Availability (HA) ODAs could have been deployed either in bare metal or in virtualized mode. Virtualized... blog.dbi-services.com 14 mins
3rd Aug 2021 Cloud Orchestration 101 | A Complete Guide for Beginners With the expectation to become a $623 billion market by 2023, cloud computing is firmly planted in the technological fie... dev.to 3 mins
3rd Aug 2021 Discovering MySQL Database Service – Episode 1 – Introduction MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastruc... dasini.net 5 mins
3rd Aug 2021 An introduction to machine learning with Unity ML-Agents In this tutorial, you'll learn how to get set up with Unity's ML-Agents toolkit and train your own agent using reinforce... dev.to 4 mins
3rd Aug 2021 Twitter Bot on AWS Serverless | Mohamed Fayaz Sharing my experience of how I am running the Twitter Bot on AWS for almost free using AWS serverless technologies. Soci... dev.to 3 mins
3rd Aug 2021 How to create your own private cloud : part 1 Hello folks, Have you ever wondered how do cloud providers build their cloud ? How do circle-ci, github actions, gitlab-... dev.to 5 mins
3rd Aug 2021 Appium Tutorial | Introduction to Android and IOS Mobile Apps Testing Mobile testing is a series of tests done to determine the reliability, functionality, and usability of a software applic... dev.to 4 mins
2nd Aug 2021 How big is your procedure cache? Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in ... stevestedman.com
2nd Aug 2021 PostgreSQL: Six Not-So-Easy Pieces PostgreSQL comes with an excellent set of features, unmatched in the open-source RDBMS space. It is mostly easy to learn... pgdash.io 7 mins
2nd Aug 2021 DB-Engines Ranking The DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly. ... db-engines.com
2nd Aug 2021 Issues with SQL Server Permissions to Restore a Database Have you ever faced a situation when you wanted to restore a database using SQL Server Management Studio (SSMS) and coul... mssqltips.com
2nd Aug 2021 Video : APPEND Hint, Redo and NOLOGGING In today’s video we demonstrate the relationship between the APPEND hint, redo generation and NOLOGGING. The video is ba... oracle-base.com
2nd Aug 2021 What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular o... blog.devart.com 7 mins
2nd Aug 2021 Overcoming Database DevOps Challenges: Part 1 As part of our research for the 2021 State of Database DevOps report, we asked 3,000+ recipients what they consider to b... red-gate.com 6 mins
1st Aug 2021 SQL Server Diagnostic Information Queries for August 2021 These are my SQL Server Diagnostic Information Queries for August 2021, aka my DMV Diagnostic Queries. They allow you to... glennsqlperformance.com 4 mins
1st Aug 2021 My Favorite Free SQL Courses for Beginners Disclosure: This post includes affiliate links; I may receive compensation if you purchase products or services from the... dev.to 9 mins
31st Jul 2021 SQL Injection vs. Your Applications in the Modern Age Developers dealing with web applications see a lot of things threatening to harm the things they build.... arctype.com 8 mins
31st Jul 2021 PostgreSQL HA and Kubernetes I share my thoughts about how to set up a PostgreSQL Database in Kubernetes with some level of high availability, introd... dzone.com 5 mins
31st Jul 2021 Raspberry Pi OS now has SATA support built-in After months of testing various SATA cards on the Raspberry Pi Compute Module 4, the default Raspberry Pi OS kernel now ... jeffgeerling.com
30th Jul 2021 JENKINS – some ways to restart manually Jenkins services Depending on your actions performed on your master,sometimes Jenkins needs to be restarted,for that,we have many alterna... blog.dbi-services.com
30th Jul 2021 How to Maximize the Performance of Your Kubernetes Deployment With Kubernetes emerging as a strong choice for container orchestration for many organizations, monitoring in Kubernetes... splunk.com 5 mins
30th Jul 2021 Understanding Amazon Machine Images for Red Hat Enterprise Linux with Microsoft SQL Server This post is written by Kumar Abhinav, Sr. Product Manager EC2, and David Duncan, Principal Solution Architect. Customer... aws.amazon.com 5 mins
30th Jul 2021 Monitor AWS FSx audit logs with Datadog Amazon FSx for Windows File Server is a fully managed file storage service built on Windows Server. Migrating on-premise... datadoghq.com 4 mins
30th Jul 2021 What’s new in the Citus 10.1 extension to Postgres Citus 10.1 is out! In this latest release to the Citus extension to Postgres, our team focused on improving your user ex... citusdata.com 10 mins
30th Jul 2021 Monitoring Azure by using Grafana dashboards By using Azure Monitor, Azure Log Analytics and Application Insights, Azure cloud teams have access to a collection of e... devblogs.microsoft.com 6 mins
30th Jul 2021 Safeguard your Azure SQL Database to prevent unexpected changes This article explores locks to prevent unexpected changes in Azure SQL Database resources. Suppose you manage multiple c... sqlshack.com 6 mins
30th Jul 2021 Improve PostgreSQL Query Performance Insights with pg_stat_monitor Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, d... percona.com 4 mins
30th Jul 2021 How to calculate Subtotals in SQL Queries In this article, we will learn how to calculate and add a subtotal in SQL queries. A subtotal is a figure that shows the... sqlshack.com 4 mins
30th Jul 2021 Ending the Relational vs NoSQL Debate, Once and for All Couchbase 7.0 is a major milestone for databases. In the latest release, there are over 33 major innovations and 100 min... blog.couchbase.com 8 mins
30th Jul 2021 Rockset Enables Real-Time Analytics for MySQL and PostgreSQL Rockset has announced new integrations for MySQL and PostgreSQL. San Mateo-based Rockset provides a real-time database i... dbta.com
30th Jul 2021 Introduction to Windows Performance Monitor for SQL Server How can I use Windows Performance Monitor for troubleshooting Microsoft SQL Server performance issues? We'll look at wha... mssqltips.com 4 mins
30th Jul 2021 SQL Server: “Cannot resolve the collation conflict” in a Stored Procedure This week I have a new little challenge by a customer. By executing a “standard” stored procedure, I have the error:... blog.dbi-services.com 4 mins
30th Jul 2021 What Counts For a DBA: Patients It’s been a while since I last wrote a new blog, and it has been a very long time since I last wrote a fresh new “What C... red-gate.com 3 mins
30th Jul 2021 Analyze database performance with Amazon CloudWatch metric streams With the announcement of Amazon CloudWatch Metric Streams, you can now stream near-real-time metrics data to a destinati... aws.amazon.com 12 mins
30th Jul 2021 Architect a disaster recovery for SQL Server on AWS: Part 4 In this series of posts (Part 1, Part 2, Part 3 and Part 4) , we compare and contrast the disaster recovery (DR) solutio... aws.amazon.com 9 mins
30th Jul 2021 SQL Compilations/sec is not what you think it is SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how... red-gate.com 20 mins
30th Jul 2021 Improvements of DBT2 benchmark in RonDB 21.10.1 In the development of RonDB 21.10.1 we have had some focus on improving the performance of the DBT2 benchmark for RonDB.... mikaelronstrom.blogspot.com
30th Jul 2021 New RonDB releases It is in the middle of the summer, but we found some time to prepare a new RonDB release. Today we are proud to release ... mikaelronstrom.blogspot.com
30th Jul 2021 Server vs Instance. A rant. It’s a SQL Server Instance not a SQL Server. I can not tell you how much confusion this has caused over the years. Both ... sqlstudies.com
30th Jul 2021 Five things to ask about your database before cloud migration Moving a database to the cloud is a complex undertaking. Many migrations encounter problems due to assumptions that were... devopsgroup.com 4 mins
