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 | 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...
by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
Reading Time: 2 minutesSQL 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...
by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
Reading Time: 2 minutesPssdiag is a data collection utility that Microsoft gives to us to collect useful data and log files for SQL Server installations. Before, start the steps you need to follow to configure all the mandatory parameters you should first download the...
by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
Reading Time: < 1 minuteBelow you can find an easy explanation, how to reset sa account password. Download the PsExec tool from the Sysinternals suite. Open with elevated CMD or Powershell privileges and run the following command CMD: C:\PsExec.exe -s -i...
