Category Archives: T-SQL

SQL Server Error 8942 – Know The Reasons and Solution of This Problem

In this article, we have given the solutions to fix SQL server error 8942. We have discussed the reasons, of this error. The user can read this blog to fix this issue with the help of a manual as well as an automated solution Continue reading

Rate this:

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

Perform SQL Server Deleted Data Recovery in a Simplified Way

Don’t worry if you have accidentally deleted SQL server database items, then the user can easily perform SQL server deleted data recovery by safe and reliable SQL recovery application.
Continue reading

Rate this:

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

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