Script for the video published here.
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 […]
Polybase database Engine not starting in MS SQL Server
Got this issue recently when Polybase engine didn’t start,it would attempt to start and then fail with connectivity error typical of the SQL server database engine. The solution […]
Can we use in-memory oltp instead of columnstore index for DW queries
Recently when having a chat with a client I was asked if it will be a good idea to replace a view with a static in memory table […]
administration / Azure / MSSQL
Scaling SQL Express with Stretch table feature
Recently I was asked by a client if the Stretch table feature will work with SQL Express and if so what the limitations are. This seemed like an […]
Decimal datatype rounding
Recently I was asked this question about how decimal is rounding off values when doing a simple calculation. The question was I am not able to find why […]