Ultimate Guide to Explore SQL Server

database index optimization
Stacy Brown | February 28th, 2017 | SQL
Index in SQL Server is used to retrieve requested data speedily from database tables. There are two types of index are used in SQL server i.e. clustered Learn More →
SQL Server Transaction Isolation Level
Daniel Jones | January 19th, 2017 | SQL, SQL Transaction Log
Overview Transaction isolation level on SQL server, decides or determines that how transaction integrity is apparent to other systems and users. The locks (acquired to protect data Learn More →
hardware performance
Stephen West | January 16th, 2017 | SQL Transaction Log
Overview Microsoft SQL server is a platform where one can get their database program up and in fast running mode. The interface or layout of the server Learn More →
Configure Windows Firewall settings
Stephen West | January 12th, 2017 | SQL
SQL server is a database management system developed by Microsoft and it is used to manage and store information on the SQL database. A database is a Learn More →
backup encryption in sql server
Daniel Jones | December 5th, 2016 | SQL Backup & Restore
One of the most essential need of every Database Administrator is a backup file. This file acts as a life savior when any disaster occurs either on Learn More →
Daniel Jones | October 8th, 2016 | SQL Server 2016
SQL Server 2016 is the latest edition of SQL Server. It is the biggest leap forward in the history of Microsoft data platform. It has gain the Learn More →
change-tracking
Stephen West | September 19th, 2016 | SQL
Overview There are three newly introduced features of SQL server 2008, these features are considered as auditing features of the server. List of these features are given Learn More →
Database Fragmentation
Jason Clark | August 12th, 2016 | SQL
What is Fragmentation In SQL Server Database? Fragmentation in SQL Server occurs when the data within a table is inserted, deleted and modified over time. There are Learn More →
sql server log shipping error 14421
Jason Clark | July 27th, 2016 | SQL Server Error
In SQL server, while restoring database from a backup file user come across a very common error i.e. SQL Server error 14421 Error: 14421, Severity: 16, State: Learn More →
SQL-Server-Long-Running-Transaction-Alert
Stephen West | July 25th, 2016 | SQL
Long-Running transaction in SQL Server is one of the main reasons behind the log filling up. This transaction makes the log remain active from the virtual log 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.

Transaction Log Restore