24th Sep 2020 Microsoft confirms Group Policy Editor bug in Windows Server 2016 Microsoft has confirmed that a bug in Windows 10 version 1607 and Windows Server 2016 is causing the Group Policy Editor to display errors. bleepingcomputer.com
24th Sep 2020 A Hacktoberfest to bring us together Hacktoberfest is the monthlong celebration of open source software created by DigitalOcean to honor and uplift the community that we owe a great deal to. From the very early days of DigitalOcean, we’ve strived to invest time and money into open source foundations, projects, and maintainers. digitalocean.com
24th Sep 2020 Analyze data in Azure Data Explorer using Kusto Query Language (KQL) extension in Azure Data Studio The Kusto (KQL) extension in Azure Data Studio is now available in preview. This native Kusto (KQL) support brings another modern data experience to Azure Data Studio, a cross-platform client – for Windows, macOS, and Linux. cloudblogs.microsoft.com
24th Sep 2020 Packer by HashiCorp : Second Steps? In a previous post I mentioned my first steps with Packer by HashiCorp. This is a brief update to that post. I’ve created a new box called “oracle-7” for Oracle Linux 7 + UEK. This will track the latest OL7 spin. You can find it on Vagrant Cloud here. oracle-base.com
24th Sep 2020 Ansible on z/OS – 1 – Enterprise Python We had been using Ansible to automate the installation of zPDT on Red Hat VMs for a couple of years before the version for z/OS was released. triton.co.uk
24th Sep 2020 SQL Server Diagnostic Queries – Part 12 I have recently started making videos for my YouTube channel. There are several different playlists, but the one for SQL Server is probably most relevant. glennsqlperformance.com
24th Sep 2020 Choosing the right Data Warehouse SQL Engine: Apache Hive LLAP vs Apache Impala Aren’t two superheroes better than one? Some of the most powerful results come from combining complementary superpowers, and the “dynamic duo” of Apache Hive LLAP and Apache Impala, both included in Cloudera Data Warehouse, is further evidence of this. blog.cloudera.com
24th Sep 2020 Use Retool to Quickly Build Distributed SQL and React Apps Retool is a next generation WSIWYG SaaS-based tool that enables you to quickly build React applications for internal consumption from your existing data sources using a variety of pre-built “building blocks. blog.yugabyte.com
24th Sep 2020 Starting SQL: Parameter Sniffing Because Of Insufficient Indexes There are lots of different ways that parameter sniffing can manifest in both the operators chosen, the order of operators chosen, and the resources acquired by a query when a plan is compiled. erikdarlingdata.com
24th Sep 2020 Identify unused tables of SQL databases In this article, I am going to demonstrate how we can identify the unused tables of a given SQL Database. As a database administrator, we must maintain the tables and objects of the SQL Database. sqlshack.com
24th Sep 2020 VMworld 2020 SQL Server session preview Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview of my session at VMworld 2020 called Hybrid Cloud Architecture for SQL Server Workloads: Deep Dive (HCP1721). The conference this year will be held online from September 29th to . sqlservercentral.com
24th Sep 2020 Instant PostgreSQL Cloning with SUSE and Btrfs What if you could clone a PostgreSQL database instantly without affecting the original source database, without impacting performance, without any external tool but using your linux Btrfs storage layer. This is what I will demonstrate in the following blogpost. blog.dbi-services.com
24th Sep 2020 SQL Server Perfmon Counters - Target vs Total Memory and Max Memory Performance monitor has these two performance counters: SQL Server: Memory Manager\Total Server Memory (KB) and SQL Server: Memory Manager\Target Server Memory (KB). What is the difference between these two counters and does the Target Memory (KB) correlate to SQL Server maximum memory setting? mssqltips.com
24th Sep 2020 Smashing Security podcast #197: Greedy bosses, game cheats, and virtual beheadings Why are Zoom and Twitter making some people disappear? How are Counter-Strike: Global Offensive cheats getting their just desserts? And the founder of a anti cyber-fraud firm is charged with fraud. grahamcluley.com
24th Sep 2020 How to Calculate Your True Database Costs Before the dominance of the cloud, calculating the cost of a database was a pretty simple equation: software costs + hardware costs = database costs. If you chose an open source product, the software cost might melt away. cockroachlabs.com
24th Sep 2020 Chaos Engineering: What It Means, Why It Matters Gremlin sponsored this podcast. Chaos engineering certainly evokes a lot of interest these days, especially as organizations increasingly rely on widely distributed data infrastructures that can extend across multicloud and on-premise environments — where the risk of failure grows exponentially. thenewstack.io
23rd Sep 2020 Using Postgres and pgRouting To Explore The Smooth Waves of Yacht Rock pgRouting is a powerful routing tool, usually used for pathfinding/mapping/direction applications. (See Paul Ramsey's introduction to pgRouting here). It is, however, also a robust graph db implementation, and can be used for much more than just finding the directions to your great aunt Tildy’s. info.crunchydata.com
23rd Sep 2020 PostgreSQL 13: Trusted extensions PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. blog.dbi-services.com
23rd Sep 2020 Chaos Engineering with Neo4j Editor’s Note: This presentation was given by Janos Szendi-Varga at NODES 2019 in October 2019. Chaos engineering allows for fewer surprise breakdowns in production, as well as foreknowledge of how to save the day when bad things happen. neo4j.com
23rd Sep 2020 Database Experts Discuss the Evolution of the DBA Major trends in technology are reshaping the role of the DBA at many organizations. The size and complexity of database systems continues to grow with higher data volumes, more workloads and an increasing rate of database deployments that need to be managed. dbta.com
23rd Sep 2020 5 strategies to reduce cloud cost After initial migration to the cloud, companies often discover that their infrastructure costs are surprisingly high. No matter how good the initial planning and cost estimation process was, the final costs almost always come in above expectations. blog.griddynamics.com
23rd Sep 2020 Cracking Production Performance Issues with Open Source Observability I would like to share our recent case study on our battling a very serious performance issue whose solution turned out to be a small change in code, but with a huge impact on all of our HTTP endpoints in our platform. logz.io
23rd Sep 2020 Operational Database Security – Part 2 In this blogpost, we are going to take a look at some of the OpDB related security features of a CDP Private Cloud Base deployment. We are going to talk about auditing, different security levels, security features of Data Catalog, and Client Considerations. You can find part 1 of this series, here. blog.cloudera.com
23rd Sep 2020 ORACLE database on AWS : Backup and Recovery In this third blog post of the series Oracle database on the AWS Cloud we will take look at a few ways to backups/recover our oracle databases deployed in AWS cloud. For oracle RDS it’s as simple as pushing a button. By default automated backups are enabled and retained for 7 days. mahmoudhatem.wordpress.com
23rd Sep 2020 Review: Stellar Repair for SQL Server I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it done. Well, I finally got off my bottom and did the job. So, let’s talk about Stellar Repair. scarydba.com
23rd Sep 2020 Starting SQL: Persistent Problems With Parameters Alright, maybe not any database. Let’s stick with SQL Server. That’s the devil we know. At some point in your life, you’re going to construct a query that takes user input, and that input is likely going to come in the form of a parameter. erikdarlingdata.com
23rd Sep 2020 How we Build and Deploy our Serverless HarperDB Studio Backend Application The HarperDB Management Studio is a graphical user interface that enables users to install, design, cluster, and manage databases without having to write a line of code. The Studio’s backend is a serverless application that utilizes AWS Lambda and Amazon API Gateway. dev.to
22nd Sep 2020 How Load Balancing Works with DBaaS Setups Database as a Service (DBaaS) takes away the pain of operating a database. So as a user, when you decide to use a DBaas from a cloud service provider, you would only know the database version, size of instance, storage, RAM, and whether the DBaaS supports high availability with multiple instances. severalnines.com