Waclaw Chrabaszcz
... there is no spoon ...

SQL Server

SQL 2012 – How to setup AlwaysOn cluster

As an application administrator, or transition engineer I need to store my data on some sort of database. Because SQL itself is not my primary focus I rather prefer "I don't care" solutions. It not means I don't care whether database is running or not. It mean I don't have enough time to become an expert in additional area to setup and understanding e.g. Log Shipping. What's more, it's not my problem only. I'll setup some SQL HA solution and walk away, whereas poor WinAdmin will RDP there day by ......

SQL 2008 Express silent installation

Wow! Today we have 12.12.12. How many times you needed "quick SQL" for your tests … Let's make it quick. Command line: Setup.exe /ConfigurationFile=SQLExpre... /Q However we need an answer file. One for SQL Express, another for SQL Enterprise. You can easy prepare the answer file using manual installation. Within last step of the installer GUI you will see: Time for SQLExpress.ini – don't forget to review all settings and replace PCUSOURCE & SQLSYSADMINACCOUNTS settings: [SQLSERVER2008] INSTANCEID="SQLExpress" ......