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