Monthly Archives: March 2016

Downloading training material

By | March 31, 2016

We provide access to training materials via AWS S3 access, this requires a few additional steps compared to FTP sites but provides must faster , frequent and secure access. This shift from FTP to AWS was performed keeping in mind that most of our participants have bandwidth constraints and are not familiar with FTP access… Read More »

Cannot get the column information from OLE DB provider

By | March 19, 2016

Cannot get the column information from OLE DB provider “Microsoft.Ace.OLEDB.12.0” for linked server “(null)”. Encountered this little gem while performing a migration today. Turns out the SQL Server service account is used when establishing Linked Server Connection to a csv file and as a result the OLEDB connection fails with messages like could not read… Read More »

What do indexes really look like?

By | March 12, 2016

We all have seen the traditional diagram that represents a B-Tree and I am sure we all resort to it when we try and explain how a B-Tree works. I know I have used it in my fair share of examples. Now while this diagram is great to explain the concept to novices it’s not… Read More »

Adding additional Network interfaces in Azure

By | March 10, 2016

In this post we cover how to add an additional NIC card to our Azure VM. Most real world production environments have multiple NIC (Network cards) and quite a few applications depends on using dedicated NICs for scalability or even High Availability. In a previous post we covered how to add a VM to a… Read More »

Monitoring Billing in Azure by Resource Group

By | March 10, 2016

In our previous post we explored how to organize resources deployed in Azure. In this post we explore how to understand the impact of the resources that were deployed. If you navigate to the Azure portal and click on the Resource group’s link on the top left a list of deployed resource groups will be… Read More »

The jumpy mouse problem solved using XE

By | March 10, 2016

I have a mouse (the real one that we connect to our laptops not the fake one that runs around after cheese :-p) that jumps all over my screen and every once in a while it lands right on the little X button on the top right corner and I end up clicking before I… Read More »

Creating a Resource Group in Azure

By | March 9, 2016

A resource group is a nice little feature that helps Azure Administrators stay organized when managing a large scale deployment. In its simplest sense it behaves like folders on your hard disk, it helps related resources stay together and be addresses by a common name. If a developer is working for multiple projects he might… Read More »