SQL Server Slow execution after migration to new server

So my last post got me thinking what was also big problem that I spent days trying to resolve. And then I remembered. We were doing migration of database and application from old server to new one. Everything went smoothly, everything was up and running untill couple of days later. One of procedures was taking forever to…

Error: 0xC0209303 in SSIS

Today I was working on importing some data to DWH with SSIS packages. So I remembered problem that was giving me big headache back in days. I spent few days then resolving error: Error: 0xC0209303 at Package, Connection manager “mdbfilename“: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered — perhaps no 64-bit provider…

Loging to Azure with Azure CLI

After you install Azure CLI (on your Windows, Mac or Linux) you have everything you need to manage your Azure account. But in order to do so, first you need to login to your account with CLI. There are two ways to do so. First way is to open CMD and write: azure login This…

Installing Azure CLI

Azure Command Line Interface ( or Azure CLI ) is very nice tool that helps you manage your Azure account in multiple platforms. Basically it’s designed to help you manage Azure account if you use more platforms. Let’s say you use Windows at work and Mac or Linux at home, Azure CLI is designed to…