Author Archives: Mirza Husain

About Mirza Husain

Mirza Husain is a senior consultant-database and having more than 10+ years of experience in the IT industry with different domains. He is fond of writing and speaking about SQL Server and also keen to learn new technologies. He is holding MCA degree and having Microsoft certifications as MCP & MCTS. He is also ITIL certified. In his past years, he worked with many clients as Microsoft, Bank of America etc. Currently he is associated with a France based client and offering his best services. You may reach him on his email id -- mirza_dba@outlook.com. Thanks!

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in Always on, Database Administration, Replication, Sql Server, T-SQL | Leave a comment

DBA Daily Tasks

This blog is especially for those people who are preparing to be a Database Administrators or who have just started their career in the database administration field. As a production DBA, we are supposed to perform several tasks on the … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server | Tagged , , , , , , , , , | Leave a comment

Introduction to Microsoft Azure

Microsoft Azure is an open, flexible, enterprise-grade cloud computing platform. Azure was announced in October 2008 and released on February 1, 2010. It provides Software as a service (SaaS) Platform as a service (PaaS) Infrastructure as a service (IaaS) Why … Continue reading

Rate this:

Posted in Azure, Database Administration, T-SQL | Tagged , , , , , , , , , , | Leave a comment

How to add and remove a database to an availability group in Always On

How to add and remove a database to an availability group in Always On Rule: Connect to the server instance that hosts the primary replica. Use the T-SQL statement as below After you add a database to an availability group, you … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , , | Leave a comment

Always On in SQL Server 2017 (Read-Scale Feature)

Always On in SQL Server 2017 (Read-Scale Feature) SQL server 2017 has introduced new feature and technology (read-scale availability group) with Always on. Now, Always On availability groups provide high availability, disaster recovery and read-scale balancing. Read-Scale Availability Group: This … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , | Leave a comment

10 Most Important handy system stored Procedures for DBA

10 Most Important handy system stored Procedures for DBA This blog contains the most important system stored procedures which are supported by SQL Server and are used on a daily basis by DBA. These stored procedures are used commonly for … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , , , , , , | Leave a comment

MS SQL Server Version History – Year Wise

MS SQL Server Version History – Year Wise MS SQL Server is a RDBMS (Relational Database Management System) which is developed by Microsoft. Here we will go through a series of different versions of SQL Server with specified year when … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , | Leave a comment

AlwaysOn Pre-Requisites

AlwaysOn Pre-Requisites  1.Windows 2.SQL Server 3. Databases Hotfix for .NET 3.5 SP1 adds support to SQL client for AlwaysOn. Windows Requirement: The system should not be in a domain controller Windows server 2012 or later versions should be running on … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , , , | Leave a comment

Shift Handover importance in a DBA job- DBA Interview Question

One of my blog readers asked me about shift Handover in a DBA job and how to prepare it. What is the importance of it for a DBA? I am trying to reply and the best possible points to ponder. … Continue reading

Rate this:

Posted in Database Administration, Other, Q & A | Tagged , , , , , , , , , | 1 Comment

Always On – Interview Notes

Always On Always on Availability Groups is a solution which improves database availability and supports a failover environment for a discrete set of user databases. It is introduced in SQL server 2012. Benefits: With the release of Windows Server 2016, … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , | Leave a comment