MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks




Encrypt Database Backups in SQL Server Using MEDIAPASSWORD Option

This article describes how to Encrypt Database Backups in SQL Server Using MEDIAPASSWORD Option available in Restore Database Command.

Install SQL Server 2012 on Windows Server 2008 R2 Service Pack 1

This article demonstrates the steps you need to follow to Install SQL Server 2012 on a Windows Server 2008 R2 Service Pack 1. However, the steps mentioned can be followed to Install SQL Server 2012 on Windows Server 2008 SP2.

SQL Server 2012 Build List for DBAs and Developers

This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2012 released by Microsoft.

How to Quickly Gather Diagnostic Data and Health Information in SQL Server 2012 Using SP_SERVER_DIAGNOSTICS Stored Procedures

This article describes how to quickly gather Diagnostic Data and Health Information of SQL Server 2012 using sp_server_diagnostics system stored procedure for Performance Analysis.

How to Restore Database in SQL Server Using SSMS or Using TSQL Script

This article demonstrates steps you need to follow to restore a full database backup in SQL Server.

How to Backup Database in SQL Server using SSMS or Using TSQL Script

This article demonstrates steps you need to follow to take a full backup of SQL Server Database.

New Features in Microsoft SQL Server 2012 for Database Administrators

This article demonstrates New Features available in Microsoft SQL Server 2012 for Database Administrators.

New Features in SQL Server 2012 for Database Developers

This article demonstrates New Features available in Microsoft SQL Server 2012 for Database Developers.


How to Configure and Use Indirect Checkpoints Feature in SQL Server 2012

This article demonstrates how to configure and use Indirect Checkpoint Feature of SQL Server 2012.

How to Implement SQL Server Paging Using OFFSET and FETCH Feature in SQL Server 2012

This article illustrates how to achieve SQL Server Pagination using OFFSET and FETCH NEXT Feature of SQL Server 2012.

How to Configure and Use WITH RESULT SETS Feature of SQL Server 2012

This article illustrates with an example the WITH RESULT SETS Feature of SQL Server 2012.

How to Troubleshoot OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error in SQL Server

This article describes how to Troubleshooting OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error Message when Importing data from Excel 2007 file to SQL Server 2008 or while Exporting data from SQL Server 2008 to Excel 2007 file formats.

How to Downgrade SQL Server Database from SQL Server 2014 to SQL Server 2012

This article describes the steps to downgrade an SQL Server 2008 R2 database to SQL Server 2008 using SQL Server Import and Export Wizard.

How to Install SQL Server 2008 Service Pack on Production Server

This article demonstrates how to install a SQL Server 2008 Service Pack.

How to Identify Currently Used SQL Server Authentication Mode

This article demonstrates how to identify currently used SQL Server Authentication Mode using TSQL and SQL Server Management Studio.



Share this Article





Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips



Trending SQL Server Tips