by George Grammatikos | Aug 30, 2018 | IT, Power BI
Overview 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 we must make sure that we... 
by George 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... 
by George 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... 
by George Grammatikos | May 16, 2018 | Azure, NoSQL
In my previous post i wrote about Azure Cosmos DB. In this one i will talk about migration methods to Cosmos DB. Download Azure Document DB migration tool from here. DocumentDB Data Migration Tool gives you the ability to migrate data from different sources to Cosmos... 
by George 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...
