New toys Had a bit of a brain fart moment recently. In all the excitement of installing the latest and greatest version of SSMS I was eager to […]
Converting times across time zones
About 15 years ago I was in charge of maintaining a procedure that had over 300 lines of code dedicated to handling time zone conversions gracefully. It had […]
You Can’t Be King till You’ve Killed Someone
Power tends to corrupt, and absolute power corrupts absolutely. Great men are almost always bad men, even when they exercise influence and not authority; still more so when […]
When is a date not a date in MS SQL SERVER?
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.
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 […]