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 »

Permissions on Amazon S3 to create your own personal Dropbox – Step 2

By | March 30, 2016

In our previous post we explored the basics of the Amazon S3 Storage functionality and explored how to create a Bucket and upload and download files from the S3 Account. In this post we explore how to grant permissions to the S3 bucket. I use AWS S3 for a number of reasons such as storing… Read More »

Using Amazon S3 to create your own personal Dropbox – Step 1

By | March 22, 2016

Amazon S3 is one of the most popular services provided by cloud provider Amazon. In a very basic way it’s a cloud based hard drive where you can upload/download files. Its equivalent service in Microsoft Azure is Azure Blob Storage. In this series of post we cover how to setup and configure the AWS S3… 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 »

Creating, Configuring and Querying DocumentDB in Azure

By | March 10, 2016

DocumentDB is a NOSQL JSON based data store available in MS Azure. In this post we cover how to create a document database followed by a Collection and then we store documents into these collection. Once done we will querying the files using the query windows available directly within the portal. First we visit the… 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 »