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 […]
Measuring Uptime in SQL Server – Why nines don’t work
A key part of every DBAs jobs is maintaining uptime. A DBAs capability is measured by the amount of Uptime he is able to ensure on servers he […]
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 […]
LnT Infotech SQL Server Training
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 […]