Are you familiar with Common Table Expressions (CTE)? Common Table Expressions are widely used to simplify queries, make them more readable and maintainable. For instance, when I want to check…
Tag: SQL
This one will also be short. We came on this issue today: our code is decrypting some fields in the SQL Server database and as a part of decryption we…
There are situations when the SQL server is getting wild – mostly because of our own actions or poorly written queries. From time to time we notice that the SQL…
I noticed a strange error recently. When trying to access the properties of the MS SQL database using the Microsoft SQL Server Management Studio, I received this error: “Cannot show…
In theory, MySQL replication should work without problems even if the servers are restarted, databases created and removed, data flowing in and out… Sometimes, however, there are errors that are…
This article will be short. Recently we had an issue trying to restore the database to the Amazon RDS version of the SQL Server. Long story short, we ended up…
I would like to perform some basic checks for email addresses my users are entering. Sometimes they are simply making a typo in the domain part of the email. Typically…