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





Different ways to Rename SQL Server Database

This article demonstrates different ways in which one can rename SQL Server Database.

How to Synchronize Analysis Services Database Using Synchronize Database Wizard in SSMS

This article demonstrates how to Synchronize Analysis Services Database using Synchronize Database Wizard to make two analysis services databases identical by copying the metadata and data between source and the destination SSAS database.

How to Attach SSAS Database in SQL Server

This article demonstrates the steps to Attach Analysis Services Database in SQL Server Using SSMS and by Using XMLA Script.

How to Detach SSAS Database in SQL Server

This article demonstrates the steps to Detach Analysis Services Database in SQL Server Using SSMS and by Using XMLA Script.

Download Windows Azure Training Kit – Updated October 2012

Download Updated Version of Microsoft Windows Azure Training Kit which includes a comprehensive set of technical content to help one learn how to use Windows Azure.


New Feature in SQL Server 2012 Reporting Services for Developers

This article demonstrates New Features in SQL Server 2012 Reporting Services for SQL Server BI Report Developers.

Product Review of Melissa Data Data Quality Components for SSIS v3.2

Melissa Data's Data Quality Component for SSIS is an excellent suite of custom Data Transformation components for Microsoft's SQL Server SSIS that encapsulates the six levels of complete Data Quality. In this article I will demonstrate how easily an organization can leverage Melissa Data's Contact Verify SSIS Component to Standardize, Verify, Correct and Normalize U.S and Canadian addresses. The usage of this Melissa Data's Data Quality Components can help organizations save millions of dollars in a year by storing accurate customer information in their databases.

Product Review of Devart dbForge Schema Compare for SQL Server

Devart dbForge Schema Compare for SQL Server is an excellent Schema Comparison tool to compare schema between source and target database. This tool can be used by Database Developers and Administrators in their day-to-day work to increase the overall efficiency. This article reviews Devart’s dbForge Schema Compare for SQL Server.

Idera SQL Check is a Free Performance Monitoring tool for SQL Server

Idera SQL Check is a fantastic performance monitoring tool which can be used for monitoring and diagnosing Performance Issues on a single SQL Server Instance. The best thing is that Idera’s SQL Check is a free SQL Server Performance Monitoring Dashboard tool but it has a limitation of monitoring only one server.

How to Rename SQL Server Stand Alone Instance After Installing SQL Server

This article describes steps to be followed to rename SQL Server Stand Alone Instance After Installing SQL Server. The steps mentioned are applicable across SQL Server 2000 and higher versions.

How to Fix Orphaned Users in SQL Server Database

This article demonstrates How to fix Orphaned Users in SQL Server Database.

How to Detect Virtual Log Files in SQL Server Transaction Log File

This article demonstrates How to Detect Virtual Log Files in SQL Server Transaction Log File.

How to Fix Virtual Log Files in SQL Server Transactional Log File

This article demonstrates How to Fix Virtual Log Files in SQL Server Transactional Log file.

How to Attach Database Without a Transaction Log File in SQL Server

This article demonstrates how to attach a database in SQL Server when transaction log file is missing.

How to Change SQL Server Database Auto Growth Settings

In this article we will go through the steps to change SQL Server Database Auto Growth Settings.



Share this Article





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



Trending SQL Server Tips