Recently I was asked what tools database professionals use and I wanted to clarify a little bit on the topic so here goes. Previously we used to have […]
Getting all values when input parameter is NULL and still get IX seek behavior!!
Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in […]
Permissions on Amazon S3 to create your own personal Dropbox – Step 2
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 […]
Using Amazon S3 to create your own personal Dropbox – Step 1
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 […]
Cannot get the column information from OLE DB provider
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 […]
administration / Database / MSSQL / TSQL
What do indexes really look like?
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 […]
Creating, Configuring and Querying DocumentDB in Azure
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 […]
Adding additional Network interfaces in Azure
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 […]
Monitoring Billing in Azure by Resource Group
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 […]
The jumpy mouse problem solved using XE
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 […]