(Greg Larsen) In the processes of executing a query the database optimizer calculates an estimate at the cost to run the query. This cost is determined based on statistics.
Community
Installing SQL Server 2019 on Azure VM
(blobeater) Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below:
How to Perform a Mail Merge in a Word Document in Java
(C# Curator) Mail merge is a very useful functionality in Microsoft Word that lets us quickly and easily generate a batch of documents from specific templates.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
(Pinal Dave) The other day I was hired by a large consulting organization that is managing database operations for the bank Comprehensive Database Performance Health Check. The organizations wanted to have lots of performance issues and we worked through them one at a time.
Basics of Working with JSON in SQL Server
(Kenneth Igiri) JSON is an acronym for JavaScript Object Notation, that became popular a little over seventeen years ago. JSON is essentially a data format, it was popularized by Douglas Crockford, a well-known programmer with an interesting history who was also involved in the development of JavaSc
Analyze JSON Data with Filters, Formulas, and Charts in XMLSpy Grid View
(David McGahey) Software developers and other data professionals often need to examine new data instances before designing processes for efficient production. As JSON becomes a more popular format for data exchange, the tradeoff for smaller data payloads can be loss of clarity of the underlying data
IBM Db2, DBAs and Zowe CLI
(Rose Sakach) Do you want to learn more about the Zowe CLI and the IBM Db2 Database Plugin for Zowe CLI?
OEDA Virtualized Cluster Discovery With SSH Keys
(Andy Colvin) As part of the Oracle Exadata Deployment Assistant (“OEDA”), Oracle includes a command line utility to read and modify the XML files used for deployment of an Exadata cluster.
Oracle Cloud Infrastructure (OCI) Part 4 – Virtual Cloud Network….
(Aman) In this installment of the series of OCI fundamentals, we shall understand with networking with OCI. And in this post, we shall look at what is virtual cloud network (VCN) in OCI. Let’s get started.
DATAGUARD Using DBCA Silent Mode Is Not Setting DB_UNIQUE_NAME
(mdinh) Unfortunately, db_name=db_unique_name which is not ideal for Data Guard environment