Author: Sherbaz

Technology enthusiast Sherbaz is a Microsoft certified SQL Server Subject Matter Expert. He had fun automating day to day task to achieve management goals. He has extensive hands-on experience in high availability deployments and support with several years of industry experience performing SQL Server installations, configuration, maintenance, backups, performance tuning, Transactional & P2P replication, migration, high availability solutions (Always on, Failover Clustering, Logshipping and Mirroring) and Disaster recovery. Sherbaz also has basic hands-on experience in other DBMSs like MongoDB, Oracle 9i, 10g, Sybase and MySQL. 1 year on Mongodb, Oracle 9i & 10g. Completed M102 & M202 courses in MongoDB. Sherbaz spends his spare time with automation in electronics, embedded system circuits and IOT in his private lab at home. Also, he supports his customers and users at www.SplitExpense.in for issues with app, website or telegram chat bot @SplitExpenseBot https://t.me/SplitExpenseBot. @TheSherBot https://t.me/TheSherBot is another telegram chat bot, partially artificial intelligent, programmed and maintained by him on python and backend Mongodb database. Sherbaz always showed interest learning new technologies and to think out of the box bringing innovation in work. Some of his work is documented @ www.sherbaz.com. He is now busy learning 3D modeling software on his roadmap towards building his next hobby build, A 3D PRINTER. Subscribe to his youtube channel https://www.youtube.com/c/SherbazMohamed/

SQL ServerMarch 19, 2012March 19, 2012

Workaround: Control SQL Agent Job Steps based on query outcome.

Below workaround will help you incase if you wanna control SQL agent job steps based on a SQL query output. For eg: Suppose you have…

SQL ServerMarch 16, 2012March 16, 2012

Read Disk Read/ Write for all databases in an instance and Sort them

Below Query will help you read live file level Disk read and write information. WIll behandy for performance tuning capacity planning. select db.name,files.filename,* from sys.dm_io_virtual_file_stats(NULL,…

Database corruptionMarch 7, 2012March 21, 2012

Error: Transaction log file got damaged or corrupted

Once we had an issue in our environment. We had a maintenance activity on the Database server during a weekend and the server was shutdown…

SQL ServerJanuary 26, 2012August 5, 2015

Access Denied error while attaching the database files moved from Windows 2003 server to the new SQL instance on Windows 2008

Issue It’s quite common that we use detach-attach method to migrated SQL server databases from Windows Server 2000 or 2003 to Windows server 2008. During…

Reporting ServicesJanuary 23, 2012March 21, 2012

Error: Unable to access Reports via web browser soon after installing reporting Services

Issue Soon after installing reporting services for my SQL server 2012 on Windows 7, I got the error “User ‘DOMAIN\username’ does not have required permissions. Verify that sufficient…

WordpressJanuary 21, 2012January 23, 2012

Error: Text Editor is not loading or showing up in WordPress – (Fixed)

I had a terrible issue with my wordpress website www.sherbaz.com. I was unable to submit any post for a long time because of this issue.…

Interview QuestionsJanuary 7, 2012December 31, 2013

Interview Questions: SQL Server DBA

Questions Explain SQL Server Failover Clustering? How do we check index Fragmentation? TSQL syntax for Index rebuild and reorg. Difference between the two. How users…

SQL ServerDecember 20, 2011May 22, 2012

Automatically Rebuild or Reorg index based on fragmentation

The Attached SQL Query can be safely used for rebuilding or reorganizing all indexes in a particular database based on the fragmentation level. Note: The…

SQL ServerNovember 18, 2011January 7, 2012

Executing CHECKDB on all user databases via TSQL

Run below Query. And once the query executes completely, go through the SQL Server Error log to see the results. declare databases cursor for select…

SQL ServerNovember 14, 2011January 7, 2012

Read and filter SQL server error logs using TSQL

Command: xp_readerrorlog parameter 1, parameter 2, parameter 3, parameter 4 Parameter 1: To specify the errorlog number. Starts from 0. 0 = current, 1 =…