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 Read More
Category: SQL
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 Read More
How to Find New Tables in SQL Server with SSMS
Solution 1 – First thing to try Try: “Edit > Intellisense > Refresh local cache” Keyboard shortcut: Ctrl + Shift + R After adding lots of tables, SSMS gets out of sync at times… Solution 2 In this article I’d like to show you how you can find newly created tables in SQL Server Management Studio. Read More
How to Change Power BI Data Source From MS SQL Server to Excel
Changing Power BI data source from MS SQL Server to Excel for Power BI file
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 Read More
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 Read More