Question : We had our MySQL server on an old server. We decided to move all of the databases to […]
Tag: configuration
MySQL cluster DataMemory and DiskPageBufferMemory parameters
Question : I want to setup a MySQL cluster. The amount of data is more than double the amount of […]
Error while trying to create a database for SSRS
Question : I have installed SQL Server Reporting Services 2017, and my database engine is developer edition 2017. Now, while […]
SQL Server Agent won’t start
Question : When I’m trying to start SQL Server Agent, I got this error: TITLE: Microsoft SQL Server Management Studio […]
Best configuration of my.cnf for make fast Magento navigation
Question : I have a Magento 1.7 version site with 7000 configurable products. Site navigation is slow. From the moment […]
DB server VM’s CPU configuration – 1x2Ghz or 2x1Ghz – which is better
Question : We want to set up DB server in cloud hosting for MS SQL Server Express edition – OLTP […]
changing SSMS settings via Powershell
Question : in order to enable the dark theme to SSMS (not available on the picture below as you see): […]
Configure SQL Server to associate a user login with a specific port
Question : We have SQL Server instances that sit in our DMZ, and associated firewall rules to allow access to […]
How to enable CLR on a remote SQL Server?
Question : I have been created a dll for SQL Server 2014 to add some custom functions for my stored […]
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT
Question : Most of the forum and example online always suggest to have both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT set to ON […]