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 my own company as well as for some of my clients who have very specific requirements. One of the more common requirements we find is document search.… Read More »
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 my career while attending an interview I was asked what a relational database is, my answer was “anything that stored data in a row and column format… Read More »
What does 51700 kilotons have to do with this post? That is the min total CO2 Emissions/year from the 11 Million cars that VW says had the cheating device. So what do the below countries have in common? They each produce an estimated 51700 kt of CO2 emissions annually. VW and the fraud that happened,… Read More »
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 poor memory grants and they impact of parameter values in determining how much resources are allocated. I then go on to cover two different ways that the… Read More »
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 VM software since there are different ways that the VM software assigns IP to the Virtual devices. For the purpose of this post I am using VMware… Read More »
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 option is to use a backup and restore the database. This way you don’t lose any of the jobs and other configurations that you may have set… Read More »
While I might seem biased in my choice of wording for the title, the fact is SQL Server is an awesome product. If you looking for actual numbers click here. MS SQL Server is the top OLTP and among the top DW RDBMS. More importantly you see that SQL server provide everything you need to… Read More »
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 often too much security for the purpose of preventing unauthorized access. Often I have had to sign very complicated NDAs just to ensure that I don’t access… Read More »
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 we could have used even in SQL 2014. I know a few clients already using Azure data sync to move historical data to the cloud I can’t… Read More »
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 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count… Read More »