Final: Question 1 Problems 1 through 3 are an exercise in running mongod’s, replica sets, and an exercise in testing of replica set rollbacks, which…
Hey. Its not just me. Even Microsoft makes spelling mistakes in their softwares… Just found below in an error window from SQL Server 2012 Enterprise…
We have heard enough of the new feature in SQL Server 2012 that replaces our conventional Database Mirroring notion. It is the Always-on Availability groups…
There are several ways to configure and start monitoring page splits on SQL Server. But now in 2012, we could make use of extended events…
I am happy to announce the launch of my webApp+androidApp+desktopApp software www.splitexpense.in. It’s a free tool for anyone or friends and roommates to share and…
Below article on replication was written by my colleague Nideesh K Vasudevan. I would like to thank him for his easy to understand input on this…
This tip would help you retrieve the list of users currently logged on to a remote windows server and disconnect any user if required. To…
What are differences between a latch and a lock? What are the different states of an spid in SQL Server? Explain each state. What are…
Problem A few months back, I had shared a script to automate index rebuild/reorg in a database with fragmentation analysis inplace at https://www.sherbaz.com/2013/06/resumable-auto-index-rebuild-and-reorganize-script/. But that…
Problem In all SQL server failover clusters in our environment, It came to our notice that the SQL Server Agent is spamming the Application eventlogs…