cloudopszone.com
  • Home
  • Azure
    • Virtual Machines
    • Networking
    • Storage
    • Container Service (AKS)
    • NoSQL
    • DevOps
    • Security
    • Identity
    • App Service
    • Azure SQL Database
    • Management Tools
    • Internet Of Things (IOT)
    • Intune
    • Analytics
    • Powershell
    • Portal
    • Automation
    • Integration
    • Troubleshooting
  • IT
    • DevOps
    • Network
    • Tools
    • Power BI
    • Virtualization
    • Troubleshooting
  • SQL Server
    • Installation / Configuration
    • Troubleshooting
  • 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
  • Login
Select Page
How To Backup / Restore Database in SQL Server Virtual Machine

How To Backup / Restore Database in SQL Server Virtual Machine

by George Chrysovaladis Grammatikos | Apr 5, 2019 | Azure, Storage

Reading Time: 6 minutesThere are many ways we can backup up the SQL Databases in Azure services, even if these are running on SQL Azure or a SQL Server Virtual Machine. In this post, we will talk about Azure Backup for SQL Server Virtual Machines, a way that...

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

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

Reading Time: 3 minutesIn 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...
Power BI Desktop – Database Connectors

Power BI Desktop – Database Connectors

by George Chrysovaladis Grammatikos | Aug 30, 2018 | IT, Power BI

Reading Time: 12 minutesOverview In a previous post we saw a Power BI overview. In this one, we are going to talk with more practical examples in Power BI Desktop tool about Database connectors (SQL Server, IBM Informix, Oracle and MySQL database). Before we proceed...
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

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

Reading Time: 4 minutesIn 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...
« Older Entries




Visitor counter

Unique Visitors

Your IP: 3.236.175.108

Calendar

February 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
« Dec    

Tags

ARM Automation Account Azure Azure Active Directory 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 Azure Vnet certificate Cloud Shell DevOps Dynamics 365 Gateway IT Json Linux Logic Apps Microsoft Migration Network OMS Performance PowerShell RDP Replication restore database Service Bus SQL Server TCP IP Trace troubleshooting Virtual Machines Virtual Network Visual Studio VM VNet Windows
Copyright © 2021 - Created by George Grammatikos