Recently I came across a requirement where we needed to load Resumes into SQL server and then search these documents for specific keywords. Important things to keep in […]
Video on Memory Optimization for SSIS packages
Improving RAM Utilization within SSIS packages using data types. In this video we explore the impact of incorrect data types on how SSIS allocates RAM and the simple […]
Using Decision trees Algorithm in Data mining
A small video on how to setup and use the decision tree algorithm in SSAS to perform data mining. This video should help most developers get started. https://www.youtube.com/watch?v=dtoEMqQGcKg
Very Large datasets GB to TB – Where to get them for free?
Every once in a while I need a very large dataset to work with, most often this required creating dummy data using one of my favorite data generators […]
SSIS and SSRS Training for Wells Fargo
4 day training for MS SQL Server SSRS and SSIS with Wells Fargo in Whitefield Bangalore. It’s going to be awesome. Going to create and SQL Server Monitoring […]
Have Databases become a glorified versions of EXCEL?
Recently I was having a discussion about how coding and design patterns have changed in RDMBS and if we can still call it RDBMS anymore. Very early in […]
Combining Results from multiple datasets in SSRS – performance comparison
Recently at a training I was asked how to combine the results from two different datasets, while I have used this function before I couldn’t recollect how much […]
Training MSBI – Wells Fargo – HYD
On the road once again, this time HYD for MSBI training in Wells Fargo. Looking forward to delivering some new content.
SQL 2016 -Row level security misuse: – Visual Totals in SSAS
Ever since I heard of Row level security I have been wanting to try it out. Not the usual stuff that I was sure MS would have already […]
SSIS – Fuzzy grouping task
It’s warm, fuzzy and brings similar data together helping correct typos, different titles for the same role and much more. Today I present a short video explaining how […]