by skufel | Aug 8, 2016 | Databases, Linux, Scripting, Security, SysAdmin
In order to install MySQL/MariaDB database engine on CentOS follow these: [root@localhost ~]# yum install mariadb-server [root@localhost ~]# systemctl enable mariadb [root@localhost ~]# systemctl start mariadb [root@localhost ~]#...
by skufel | Mar 14, 2016 | Automation, Databases, Infrastructure, Scripting, SysAdmin, Windows
Code snippet from old archives. It shows how to import Windows event log entries to database. Important is to setup database and table accordingly, so it contains apropriate columns. Set objConn = CreateObject("ADODB.Connection") Set...
by skufel | Jul 27, 2015 | Databases, HA/DR, Infrastructure
SQL Server 2012 has very nice HADR technology built-in, AlwaysOn Availability Groups. It allows to have multiple replicas of selected databases across multiple servers, which can be even located across multiple sites. AlwaysOn itself provides mechanism to keep all...
by skufel | Jul 22, 2015 | Automation, Databases, Scripting, Windows
Recently I went through requirement of running SQL scripts on multiple databases on different servers. As the list of databases was different from script to script I decided to create universal solution, which will allow to easily prepare for deployment and can be...
by skufel | Jun 16, 2015 | Databases, Linux, SysAdmin
Recently I went through installation process of Bareos on openSUSE. Bareos seems to be interesting solution for backups in heterogeneous environments. Ok,let’s start and see how to deploy in 5 steps: Step 1: Add repository with Beros and Beros WebUI; Install...
by skufel | Sep 30, 2014 | Databases, Scripting, Windows
When you try to connect to SQL Server from PowerShell script and you get following message: Unable to find type [Microsoft.SqlServer.Management.Smo.Server] then you have to download and install following components: Microsoft System CLR Types for SQL Server 2008...
