(Sergey Gigoyan) There are some concepts in SQL Server which have different names, but functionally they are equivalent. However, the difference between their names can sometimes be confusing and therefore these questions can be classified as a frequently asked questions in the SQL Server sphere.
Community
VSLI Design Implementation: Placement
(Thomas Dillinger) Prior to detailed placement of cells in block netlists (and the global cells at the top of the SoC hierarchy), a physical floorplan of the chip design is required.
Two Way Data Binding In Angular
(Farhan Ahmed) In this article, you will learn about two way data binding in Angular.
RUNSTATS sampling enhancements
(Peter Hartmann) One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.
JPA With Eclipse and MySQL Using Java Configuration
(Riddhi Parkhiya) Learn more about the Java Persistence API and how to configure it with EclipseLink and MySQL.
7 easy steps to install MiniProfiler on an ASP.NET MVC website
Today I wanted to add MiniProfiler to an ASP.NET MVC web application (not .NET Core), but unfortunately the NuGet package doesn’t set up things correctly, the documentation is a bit lacking, and their sample project doesn’t work.
Do not underestimate performance impacts of swapping on NUMA database systems
(Shinguz) If your MariaDB or MySQL database system is swapping it can have a significant impact on your database query performance!
JSON_TABLE() and date/time columns in Oracle 19c
(Martin Bach) While researching the use of JSON in Oracle 19c I came some interesting behaviour that wasn’t immediately obvious (to me).
SQL SERVER – SQL Agent Job and Backslash – Strange Behavior
(Pinal Dave) Today, I am going to discuss a very interesting scenario which I encountered while working with one of the largest European financial technology organizations Comprehensive Database Performance Health Check earlier last week.
Transferring ownership of Db2 objects
(Gayathiri Chandran) There is a demand for a way to change the ownership of Db2 objects from one user to another.