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 […]
Using Azure Storage explorer
When it comes to working with Azure one of the tools almost everybody end up having to use is Azure storage explorer. The tools is a third party […]
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 […]
Identity value skips after restart
Recently a client of mine had complained to me about an issue they were facing when restarts happen on a system. After a restart the system skips the […]