cloudopszone.com
  • Azure
    • Compute
      • Virtual Machines
      • Container Service (AKS)
      • App Service
    • Networking
    • Storage
    • Databases
      • Azure SQL Database
      • NoSQL
    • Identity + Security
      • Security
      • Identity
    • AI + ML
      • Internet Of Things (IOT)
    • DevOps
    • Management Tools
      • Powershell
    • Management + Governance
      • Automation
      • Intune
      • Analytics
      • Portal
    • Integration
    • Troubleshooting
  • IT
    • DevOps
    • Network
    • Tools
    • Power BI
    • Virtualization
    • Troubleshooting
  • SQL Server
    • Installation / Configuration
    • Troubleshooting
  • Power Platform
    • Portals
    • Dynamics 365
  • 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
  • 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...

Use the following Commands if Windows Kick You Out Of System (RDP)

by George Chrysovaladis Grammatikos | Jun 27, 2017 | IT, IT-Troubleshooting

​​​​To access a VM from a Remote Server you must follow the next steps : 1. Download psexec 2. Run CMD with Administrative privileges 3. Execute the following command : psexec \\ 10.x.x.x cmd -u “USERNAME” -p “PASSWORD” 4. If successfully...

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




Calendar

June 2022
MTWTFSS
 12345
6789101112
13141516171819
20212223242526
27282930 
« May    

Tags

ARM Automation Account Azure Azure Active Directory Azure AD Azure Automation Azure Cloud Shell Azure Cosmos DB Azure Extensions Azure Portal Azure Powershell Azure SQL Azure Storage Azure Subscription Azure Virtual Network Gateway Azure VM Blob certificate Cloud Shell DevOps Dynamics 365 Endpoint Gateway IT Json Linux Logic Apps Microsoft Migration Network OMS PowerShell RDP Replication restore database Service Bus SQL Server TCP IP troubleshooting Virtual Machines Virtual Network Visual Studio VM VNet Windows
    Copyright © 2022 - Created by George Grammatikos