22nd Sep 2020 Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES – select * from depesz; This is huge. Alvarro wrote about it, but let me just quickly make a simple test for you: Does this mean that 6th user has some_val below 2? No. It doesn't. depesz.com
22nd Sep 2020 DBA Masterclass, Week 1: Data Modeling 5. Do we need additional licenses to use this tool? No, Oracle SQL Developer Data Modeler is included with your Oracle Database! There’s also the OTN License you have by downloading the tool from Oracle.com – there’s no additional cost for this product. thatjeffsmith.com
22nd Sep 2020 Kubernetes: When to Use, and When to Avoid, the Operator Pattern In the world of Kubernetes, Operators have quickly become a popular pattern far beyond their initial use for encoding deep operational knowledge about running stateful applications and services like Prometheus. thenewstack.io
22nd Sep 2020 SQL Server Synonyms SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them. red-gate.com
22nd Sep 2020 Seedless NoSQL: Getting Rid of Seed Nodes in Scylla Nodes in a Scylla cluster are symmetric, which means any node in the cluster can serve user read or write requests, and no special roles are assigned to a particular node. For instance, no primary nodes vs. secondary nodes or read nodes vs. write nodes. This is a nice architecture property. scylladb.com
22nd Sep 2020 Real-time data intelligence and security at the edge with Azure SQL Edge Today we introduce the availability of Azure SQL Edge, a real-time data engine, optimized for IoT workloads and backed by the security and performance of the same engine that powers SQL Server and Azure SQL. cloudblogs.microsoft.com
22nd Sep 2020 MySQL: ALTER TABLE for UUID ALTER TABLE is not lossy. We can test. Having a test table, we can play. blog.koehntopp.info
22nd Sep 2020 Starting SQL: What Happens When You Don’t Parameterize Queries? Aside from the obvious perils of SQL Injection, parameterizing queries can be helpful in other ways. Not to downplay SQL Injection at all, it’s just that fixing code is only one part of the equation. erikdarlingdata.com
22nd Sep 2020 Getting started with Kibana Kibana is a window into the Elastic Stack. It allows you to visualize and explore data as well as manage and monitor the entire Elastic stack. elastic.co
22nd Sep 2020 Think Digital Summit UK & Ireland 2020 The world and the way we work has transformed, giving us all a mandate for change. At Think Digital Summit UK & Ireland we’re bringing together the best and brightest technology leaders to help you beat the odds and brave the storm. ibm.com
22nd Sep 2020 VirtualBox issue E_FAIL (0x80004005) I get an issue on my VM today , so that I can’t open it anymore. When trying a system restore I get the same state. I was really embarrassed to fail to restore my VM (as a huge work was done on it) Below we will see how to fix this issue blog.dbi-services.com
22nd Sep 2020 Azure SQL Offers Manual Failover for PaaS Resources Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a new ability that has recently surface within the Azure eco-system to help manage fail-overs. Let’s jump to it. sqlrus.com
22nd Sep 2020 Does Your Business Have a Well-Known URL for Changing Passwords? It Should! We all know users can be careless with their password security. They choose passwords that are weak and easy to crack, passwords that easily guessed, or simply reuse the same password time and time again. businessinsights.bitdefender.com
22nd Sep 2020 How I bypassed Cloudflare's SQL Injection filter In late 2018 I was tasked with performing a Web Application security assessment for a large client. After running the standard scans with automated tools, something interesting came up: a possible SQL injection which couldn’t be exploited using the tool. astrocamel.com
22nd Sep 2020 The Basics of Database Performance Tuning Poor database performance bogs down operations, and as the lifeblood of a business, companies can’t afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. virtual-dba.com
22nd Sep 2020 TL;DR Tech Tips – How to Use the CLI Locally to Access the Flux REPL and Write a Regular CSV to InfluxDB Cloud In this post we share how to use the InfluxDB CLI with InfluxDB Cloud. This TL;DR assumes that you have registered for an InfluxDB Cloud account – registering for a free account is the easiest way to get started with InfluxDB. influxdata.com
22nd Sep 2020 Visual Studio 2019 Configuration for the Production DBA As a Production SQL Server Database Administrator, you do not usually find yourself in Visual Studio to perform your work. However, there are those few times you are called into troubleshooting an SSIS, SSRS or SSAS problem. mssqltips.com
22nd Sep 2020 Using PMM to track MySQL on ARM statistics Percona Monitoring and Management (PMM) is an effective tool in tracking stats of the running MySQL servers. Especially, the timelines capability helps users to get the picture of how the given stats changes over tenure of the workload. mysqlonarm.github.io
21st Sep 2020 How to read a Parallel Execution Plan in Oracle The volume of data being stored in databases has grown exponentially in recent years. So too has the need to rapidly generate value or business insights from that data. sqlmaria.com
21st Sep 2020 Best practices for using Docker Hub for CI/CD According to the 2020 Jetbrains developer survey 44% of developers are now using some form of continuous integration and deployment with Docker Containers. docker.com
21st Sep 2020 MongoDB 101: 5 Configuration Options That Impact Security (And How to Set Them) As with any database platform, MongoDB security is of paramount importance to keeping your data safe. MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database. percona.com
21st Sep 2020 How we use the Grafana GitHub plugin to track outstanding pull requests First of all, we’re pleased to announce the first release of the GitHub data source. The source code is available at github.com/grafana/github-datasource. Contributions, feature requests, and bug reports are welcome. grafana.com
21st Sep 2020 Why should businesses upgrade their PostgreSQL Database? It all comes down to determining the cost of not upgrading your PostgreSQL Database. enterprisedb.com
21st Sep 2020 Connection Handling & Throttling with ProxySQL The ability to shape the traffic that goes to the database is one of the most important ones. In the past days you had not that much control over it - applications sent the traffic to the database and that’s about it. severalnines.com
21st Sep 2020 Refresh SQL Server Always On Availability Group databases using DBATools PowerShell In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose. sqlshack.com
21st Sep 2020 How to Decide Between JOIN and JOIN FETCH Deciding between JOIN and JOIN FETCH is a matter of performance! Typically, JOIN and JOIN FETCH come into play when the application has lazy associations but some data must be fetched eagerly. Relying on FetchType.EAGER at the entities-level is a code smell. dzone.com
21st Sep 2020 Renaming the default branch in Azure Data Factory Git repositories from “master” to “main” In Azure Data Factory, you can connect to a Git repository using either GitHub or Azure DevOps. When connecting, you have to specify which collaboration branch to use. In most cases, the default branch is used. Historically, the default branch name in git repositories has been “master“. cathrinewilhelmsen.net
21st Sep 2020 5 Steps to Greater Cyber Resiliency Work from home isn't going away anytime soon, and the increased vulnerability means cyber resiliency will continue to be critical to business resiliency. Recent events have rapidly shifted the way that we live and work. darkreading.com