Ultimate Guide to Explore SQL Server

check active transactions in SQL Server
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
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 →
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 →
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
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 →
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
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
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
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
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.