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 | 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...
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)...
