When it comes to using Always On in Microsoft SQL Server it is a technology that has been around for a long time. The feature was introduced in […]
administration / Azure / Database / MSSQL
How to modify a bacpac file – Moving databases from Azure SQL to SQL VM
When working with Azure SQL databases one of the challenges is how difficult it is to move data across environments. Say for example we have a production database […]
Modifying a bacpac file
When working with Azure SQL databases one of the biggest irritants is the lack of access to backup files. A lot of the time we need to refresh […]
Updating Stats in Azure SQL Database
Recently we were having some issues with DTU utilization in Microsoft SQL Azure. One of the troubleshooting steps that was suggested was the update statistics and rebuild indexes. […]
Create an Azure SFTP Site
Microsoft Azure has become a cloud platform of choice for everyone at this point. One of its biggest advantages has been the ability to integrate seamlessly with existing enterprise […]
Installing GitHub on VS Code
When using VS Code you will find a need for a Source Control or Version Management Software. Git is by far the most popular and free software used […]
How to enable Hyper-V on Windows 10 Home edition OS
One the biggest issues I had with Windows 10 was when it said I had to uninstall VMware since it wasn’t compatible with the OS. Thus a perfectly […]
Azure Data Sync Issues
Azure data sync is a great tool for those people looking for a quick and easy way to move data from on premise systems to the cloud. It […]
Visual Studio – The process cannot access the file because it is being used by another process
Cannot delete the file “C:\……t\LoadExcelFiles.ispac”: The process cannot access the file ‘C:\…..LoadExcelFiles.ispac’ because it is being used by another process The above error common message that we encounter […]
administration / Azure / Database / Errors / MSSQL
Online Indexes Failures in Azure for VLDBs
Recently we had a requirement that was caused by a very unique situation. A table with a column of datatype nvarchar(max) was inadvertently populated with some text in […]