Author: admin

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

I enjoy learning new things every single day and I must express my gratitude to all of you for helping me learn new things. One of my client Comprehensive Database Performance Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works as during the consulting engagement we applied …


What an Argentine Writer and a Hungarian Mathematician Can Teach Us About Machine Learning Overfitting

What an Argentine Writer and a Hungarian Mathematician Can Teach Us About Machine Learning Overfitting = Previous post    Tags: Machine Learning, Mathematics, Overfitting This article presents some beautiful ideas about intelligence and how they related to modern machine learning. By Jesus Rodriguez, Intotheblock. comments Source: https://www.ofrases.com/frase/28193 I recently started a new newsletter focus on AI …


Backup compression in TDE enabled databases in SQL Server Always On Availability Groups

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. Introduction TDE protects the physical database, log, backup files using the IO encryptions. It uses the …


🖖UNFOLD App’s Text Editor was the inspiration.

GitHub – eneskarpuz/react-native-drag-text-editor: React Native Text Prototype for photo editing / manipulation cases.


Big Announcement: 3 Free Certificate Courses in Data Science and Machine Learning by Analytics Vidhya!

An Unmissable Opportunity to Earn your Data Science Certificate Picture this – you are given the opportunity to take a high-quality course on a data science or machine learning topic(s) free of cost. And as the icing on an already delicious offering, you will even get a certificate upon completing the course! So not only …


Bitcoin Price Prediction: BTC/USD Hovers Above $10,800 After Rejection at the $11,000 Resistance

Bitcoin (BTC) Price Prediction – September 20, 2020Yesterday, the BTC/USD price broke the $11,000 resistance, and price reached the $11,200 high. Today, the BTC price has fallen above $10,800 support. It is not clear if the current selling pressure will continue. Perhaps the support above EMAs will determine Bitcoin’s direction. Resistance Levels: $10,000, $11, 000, …


What is Temp Stored Procedures? – Interview Question of the Week #294

Question: What is Temp Stored Procedures? Answer: Temp stored procedures are kind of the stored procedures that are created with the help of the # at the beginning of the name and only available until the SQL Server restarts. When I go for SQL Server Performance Tuning Comprehensive Database Performance Health Check, one of the …


Python One Line For Loop Append

Problem: How to append elements to a list using a single line for loop? Example: You hope to accomplish something like this where you create an initial list (this one is empty) and you append multiple elements to it: # WRONG CODE: >>> [].append(i) for i in range(5) [0, 1, 2, 3, 4] However, this …


Up to 15 times speedup for Yapp when parsing JavaScript

djalbat 2 minutes ago. https://github.com/djalbat/yapp In fact the improvements largely came from streamlining the BNF, which is now workable: https://github.com/djalbat/yapp/blob/master/es6/parser/javascript.js The readme file has been improved, too. Contributions are very welcome, not just for the JavaScript grammar but for any of the supported languages or indeed new plugins.


Framework-free frontends with Malina.js

Malina.js is a new library inspired by Svelte. It compiles your web application to JavaScript, meaning your app uses no framework on the frontend side. In this article, you’ll be looking at what Malina.js is all about, how to build applications with it, and its syntax. In order to follow along, you should have a …