(Lockwood Lyon) Until recently, business analytics against big data and the enterprise data warehouse had to come from sophisticated software packages.
Community
Master-Slave Replication with MySQL 8.0 in 2 mins
(Frederic Descamps) There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options !
Ranges with NULLs 02: test cases
(stewashton) When I write SQL there is a bit of trial and error (laughter), so I need as complete a set of test cases as possible. Here’s what I came up with.
Oracle wait event ‘TCP Socket (KGAS)’
(Frits Hoogland) I was asked some time ago what the Oracle database event ‘TCP socket (KGAS)’ means. This blogpost is a deep dive into what this event times in Oracle database 12.1.0.2.180717.
Partitioning — 10 : Virtual Column Based Partitioning
(Hemant K Chitale) Oracle 11g supports specifying a Virtual Column as the Partition Key.
Enter and Edit Data in SQL Server Reporting Services
(Esat Erkec) Power BI offers a data entry option which allows users to enter data directly and this data can then be used on reports and visuals. How can we create and use this type of data in SQL Server Reporting Services?
Snackbar In Angular Using Ignite-ui-angular
(Jatin Saini) Web and mobile apps often require a confirmation of an activity or operation and there are several ways to achieve this. A traditional method of a confirmation is to show a popup message or a text message.
Bad Query Performance Tips Rebutted
(Grant Fritchey) Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over the internet, over and over.
SQL truncate enhancement: Silent Data truncation in SQL Server 2019
(Rajendra Gupta) In this article, we’ll take a look into SQL truncate improvement in SQL Server 2019.
HTTP-REPL Tool to test WEB API in ASP.NET Core 2.2
Today there are no tools built into Visual Studio to test WEB API. Using browsers, one can only test http GET requests.