Useful tips for everyday
Does EKS support spot instances? Amazon EKS adds support for EC2 Spot Instances in managed node groups. Amazon Elastic Kubernetes Service (Amazon EKS) now supports…
Is there a Contains function in SQL? At its core, the CONTAINS() function takes one substring and does a search to see if it’s in…
How do I compare SSIS packages? There is a new, simpler way to compare SSIS packages: Right click on the dtsx package in solution explorer,…
How do I export a view in MySQL? Export Connect to your database using phpMyAdmin. From the left-side, select your database. Click the Export tab…
Is reindex safe? Reindexing is not dangerous and can not harm data consistency. However, if you have time critical writes, you may loose data if…
Where can you see the actual SQL code of cached procedure plans in SQL Server 2008? How to view the SQL Server query plan cache…
Why do we need hstore in PostgreSQL? This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value.…
What is the difference between synchronous mode vs asynchronous mode in mirroring configuration? Asynchronous Mirroring captures the state of the source volume at a particular…
How do I replace text in all stored procedures in SQL Server? Solution Generate script of all stored procedures – You can use the scripting…
How do I create a new instance of SQL Server 2014 after installation? Create a new SQL Server Instance Click setup. From the left menu,…