Category Archives: T-SQL

Restore SQL Server Database from Multiple Backup Files: Learn the Best Practices

SQL Server can come across errors at any time. To tackle any severe situation, it is always standard practice to backup SQL database. The backup of primary and secondary database files, as well as Transaction log files, are saved as … Continue reading

Rate this:

Posted in Sql Server, T-SQL | Leave a comment

Introduction to SQL Server 2019

Introduction to SQL Server 2019 Microsoft has announced the first public community technology preview (CTP 2.0) of SQL Server 2019. It is powerful and enhanced version of SQL Server. This SQL Server 2019 has a lot of new features, enhanced … Continue reading

Rate this:

Posted in Database Administration, Microsoft News, Mirza Husain, Sql Server New Feature, T-SQL | Tagged , , , , , , , , , , | Leave a comment

DBA- Interview Questions & Answers

Hi Friends, This blog is based on the interview based questions.  I have collected, summarized & prepared the answers and presenting in front of you. These questions are based on Page & Extents in SQL Server. What is the fundamental … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server, T-SQL | Tagged , , , , , , , , , , , , , , , | 2 Comments

Microsoft under the Sea (A journey from Cloud to Sea)

Microsoft under the Sea (A journey from Cloud to Sea) This blog is based on the current news from Microsoft which is related to the milestone project Natick. I am sharing a brief summary and few important highlights however at … Continue reading

Rate this:

Posted in Azure, Database Administration, Microsoft News, Other, Sql Server, T-SQL, windows azure | Tagged , , , , , , , , , , , , , , , , | Leave a comment

Solved: Nonclustered Index Corruption in SQL Sever

Data Corruption is bad. Corruption either occur physically or logically in indexes. The Non-clustered Indexes are pointers of data that helps you in finding data more quickly. It contains Non-clustered key value and each key value has a pointer that … Continue reading

Rate this:

Posted in T-SQL | Leave a comment

How to Repair Suspect Database in SQL Server with DBCC CHECKDB

Sometimes when connecting to the database, the database becomes inaccessible and you will get the following error message: The error message indicates that the database is in SUSPECT mode.

Rate this:

Posted in T-SQL | Leave a comment

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