Useful tips for everyday
How to change job step properties in SQL Server? See Azure SQL Managed Instance T-SQL differences from SQL Server for details. Use this page to…
How do I rank in PostgreSQL? PostgreSQL RANK() function demo CREATE TABLE ranks ( c VARCHAR(10) ); INSERT INTO ranks(c) VALUES(‘A’),(‘A’),(‘B’),(‘B’),(‘B’),(‘C’),(‘E’); SELECT c FROM ranks;…
How do you count the number of times a string appears in a string? When count() is used with a string, it will search for…
How do you filter a query in access? To create a filter from a selection: Select the cell or data you want to create a…
How is indexing used to prevent deadlocks? So by adding a covering index we can avoid our session getting blocked and prevent the deadlock from…
Can we have multiple listeners configured in multi-subnet always on? Multi-Subnet SQL Server Always On Availability Groups. In the case of a multi-subnet, we need…
When to enable read only in MySQL replication? When it is enabled, the server permits no updates except from users that have the SUPER privilege…
What are roles in SQL? A role is created to ease setup and maintenance of the security model. It is a named group of related…
How do you fix Underfitting? Below are a few techniques that can be used to reduce underfitting: Decrease regularization. Regularization is typically used to reduce…
Is Theano dead? Theano, a deep learning library, was developed by Yoshua Bengio at Université de Montréal in 2007. Although Theano itself is dead now,…