switch_user_11-1

Difference between Oracle, SQL Server, MySQL, and PostgreSQL

Oracle, SQL Server, MySQL 5 and PostgreSQL are the most commonly used databases and people normally get caught in the comparison between them. The inability to work around all aspects of comparison becomes a limitation and leads to indecisiveness about which database to use. Here is a comparison of the all the four in a […]

switch_user_11-1

How to Alter column size in SQL Server

If you’re using SQL Server, and you want to use T-SQL to change the size of an existing column, this article can help. By “changing the size of an existing column”, I mean changing the data size. For example, say you have a varchar(255) but you want to increase its size to varchar(500). Here’s what you need to do in that […]

switch_user_11-1

How to Fix The “Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.”

A popular issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio). It throw an error : “=================================== The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data) To fix this, First thing first, install “Microsoft Access Database Engine 2016 Redistributable.” https://www.microsoft.com/en-us/download/details.aspx?id=54920 And then also check the […]

switch_user_11-1

6 Ways to Check the Size of a Database in SQL Server using T-SQL

If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage). However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query that returns this […]