Useful tips for everyday
How do I keep two systems in sync? How do you keep two related, but separate, systems in sync with each other? Bi-directional replication. Web…
How to create a database diagram in SQL Server? From the Database Diagrams tool dialog scroll and select Invoice table. Press Add and then Close.…
How do you add on delete cascade to a foreign key constraint? Alter table to remove Foreign Key or add DELETE CASCADE (MySQL) Step 1…
How to return multiple matching values based on one or multiple? Return Multiple Lookup Values In One Comma Separated Cell ; In Excel, we can…
What is deallocate prepare? To deallocate a prepared statement produced with PREPARE , use a DEALLOCATE PREPARE statement that refers to the prepared statement name.…
What is NUMA nodes in SQL Server? NUMA stands for Non-Uniform Memory Access. The purpose of NUMA is for Scheduler (CPU) to have faster access…
Is WordPress compatible with MariaDB? Yes, you can use MariaDB. WordPress even lists MariaDB as an option within the requirements on their website: We recommend…
Can you index Jsonb? JSONB stands for “JSON Binary” or “JSON better” depending on whom you ask. It is a decomposed binary format to store…
What is Nesterov accelerated gradient? The Nesterov Accelerated Gradient method consists of a gradient descent step, followed by something that looks a lot like a…
How do you best start your data analytics project? Start taking notes on your first analyses and ask questions to business people, the IT team,…