by George Chrysovaladis Grammatikos | Jul 18, 2018 | Installation / Configuration, SQL Server
When we deploy a SQL Server Always-On, we MUST create the user logins manually to the secondary replica. This happens because SQL server keeps logins in the Master database which is not syncing. To overcome this problem we need to run some SQL scripts in a certain...
by George Chrysovaladis Grammatikos | Apr 16, 2018 | Azure, Installation / Configuration, SQL Server, VM
SQL Server: Failover Clustering and Always On Availability Groups Before we start to configure SQL Server always On, you need to make sure that you have: One Domain Controller Two Database Servers A Storage that will play the File Share Witness (Witness Quorum) All...
by George Chrysovaladis Grammatikos | May 17, 2017 | Installation / Configuration, SQL Server
By following the next steps you are able to create storage pools for a SQL Server installation. Storage Pool Best Practices Column Size = Number Of Disks In The Storage Pool, example 2 Disks = Column Size 2 Interleave = For OLTP Best is 256KB , For TSQL Best is 64K...