by skufel | Apr 4, 2013 | Databases, Infrastructure, Scripting, SysAdmin, Windows
Recently I had issue which occured without any particular reason on SQL Server 2012. All of the sudden I start getting error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005...
by skufel | Mar 25, 2013 | Databases, Development, Infrastructure, SysAdmin, Windows
Some of applications require additional SQL Server 2008 or 2012 fetures installed. Some of these features might not be available in standard setup of SQL Server. In that case you have to refer to Microsoft Dowloads web page in order to download additional components...
by skufel | Dec 23, 2012 | Automation, Databases, Development, Infrastructure, Scripting, SysAdmin, Windows
When browsing repository of all scripts I did use in past, I found one which might be interesting. What this script does is: Backups database to disk (name of database stored in @dbname, patch for backup stored in @archive_path, name of backup fine stored in @fname)...
by skufel | Sep 24, 2012 | Databases
After installation PostgreSQL is listening on localhost only. To change that adjustment has to be done in postgresql.conf. Default location of configuration file /var/lib/pgsql9/data/postgresql.conf. Following line has to be added: listen_addresses = '*' After that...
by skufel | Sep 24, 2012 | Databases
After I instaled PostgreSQL on Amazon Linux AMI, first thing after database server was up and running I start thinking how to create user with administrative privileges, so I can access it using some management applications. So, here is how to create superuser and set...
by skufel | Jan 4, 2012 | Databases, Directory Services, Infrastructure, Scripting
I think it’s common problem as Active Directory gets bigger in organizations, control over content of that mission-critical component seems to be lost. Same happened in my place. In addition to that we had to provide information from AD on a regular basis in a...
