Just finished a virtual training for LnT InfoTech in EPIP industrial Area. Looking forward to the next training with Well Fargo
Full Text Search on Varbinary (max) Columns and using the Right filters
I love Full text search in MS SQL Server. Although I haven’t seen it being used a lot in client locations, I do use it a lot within […]
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 […]
Video on Performance tuning memory allocation and spill issues
I was inspired by a recent article I read on parameter sniffing to add my own contribution to the topic, I explain how tempdb spools occur due to […]
VM and IP Configurations
Recently there was a post on DB mirroring not working on a VM, in the post I had suggested checking the network connectivity and NIC configurations in the […]
Suspect MSDB and no Backups
Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best […]
SQL 2016 – Dynamic Data Mask –& Hacking the feature
After working with PHI for many years now, I can appreciate the importance of data masking. While normally the first approach is to encrypt the data it is […]
SQL 2016 – Stretch database in detail –CTP 2.3 screenshots with BOL corrected now
If you have been following the buzz around MS SQL 2016 you would surely have heard of Stretch database. The concept is interesting and new and probably something […]
The History of War Analyzed
War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since […]
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 […]