cloudopszone.com
  • Azure
    • Containers
      • Container Service (AKS)
    • Integration
      • Data Factories
    • 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
  • DevOps
  • IT
    • Network
    • Tools
    • Virtualization
    • Troubleshooting
  • Intune
  • SQL Server
    • Installation / Configuration
    • Troubleshooting
  • Power Platform
    • Portals
    • Power BI
    • Power Apps
    • Dynamics 365
  • MS365
    • Billing
  • Exams
  • My Presentations
    • 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
  • Azure Learning Resources
  • Contact Me
Select Page
SQL Server Patching Troubleshooting

SQL Server Patching Troubleshooting

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

If there is a problem during the upgrade process of a SQL Instance, then follow these instruction, Check the archive Summary.txt, which is located at C:\Program Files\Microsoft SQL Server\XXX\Setup Bootstrap\Log directory The second file that keeps logging important...

How to restart an Interrupted Database Restore in SQL Server

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

If there is a break in the restore process then we can follow the steps below to try solve the problem. First, Open SSMS and execute the following command to look at database Status. SELECT NAME, STATE_DESC FROM SYS.DATABASES As soon as you confirm that database is in...
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...

List Heap Tables

by George Chrysovaladis Grammatikos | May 17, 2017 | SQL Server, Troubleshooting

Heap table are the tables which they don’t have any  clustered index. : — List all heap tables SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes...

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...
Next Entries »

Recent Posts

  • Power Apps: Types of variables on the canvas apps
  • Azure DevOps: Register a pipeline agent to an Azure VM
  • Azure DevOps: How to create a Personal Access Token (PAT)
  • Power Apps: Create a Collection in a Canvas App
  • Azure: Restore deleted Web App

ARM Automation Account Azure Azure Active Directory Azure AD Azure Automation Azure Cloud Shell Azure Cosmos DB Azure Firewall Azure Portal Azure Powershell Azure SQL Azure Storage Azure Subscription Azure VM Blob Canvas App certificate DevOps Dynamics 365 Gateway IT Json Linux Logic Apps Microsoft Migration Network Performance Power Apps Power Platform PowerShell RDP restore database Service Bus SQL Server TCP IP Trace troubleshooting Virtual Machines Virtual Network Visual Studio VM VNet Windows

  • Facebook
  • GitHub
  • Twitter
  • LinkedIn
  • YouTube
  • Link
  • Link
January 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Dec    
Copyright © 2022 - Created by George Grammatikos