Recently there was a question posted on #sqlhelp about why a database switched to Snapshot isolation level when you make it read only and then reverts back to […]
administration / Errors / TSQL
Cannot use row granularity hint on the table
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 […]
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 […]
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 […]
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 […]
AI-ML / Azure / MSSQL / Uncategorized
Configuring Polybase in MS SQL Server 2016
A bit late in the day but I figured I would add a post on how to configure MS SQL Server Polybase. Polybase is a feature of MS […]
Resetting WordPress Admin password
I recently forgot my blog admin password and thought I was in a heap of trouble until I came across this link. https://codex.wordpress.org/Resetting_Your_Password It explains how to update […]