Got approached with the below error message recently and thought it might be an interesting problem to look into. ProgrammingError((\’42000\’, 651, \'[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot use […]
administration / MSBI / MSSQL / TSQL / Uncategorized
#sqlhelp | should you remove indexes from tables before ETL?
Starting today we are introducing a new type of blog content which covers questions from #sqlhelp. We pick random questions from the feed and try to cover them […]
The-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn -FIXED
Interesting little problem came up today when migrating a database from Azure SQL database to local server. The connections sting in the web app had the following property […]
How secure is the Aadhaar/UIDAI database?
The recent discussion on how social media and Big Data is being misused to profile and categorize users is very serious. However most people don’t seem to grasp […]
Azure Blob Storage usage scenarios for Archival
Azure blob storage is a great way to store large amounts of data. It provides cheap highly available access to data anytime, anywhere. However the nature of data […]
How Random is the RAND() function? SQL, Chance and the universe.
I use the Random function quite a bit to generate dummy data. So recently I was interested to find out actually how random it is. Randomness implies that […]
Tracking DML Operations in SQL tables
Recently I was asked if there was a better way than triggers to perform audits on a table. Essentially the client has a number of tables and each […]
PowerBI Calendar control
A client recently asked for a calendar layout within the report. This is one place where I feel PowerBI seems to lacking significantly since there are no native […]
Multiplexing queries and performance issues
Problem Recently I was approached with an issue which requires multiplexing queries in order to reduce the number of indexes created in azure search. Depending on the service […]