by George Chrysovaladis Grammatikos | Jul 18, 2018 | Installation / Configuration, SQL Server
Reading Time: < 1 minuteWhen 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...
by George Chrysovaladis Grammatikos | Apr 16, 2018 | Azure, Installation / Configuration, SQL Server, VM
Reading Time: 6 minutesSQL 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...
by George Chrysovaladis Grammatikos | May 17, 2017 | Installation / Configuration, SQL Server
Reading Time: < 1 minuteBy 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...