Question: How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange ...
There might be various reasons for above error, but this case is very specific to a situation where SQL Server was installed on a machine which was in Workgroup whereas the backup destination was the ...
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of the chart elements in the “Visionary/Leader” quadrant, Microsoft leads Tableau by a lit...
Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will s...
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the follo...
In SQL Server, we can create linked server to many other RDBMS. The providers to connect would generally publish by destination RBMS. In this client scenario, they were dealing with linked server to S...
It is clear to me that no one, except for database administrators, has any idea what a DBA does all day long: The post What Does a DBA Do All Day? appeared first on Thomas LaRock. Read the complete ...
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...
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...
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...
