(mdinh) The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed out-of-place patching (OOP) to 18.6.0.0.
Other News
Trick: Browsing Objects, all at Once!
(Jeff Smith) The question came in on the usual channel (Twitter):
How to Create a Burndown Chart in Excel from Scratch
(Siddharth Mehta) Measuring progress over time is a standard project management activity. Projects that are executed in an agile manner typically using the agile methodology have more frequent needs to track progress over time than projects that are executed using a waterfall model. In the agile met
Dynamic-JSON-Messages (DJM)
(Edwyn Amador) In simple terms, DJM reads a JSON file retrieving a node per run (from the first to the last one and repeating) in a dynamic way.
Troubleshooting SQL Server 2017 Columnstore Indexes
Troubleshooting SQL Server 2017 Columnstore Indexes If you have problems with SQL Server 2017 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 980 when you try to load SQL Server 2017 database. This is the error message text: “SQL Server cannot load database ‘%.*ls’ because it contains a columnstore index.” This error...
Power Query Performance And Expanding Columns
(Chris Webb) As a footnote to my previous post on storing large images in Power BI, I thought all you M nerds out there would be interested to read about a strange performance quirk I noticed while writing the code for that post.
SQL Server in Azure Kubernetes Service (AKS)
(Ranga Babu) In this article, we will review how to create a Kubernetes cluster in Azure Kubernetes Service, provision the persistent volume to store the database files and deploy SQL server on Kubernetes cluster.
Troubleshooting Variable Memory Grants in SQL Server
(Erin Stellato) One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants.
Deploying a Database Instance in an IBM Cloud Private Cluster on IBM Z
(Christian May) This IBM Redpaper publication shows you how to deploy a database instance within a container using an IBM Cloud Private cluster on IBM Z.
Analysing the Large Object Heap in JetBrains dotMemory
(Steve Gordon) In my last post, which is part of my ‘Writing High-Performance C# and .NET Code‘ series, we looked at how we can begin interpreting some of the data from a dotMemory profiling session.
