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 […]
Graph database Script- SQL 2017
Script for the video published here. CREATE TABLE Persons ( PersonId INT identity(1, 1) PRIMARY KEY ,PersonName VARCHAR(100) ) AS NODE INSERT INTO Persons SELECT ‘Batman’ UNION SELECT […]
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 […]
Speeding up database restores
This is a simple thing every DBA needs to do when they are done with installing SQL server. However it didn’t seem to be as popular as it […]
PowerBI Connection error when logging into the cloud site
Recently in a training we encountered the below issue. I guess this will only occur in cases like a training room. Essentials the error message we get when […]