Ultimate Guide to Explore SQL Server

Database Fragmentation
Jason Clark | August 12th, 2016 | SQL
What is Fragmentation In SQL Server Database? Fragmentation in SQL Server occurs when the data is inserted, deleted and modified over time. There are two kinds of 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 →
SQL Server Backup Compression
Overview Of SQL Backup Compression in SQL Server Compression is the process of reduction in bit number required for representing a data. At the database level, SQL Learn More →
copy database from one database to another database
Stephen West | July 13th, 2016 | SQL
Users of SQL Server Database work with various database components including Table, Views, Stored Procedures, etc. In many cases, user may need to copy the SQL Server Learn More →
query stored in sql server 2016
Stacy Brown | July 5th, 2016 | SQL Server 2016
About SQL Server 2016 Query Store SQL Server 2016 has a useful feature embedded with it, which help end-users to improve the query performance. Such feature is Learn More →
SQL Error 983
Stephen West | July 1st, 2016 | SQL Server Error
SQL Server primary purpose is to archive, manipulate and retrieve data as per requested by other several software applications. These applications may run either on identical computers Learn More →
Import Data From Excel to SQL Server
Stacy Brown | June 27th, 2016 | SQL Server Migration
Introduction SQL Server Management Studio (SSMS) has a major property embedded with it i.e. Object Explorer. This property allow users for browsing, choosing & working with several Learn More →
Always Encrypted in SQL Server 2016
Stephen West | June 21st, 2016 | SQL Master Database
Introduction SQL Server has an additional layer of security that keeps the user’s data protected from any malicious activity. This security feature protects data from vulnerable activities Learn More →
SQL Server Error 233
Stacy Brown | June 3rd, 2016 | SQL Master Database
Problem While accessing the DB sometimes user faces the situation when they logging into SQL Server Authentication mode, and it displaying the error message: Troubleshooting SQL Server 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