Ultimate Guide to Explore SQL Server

SQL Server Error 1105
Stacy Brown | December 19th, 2015 | SQL Transaction Log
SQL Server database can encounter many errors and issues with it. Any type of issue with the server is followed by errors and every error belongs to Learn More →
rename sql server database icon
Stephen West | December 17th, 2015 | SQL Transaction Log
Introduction Sometimes it happens that we need to rename SQL Server database because the database might have been restored using different names or the original name of Learn More →
Function and Stored Procedures in SQL
Andrew Jackson | December 17th, 2015 | SQL Transaction Log
Overview Functions are routine that perform actions like complex calculations, accept input parameter and return the result of that action as a value, whereas, Stored Procedure are Learn More →
Delete SQL server database icon
Stacy Brown | December 9th, 2015 | SQL Transaction Log
Introduction The blog discusses how to delete SQL Server Database by using SQL Server Management Studio and Transact-SQL. The query is user want to delete a SQL Learn More →
SQL Server Error 26 icon
Stephen West | December 3rd, 2015 | SQL Transaction Log
Users often see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message while connecting to SQL Server. SQL Server Error 26 occurs when users Learn More →
SQL Server 2016 New Features For a DBA
Andrew Jackson | November 30th, 2015 | SQL Transaction Log
SQL Server 2016 version has several promising New features for a database administrator and with this release of SQL Server 2016 version, Microsoft has provided a completely Learn More →
Convert SQL Server Data to MS Access
Stephen West | November 25th, 2015 | SQL Server Migration
Storing and retrieving of data has become easy with the emergence of Database Management System. For business organizations, managing their data became much easier with RDBMS. Microsoft Learn More →
sql server backup icon
Andrew Jackson | November 21st, 2015 | SQL Transaction Log
Introduction This article describes how to create a full database backup in SQL Server using SSMS (SQL Server Management studio) and T-SQL (Transact-SQL). Backup is very important Learn More →
shrink log file
Stacy Brown | November 16th, 2015 | SQL Transaction Log
Introduction Transaction Logs are integral part of SQL Server Database.The blog discusses on how to shrink Transaction log file in SQL Server.MS SQL Transaction Log file is Learn More →
Enable and disable index
Stephen West | November 3rd, 2015 | SQL Transaction Log
Introduction Disable indexes feature is available in SQL Server 2005 and all the later versions to prevent user access to the index. In Microsoft SQL Server 2000 Learn More →