Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]
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 […]
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 […]
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 – 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 […]