From the Community

• Using SQL Translation Framework to access package variables

  February 21, 2019
  (stewashton) My last post had code to rewrite SELECT statements that tried to access public package variables. Here I’ll integrate the code into [...]

• How to manage DB and Cell servers remotely on Exadata with ExaCLI utility – (Part 1)

  February 21, 2019
  (Syed Jaffar Hussain) Whoever is working with Exadata or knew how to administrate Exadata major components like DB and Cell nodes, will certainly [...]

• SQL SERVER – Cleanup Plan Cache For a Single Database

  February 21, 2019
  (Pinal Dave) During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the [...]

• Least Squares: A Matrix Approach in Java

  February 21, 2019
  (Mark H Bishop) Many disciplines depend on linear regression for understanding data. Most often, practitioners turn to packaged programs to do the [...]

• TechTip: Calling SQL Procedures on the Fly

  February 21, 2019
  (Juan Macias) The command Call SQL Procedure (CALLSQLPRC or CALLP) allows us to call an SQL or external procedure and optionally retrieve some or all [...]

• Transfer Data with JSON in SQL Server

  February 21, 2019
  (Hannes du Preez) You can transfer data with JSON in SQL Server. Based on an SQL query, you can output the results into JSON [...]

• Use PWDCOMPARE() to Find SQL Logins With Weak Passwords

  February 21, 2019
  (Thomas LaRock) Not a day, week, or month goes by without news of yet another data [...]

• Rebuilding indexes online, wasting time and resources?

  February 21, 2019
  (Tibor Karaszi) Many SQL server installations does regular index rebuild or reorg in order to defragment indexes. One can question how much we really [...]

• Static Binding vs. Dynamic Binding in Java

  February 21, 2019
  (Rinu Gour) Struggling to understand the difference between static and dynamic [...]

• .NET Core Opinion #8 – How to Use Azure DevOps Pipelines

  February 21, 2019
  (K. Scott Allen) In a previous post I said to be wary of GUI build tools. In this episode of .NET Core Opinions, let me show you a [...]

• Object Pooling in C#

  February 21, 2019
  (Tapas Pal) Object pooling is a software creational design pattern and a container of objects that holds a list of other objects—those are ready to [...]

• Using VS Code for C++ development with containers
• Group Replication: A member in ‘RECOVERING’ state is part of the primary partition
• Mystery and imagination of DELETE RETURNING INTO