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 […]
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 DECLARE @x DECIMAL(38, 0) = 0 DECLARE […]
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 […]
Forcing Columnstore batch mode on Select * type query
Recently at a consulting project while working with tabular model I was asked about how we can force SQL Server to use batch mode on Columnstore index when […]
administration / Misc / TSQL
Weird ways I explain seemingly complicated SQL topics
Over the years I have accumulated some seemingly weird ways to explain topics within SQL Server. Usually in a training I find that participants are able to relate […]