12th Jun 2021 AzureFunBytes Presents: Migrating Your Data – Create Your Cosmos DB In this series of posts, I will focus on how to prepare ourselves from having to do manual work to handle our database s... devblogs.microsoft.com ⏰ 7 mins
10th Jun 2021 “I’m getting index seeks. Why are my row estimates still wrong?” If you’ve got good indexes to support your query, and statistics to help SQL Server guess how many rows will come back, ... brentozar.com
10th Jun 2021 The DBA’s Dilemma: How to Upskill and Stay Ahead The joke goes that no one knows what DBAs do. That’s because the position is rapidly evolving, and the job description v... dbta.com ⏰ 3 mins
10th Jun 2021 An overview of PGAdmin – PostgreSQL Management Tool In this article, we are going to learn about PGAdmin, a PostgreSQL management tool. As you are aware SQL Server Manageme... sqlshack.com ⏰ 6 mins
10th Jun 2021 MySQL Replication Best Practices MySQL Replication has been the most common and widely used solution for high availability by huge organizations such as ... severalnines.com ⏰ 15 mins
10th Jun 2021 TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation This is part 7 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each ... stevestedman.com
10th Jun 2021 Get a List of Tables That Are Compressed Modern versions of SQL Server have the option for row or page level compression. Tested on SQL Server 2019.... stevestedman.com
10th Jun 2021 Benchmarking PostgreSQL: Improving Performance Stability These drives basically scale linearly which is quite reassuring.... enterprisedb.com
10th Jun 2021 Query Store Hints Query Store Hints provide the ability to add a hint to a statement even if you do not have direct code access. When I ta... sqlskills.com
10th Jun 2021 Managing Your Data Lifecycle with Time to Live Tables Your organization is growing with each passing day; so is your data. More data brings more business opportunities, but i... pingcap.com ⏰ 7 mins
10th Jun 2021 Choosing a Well-Architected CI/CD approach: Open-source software and AWS Services This series of posts discusses making informed decisions when choosing to implement open-source tools on AWS services, a... aws.amazon.com ⏰ 19 mins
10th Jun 2021 Bringing “docker scan” to Linux At the end of last year we launched vulnerability scanning options as part of the Docker platform. We worked together wi... docker.com
9th Jun 2021 SQL Server: How to compare Server and Database Collation Sometimes during an SQL Server audit, I check the collation of the server and the databases but every time separately. T... blog.dbi-services.com
9th Jun 2021 Running your Database on OpenShift and CodeReady Containers Let’s take an introductory run-through of setting up your database on OpenShift, using your own hardware and RedHat’s Co... thelastpickle.com ⏰ 7 mins
9th Jun 2021 5 reasons to attend the Azure Hybrid and Multicloud Digital Event Now’s the time to register for the free Azure Hybrid and Multicloud Digital Event on Tuesday, June 29, 2021, from 9:00 A... azure.microsoft.com
9th Jun 2021 Rate Limiting Strategies for Serverless Applications Serverless technologies reduce the work needed to set up and maintain computing resources, provide built-in scalability,... aws.amazon.com ⏰ 5 mins
9th Jun 2021 Keeping Databases Up and Running in an Outage or Slowdown Once you see that your database environment has issues, you are in trouble. Maybe one of your replicas is out or maybe y... severalnines.com ⏰ 9 mins
9th Jun 2021 Titles and DevOps Confusion Alex Yates has become quite the DevOps consultant in the last few years. I used to work with Alex at Redgate before he l... voiceofthedba.com
9th Jun 2021 Where to Get Postgres Help Online? In the recent Postgres Community Survey by Timescale, nearly 50% of users reported that they started using Postgres with... xzilla.net ⏰ 4 mins
9th Jun 2021 Things to check when restoring a database Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer data... bornsql.ca ⏰ 3 mins
9th Jun 2021 Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs This is the 9th part in a series about named table expressions. In Part 1 I provided the background to named table expre... sqlperformance.com ⏰ 11 mins
9th Jun 2021 Disabling autocommit in PostgreSQL can damage your health When analyzing customer’s problems, I have seen the mess you can get into if you disable autocommit in your interactive ... cybertec-postgresql.com ⏰ 5 mins
9th Jun 2021 Unlock your LinkedIn Profile to Unleash Your Full Potential inc LIVE Q&A In this info packed session, we'll look at top tips and tools to give your LinkedIn profile a facelift to give your cont... meetup.com
9th Jun 2021 Create Delete RAC DB Using dbca silent Tested version. Create database using dbca silent.... mdinh.wordpress.com ⏰ 3 mins
9th Jun 2021 High Availability : How much availability do you really need? I had a discussion with a few folks about high availability (HA) and I thought I would write down some of my thoughts on... oracle-base.com ⏰ 7 mins
9th Jun 2021 Understanding Kubernetes Architecture Kubernetes is becoming the new standard for deploying and managing the software in Cloud because of the wide number of f... dev.to ⏰ 4 mins
8th Jun 2021 Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL Indexes are designed to speed up queries against a table. However, they come with a cost: every time a INSERT / UPDATE /... vettabase.com ⏰ 5 mins
8th Jun 2021 Backing up a Db2 Database to AWS S3 AWS S3 is a cloud object storage service that is easy to use. It is highly available and offers ELEVEN nine’s of durabil... datageek.blog ⏰ 10 mins
8th Jun 2021 Wait Stats Query Store Doesn’t Actually Track There are some oddities in the documentation for query store wait stats. One is that RESOURCE_SEMAPHORE_QUERY_COMPILE is... erikdarlingdata.com
8th Jun 2021 How to Patch SQL Server Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that you’re going to be... brentozar.com ⏰ 4 mins
8th Jun 2021 SQL Server: Analysis of SCOM Warning on the Health Check Sometimes, it’s hard to find how to analyze a Warning in the SCOM Interface and correct the problem. By a customer, we i... blog.dbi-services.com
8th Jun 2021 Announcing IBM Db2 Administration Foundation for z/OS 1.1 Db2 Administration Foundation for z/OS 1.1 is the no-charge administrative offering in the transformation of Db2 Tools f... worldofdb2.com
8th Jun 2021 SQL Server transaction log architecture The transaction log is a journal of update activity for a database. SQL Server holds this database update information un... red-gate.com
8th Jun 2021 Microsoft Releases June 2021 Security Updates Please share your thoughts. We recently updated our anonymous product survey; we'd welcome your feedback.... us-cert.cisa.gov
8th Jun 2021 MongoDB Replication Best Practices Production database systems often require high availability architectures. This is to ensure the availability of the dat... severalnines.com ⏰ 6 mins
8th Jun 2021 CIS Benchmarks June 2021 Update We're excited to announce our CIS Benchmarks June 2021 updates. The following CIS Benchmarks have been released and incl... cisecurity.org ⏰ 4 mins
7th Jun 2021 Complete guide to be an artificial intelligence professional Artificial Intelligence is one of the biggest technological waves that have hit the world of technology. According to re... datasciencecentral.com ⏰ 4 mins
7th Jun 2021 Modernizing Business Data Indexing On the Yelp app and website, there are many occasions where we need to show detailed business information. We refer to t... engineeringblog.yelp.com ⏰ 7 mins
7th Jun 2021 Monitor key metrics and visitor demographics in NGINX with the new Grafana Cloud integration We are happy to announce that the NGINX integration is available for Grafana Cloud, our composable observability platfor... grafana.com
7th Jun 2021 Advancing in-datacenter critical environment infrastructure availability There are many factors that can affect critical environment (CE) infrastructure availability—the reliability of the infr... azure.microsoft.com ⏰ 4 mins
7th Jun 2021 Handling Unused Indexes What do you do if you see that an index is being updated but is low on seeks and scans? Should you drop it because the t... callihandata.com ⏰ 3 mins
7th Jun 2021 DBCC Shrink Fails with Error Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be sh... stevestedman.com
7th Jun 2021 ALTER DATABASE SET SINGLE_USER statement in SQL Server In this article, we are going to explore the purpose of the ALTER DATABASE SET SINGLE_USER statement. The ALTER DATABASE... sqlshack.com ⏰ 4 mins
7th Jun 2021 Azure Virtual Desktop: The flexible cloud VDI platform for the hybrid workplace When we launched Windows Virtual Desktop nearly two years ago, no one predicted a global pandemic would force millions o... azure.microsoft.com ⏰ 5 mins
7th Jun 2021 Scripting using SMO I will be delivering a lightning talk at DataMinutes on June 7th on this topic. I thought it would help to write a synop... curiousaboutdata.com
7th Jun 2021 Video : APEX_MAIL : Send Emails from PL/SQL In today’s video we’ll demonstrate how to use the APEX_MAIL package to send emails from PL/SQL. The video is based on th... oracle-base.com
7th Jun 2021 HeatWave MySQL DB Systems in OCI HeatWave is a distributed, scalable, shared-nothing, inmemory, columnar, query processing engine designed for fast execu... juliandontcheff.wordpress.com
7th Jun 2021 PostgreSQL Replication Best Practices - Part 1 Using replication for your PostgreSQL databases could be useful not only to have a high availability and fault tolerant ... severalnines.com ⏰ 6 mins
