Came across a weird issue while working on a project recently. The process is an ETL job that imports data from CSV files into a table and then […]
Now that AI is here, What next?
We are faced with an interesting decision! Now that LLMs are here how do we proceed. In order to fully grasp the impact of what AI will do […]
Generational Inequity
What is generational Inequity? Generational Inequity refers to a phenomenon influencing various aspects of life such as politics, commerce, and even the judiciary. To best understand generational inequity, […]
SQL 2019:- APPROX_COUNT_DISTINCT
A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image […]
Adding a Quintillion
An interesting problem was asked on #Sqlhelp recently about adding very large numbers, in excess of 20 digits in SSAS tabular model. While most of us will find […]
Azure / MSSQL / TSQL / Uncategorized
Query to find size of tables in Azure database
Quick and dirty way to find the size of all tables in a azure database. DROP TABLE #list DROP TABLE #data GO CREATE TABLE #data ( name VARCHAR(100) […]
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 […]
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 […]