Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these posts on the weekend). So I’m half writing this sitting on my balcony with a beer, one eye o...
The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightw...
Recently, while deploying a hybrid AlwaysOn availability group for a client, I faced this error. Since it was something I was not able to find many hits on internet search, I thought of sharing this v...
Finally Oracle 12cR2 documentation is here also All Books for Oracle® Database Online is here Cheers Osama...
We live in exciting times, Oracle Database 12.2 for Exadata was released earlier today. The 12.2 database was already available on the Exadata Express Cloud Service and Database as a service for a fe...
As a part of my independent consulting, I also provide a high level overview of the migration strategy. As a part of this engagement, my client wanted me to provide steps to move AlwaysOn availability...
Docker is the most commonly used containerization platform. It provides a platform similar to a virtualization platform, with some added benefits: Docker containers are lightweight Multiple Docker c...
I did a talk at the london .net meetup. This was aimed at .net developers rather than DBA’s so there isn’t much talk about “why you should use source control” etc as everyone in the room used source c...
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on...
Some trivia for your Friday. I recently got a question asking about what the attribute “monitorLoop” is in the blocked-process-report because it’s not really documented. You won’t find too much expl...
While applying patches on SQL server standalone instance, in the cluster, it failed with error as below in Summary.txt file. Let us learn about how to fix Exception data is: System.IO.IOException. Ove...
I was trying to help my client in generating a report large data set. After spending some time and understanding the schema, I could provide them the query to get the results. Now, he wanted to save t...
