Home

Ultimate Guide to Explore SQL Server

check active transactions in SQL Server
Check Active Transactions In SQL Server – DBCC OPENTRAN
Andrew Jackson | December 1st, 2018 | SQL Transaction Log
Introduction In SQL Server, transactions are the essential components to trace the database logs. The SQL Server executes all its Statements through the transaction logs. After executing Learn More →
sql server error-40
Fix SQL Server Management Studio Error 40
Andrew Jackson | December 1st, 2018 | SQL Transaction Log
Introduction Sometimes you may get the issue to connect to SQL Server and get the error message error 40 could not open a connection to sql server Learn More →
SQL Server Error 824 – Troubleshooting Guide
Stephen West | December 1st, 2018 | SQL, SQL Server 2016, SQL Server Error
Brief Overview SQL server is a highly popular database management system and despite being efficient in its functioning makes the user encounter some errors during its usage. Learn More →
Best Solution to Fix Table Corruption in SQL Server
Jason Clark | November 30th, 2018 | SQL
The worst scenario that a DBA can encounter is corruption in the SQL Server database. The SQL Server does not notify users for corruption until an attempt Learn More →
master rebuild
Repair Rebuild In SQL Server to Fix Master Database Corruption
Daniel Jones | November 23rd, 2018 | SQL, SQL Master Database
Master Database is the most important part of SQL Server. It stores the user login credentials and information pointers to all databases in SQL Server. Needless to Learn More →
An Intuitive Guide On Page Level Restore in SQL Server
Andrew Jackson | October 6th, 2018 | SQL
SQL Server database is used by many organizations to manage and organize their data. However, due to some catastrophic conditions the user has to face corruption in Learn More →
sql error 7929
How to Fix SQL Server Error 7929 Instantly
Daniel Jones | September 10th, 2018 | SQL, SQL Server Error
Problem: While executing DBCC REINDEX, my SQL Server get restarted suddenly due to some failure in the hardware. After this we were unable to access the database. Learn More →
sql to azure
How to Move SQL Server Database to Azure SQL – Best Solution
Jason Clark | August 29th, 2018 | SQL
There are multiple options available to transfer SQL Server database to Azure . Now a days, you can move database and log files and even the entire Learn More →
Reading SQL Server Transaction logs
Guide For Reading SQL Server Transaction Logs
admin | July 21st, 2018 | SQL Transaction Log
Introduction SQL Server stores all its physical information in the master database whereas all its transactional information in the logs. The .mdf file stores all database objects Learn More →
SQL
Tips to Improve Performance of Slow Running SQL Server
Stephen West | June 29th, 2018 | SQL
SQL Server Running Slow? “While fetching records in SQL Server 2012 database, I am noticing that my database began running too slow from past two weeks, even Learn More →
Useful Links

Become a Writer
Do you have flair of writing for SQL Server & other Database related Technology
We welcome the technical post from bloggers & technical writers who can contribute interesting stories about SQL Server on regular basis. If you think you are a good fit, then this SQL Server Explorer is a Platform for you. Stay in Touch with us.