Tag Archives: sense

A simple change that could save Millions of $$$ in Support services

By | August 5, 2015

I recently came across the below error message “An exception was thrown by Target of invocation” What it really means is the application you tried to run has reported an error. This got me thinking about how software has ignored one of the most important yet frustrating aspects of user experience. Easy to understand and… Read More »

Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy

By | July 19, 2015

I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only real social media I follow is LinkedIn and that’s because it is mostly a Professional network. But more importantly, the reason why I don’t have a massive… Read More »

MS SQL Server and Tic Toc and why I changed my mind that it’s a good idea

By | June 26, 2015

I am not sure MS has got it right with the release cycle for SQL server. While this debate has happened before (I was then excited that there will be newer versions of SQL available sooner) now I am older and wiser. The reason I don’t think this approach will work in the long run… Read More »

Which is better Delayed Durability or Optimistic Concurrency

By | March 10, 2015

A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down to the basic task at hand both essentially improve write (and in the latter’s case read) performance, so the question was can they be used together, do… Read More »

Training DBA from other countries

By | February 3, 2015

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference… Read More »

Single Partition online rebuild in SQL 2014

By | January 16, 2015

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the… Read More »

Best practices for Cloud backups

By | January 13, 2015

Continuing our discussion on how to backup databases to the cloud here are a few official and unofficial best practices. Use unique filename; better yet add timestamps to the backup to make sure the cloud blob storage doesn’t overwrite the existing file. Since the whole thing happens outside your premise there is no File overwrite… Read More »