• Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • Azure
    • Containers
      • Container Service (AKS)
    • Integration
      • Data Factory
    • Compute
      • Virtual Machines
      • App Service
    • Networking
    • Storage
    • Databases
      • Azure SQL Database
      • NoSQL
    • Identity + Security
      • Security
      • Identity
    • AI + ML
      • Internet Of Things (IOT)
    • Management Tools
      • Powershell
    • Management + Governance
      • Automation
      • Analytics
      • Portal
    • Integration
    • Troubleshooting
    • Exams
  • DevOps
  • IT
    • Network
    • Tools
    • Virtualization
    • Troubleshooting
  • Intune
  • SQL Server
    • Installation / Configuration
    • Troubleshooting
  • Power Platform
    • Portals
    • Power BI
    • Power Apps
    • Power Automate
    • Power Pages
    • Dynamics 365
  • MS365
    • Billing
  • Speaking
    • Greek MVPs In Action, Introduction To Azure Logic Apps
    • Global Azure Virtual 2020 Greece – Intro to Azure Service Bus
    • IT PRO | DEV Connections 2020 – Introduction to Logic Apps and automation solutions for IT’s
    • Global Azure Athens 2023 – Deploy resources on Azure using IaC (Azure Terraform)
    • Azure Learning Resources
  • Contact
  • Azure
    • Containers
      • Container Service (AKS)
    • Integration
      • Data Factory
    • Compute
      • Virtual Machines
      • App Service
    • Networking
    • Storage
    • Databases
      • Azure SQL Database
      • NoSQL
    • Identity + Security
      • Security
      • Identity
    • AI + ML
      • Internet Of Things (IOT)
    • Management Tools
      • Powershell
    • Management + Governance
      • Automation
      • Analytics
      • Portal
    • Integration
    • Troubleshooting
    • Exams
  • DevOps
  • IT
    • Network
    • Tools
    • Virtualization
    • Troubleshooting
  • Intune
  • SQL Server
    • Installation / Configuration
    • Troubleshooting
  • Power Platform
    • Portals
    • Power BI
    • Power Apps
    • Power Automate
    • Power Pages
    • Dynamics 365
  • MS365
    • Billing
  • Speaking
    • Greek MVPs In Action, Introduction To Azure Logic Apps
    • Global Azure Virtual 2020 Greece – Intro to Azure Service Bus
    • IT PRO | DEV Connections 2020 – Introduction to Logic Apps and automation solutions for IT’s
    • Global Azure Athens 2023 – Deploy resources on Azure using IaC (Azure Terraform)
    • Azure Learning Resources
  • Contact
Create SQL Server Login For Always-On Sync

Create SQL Server Login For Always-On Sync

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...
Failover Clustering and Always On Availability Groups on Azure VMs

Failover Clustering and Always On Availability Groups on Azure VMs

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

Storage Pools For SQL Server

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...
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-7445511428585429"
     crossorigin="anonymous"></script>
<!-- AdUnit1 -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-7445511428585429"
     data-ad-slot="1036616002"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>

Recent Posts

  • Power Platform Pipelines – Configuration
  • Power Platform Pipelines – Installation
  • Troubleshoot Azure Functions
  • Power Platform – Azure VNet Integration
  • Power Pages – Custom Domain with SSL Certifcate

App Registration ARM Azure Azure Active Directory Azure AD Azure Automation Azure Cloud Shell Azure DevOps Azure Firewall Azure Portal Azure Powershell Azure SQL Azure Storage Azure Subscription Azure Terraform Azure Virtual Network Gateway Azure VM Azure Vnet Canvas App Collection DevOps DNS Dynamics 365 Gateway IT Json Linux Logic Apps Microsoft Migration Power Apps Power Automate Power Pages Power Platform PowerShell RDP Security SQL Server troubleshooting Virtual Machines Virtual Network Visual Studio VM VNet Windows

Copyright © 2023 - Created by George Grammatikos