• 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

Can’t Access The SQL Server Configuration Page From The Portal

by George Chrysovaladis Grammatikos | Feb 1, 2019 | Azure, Portal, SQL Server

In this quick post, we will see how to solve a problem that was reproduced in an Azure VM with SQL Server. The main point is that the problem began after we tried to change collation on the SQL Server. Problem While we change collation in a SQL Server on an Azure VM,...
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...
SQL Server Index Tuning Tools on-prem and In the Azure

SQL Server Index Tuning Tools on-prem and In the Azure

by George Chrysovaladis Grammatikos | May 21, 2018 | Azure, Azure SQL Database, SQL Server

In this post, you will read about the differences between index tuning in SQL Server (on-premises) and SQL Azure (cloud). But what is an index? Consider an index as a contents page. When comparing a SQL database index and a Contents page in a physical book, you note...
Working with SQL Nexus

Working with SQL Nexus

by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting

SQL Nexus is a very useful utility that helps to identify SQL Server performance issues, by visualizing data logs using chart and reports. You can read how to collect diagnostics data using pssdiag in my previous article here. Before you install SQL Nexus, you must be...
SQL Diagnostics – Configure pssdiag utility for SQL Server 2016

SQL Diagnostics – Configure pssdiag utility for SQL Server 2016

by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting

Pssdiag is a data collection utility that Microsoft gives to us to collect useful data and log files for SQL Server installations. Before, start the steps you need to follow to configure all the mandatory parameters you should first download the utility latest...

SQL Server – Reset sa Password

by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting

Below you can find an easy explanation, how to reset sa account password. Download the PsExec tool from the Sysinternals suite. Open with elevated CMD or Powershell privileges and run the following command CMD:  C:\PsExec.exe -s -i “C:\Program Files...
« Older Entries
<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 – Tenant To Tenant Migration
  • MS Entra ID – Introduction to Global Secure Access
  • Basics about Azure Private DNS zone
  • Utilize Application Insights to collect telemetry data for the Copilot Studio Agent.
  • How to troubleshoot using Azure Network Watcher – Connection troubleshoot

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 Dynamics 365 Gateway IT Json Linux Logic Apps Microsoft Migration Performance Power Apps Power Automate Power Platform PowerShell RDP restore database Security SQL Server troubleshooting Virtual Machines Virtual Network Visual Studio VM VNet Windows

Copyright © 2023 - Created by George Grammatikos