A few days ago, we created a new server instance with MS SQL Server 2019 installed. The main authorization method during the days of the server configuration and preparation was…
Category: Database
When you are managing multiple SQL servers, it is handy to have the ability to give access to the SQL Server databases by using Active Directory users or groups. Of…
Have you tried to restore the development database when suddenly such an error occurred? In the MS SQL Server with a connection to ColdFusion, this is a common problem. ColdFusion…
Sometimes when I run backup or restore operations on an MS SQL server using a maintenance plan or a simple script, I have no information about the progress. In order…
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…
Given that my native language uses some funny chars like ‘ą’ or ‘ć’ and there are multiple chars that are not safe when placed in the URL, from time to…
The Microsoft SQL Server development machine is something that I’m using daily. The operations I perform are much different from the things that I did on the production server. The…
From time to time there is a need to remove a large amount of data from the MS SQL table. By large amounts, I mean that the table contains a…
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…