Everything SQL related and then some
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…
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…
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…
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…
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…
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…
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…
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…
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…
In this post we cover how to configure the Network security group that was created by default when we set up the VM previously. The Network Security group is just a fancy way of saying Firewall. The NSG allows the user to configure which ports are open or closed within the Virtual network that was…