A few days back I got a call close to midnight where a client’s client was facing an issue. They had recently suffered a power failure and the […]
The hazards of data types when deleting data
Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below delete from #tmp where data […]
Call me anything but a GURU
The first time someone called me a SQL Guru it felt a bit odd coz I never considered myself one. But once the initial shock had worn off, […]
Does Partitioning Improve Performance?
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 […]
Setting up Integrated Security / Windows Authentication with Azure SQL Databases
In this lengthy post I explain how to setup Azure AD Authenticated users such that they may be used to connect to SQL Database hosted in Azure. Users […]
Upgrading existing Azure databases to V12
V12 of Azure database has been out for some time now. Combined with all the new features being released in Azure and PowerBI it makes sense to upgrade. […]
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 […]
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 […]