myTechMantra.com

Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012

This article explains the steps to troubleshoot �The remote procedure call failed. [0x800706be]" WMI Error in SQL Server 2012.

Mirrored Database Backup Feature in SQL Server

This article illustrates how to use mirrored database backup feature in SQL Server along with its advantages, disadvantages and best practices..

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 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.

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.

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 Features 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�s 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.

How to Drop Database in SQL Server by Closing Existing Connections

This article demonstrates how to Drop Database in SQL Server when the users are connected to an SQL Server Database.

Free SQL Server eBooks for Download from Microsoft

Free downloadable eBooks from Microsoft on various topics such as SQL Server, SharePoint, ASP.Net, Visual Studio, Windows, Windows Azure, Windows Phone etc.

COPY_ONLY Backups in SQL Server a Rarely Used Feature by DBAs

This article demonstrates how to use COPY_ONLY feature in SQL Server to perform full, differential and transactional log backups without breaking the database restore sequence.

Attach Database in SQL Server

This article demonstrates how to Attach Database in SQL Server.

Detach Database in SQL Server

This article demonstrates how to use Detach Database method in SQL Server.

Troubleshooting Property Owner is not available for Database

This article describes the steps to resolve Property Owner is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights error in SQL Server

Troubleshooting SQL Server Reporting Service Error

Troubleshoot SQL Server Reporting Services Error This page might not function correctly because either your browser does not support scripts or active scripting is disabled in SQL Server 2008.

Create Database in SQL Server

This article demonstrates How to Create Database in SQL Server using TSQL code and by using SQL Server Management Studio.

Change SA Password in SQL Server

This article demonstrates how to change SA Password in SQL Server using TSQL code and by using SQL Server Management Studio.

When SQL Server was last restarted?

In this article we will take a look at different ways in which one can easily identify when was SQL Server last restarted.

Troubleshooting SYSPOLICY_PURGE_HISTORY Job Failure in Failover Cluster Instance of SQL Server 2008

This article describes troubleshooting steps for SYSPOLICY_PURGE_HISTORY SQL Server Job failure in Failover Cluster Instance of SQL Server 2008

Troubleshooting SYSPOLICY_PURGE_HISTORY Job Failure in Stand Alone Instance of SQL Server 2008

This article describes troubleshooting steps for SYSPOLICY_PURGE_HISTORY SQL Server Job failure in Stand Alone Instance of SQL Server 2008

Troubleshooting SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' Error

This article describes steps to Troubleshoot SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' Error in SQL Server.

Performance Dashboard Reports in SQL Server 2012

In this article we will take a look at Performance Dashboard Reports which are Custom SQL Server Reporting Services Report which Microsoft has developed for Database Administrators to get a quick overview of the overall performance of an Instance of SQL Server 2012.

Tips to Avoid Account Lockout Issues

In this article we will take a look at some of the tips which can help you Avoid Account Lockout issues.

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.

Microsoft SQL Server 2012 Build List

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

Using SP_SERVER_DIAGNOSTICS Stored Procedure Quickly Gather Diagnostic Data and Health Information in SQL Server 2012

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

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

How to Back up SQL Server Database

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.

Indirect Checkpoints Feature in SQL Server 2012

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

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.

Using WITH RESULT SETS Feature of SQL Server 2012

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

Troubleshooting OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error

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 a higher version to a lower version

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 a SQL Server 2008 Service Pack

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.

Installing SQL Server 2008 R2 on Windows Server 2008 R2

This article describes the steps to install a standalone instance of SQL Server 2008 R2 on Windows Server 2008 R2.

Why an SQL Server Database from a higher version cannot be restored onto a lower version?

If you are trying to restore a database on an SQL Server 2005 or a lower version from the database backup which was performed on an SQL Server 2008 instance then it will fail. In this article we will take a look at the reason why an SQL Server Database from a higher version cannot be restored onto a lower version of SQL Server.

How to identify if the database was upgraded from a previous version of SQL Server

Is there an easy way to identify whether the database was upgraded from a previous version of SQL Server or it was created on the existing instance of SQL Server? In this article we will go through the steps to identify whether a database was upgraded from a previous version of SQL Server or it was created newly on the existing instance.

How to repair a Suspect Database in SQL Server

This article describes the steps to recovery a database which is marked as SUSPECT.

Steps to Rebuild System Databases in SQL Server 2008

This article demonstrates how to rebuild system databases in SQL Server 2008.

How to Get Exclusive Access to SQL Server Database

In this article we will take a look at how database administrator can leverage ALTER DATABASE Commands to get exclusive or restricted access of a database.

Understanding SQL Server Recovery Models

This article describes about different types of SQL Server recovery models and also discusses difference between Simple, Bulk Logged and Full Recovery Models.

Changing Default SQL Server Backup Folder in SQL Server 2008

This article demonstrates how to change the Default SQL Server Backup Folder in SQL Server 2008 Using Policy Based Management Feature.

Changing the default location of SQL Server Data and Log files

This article demonstrates how to change the default file location of SQL Server Data and Log Files.

Enforce Password Policies and Password Expiration for SQL Server Logins

This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies feature that is available in Windows Server 2003 and later versions to passwords which are used inside SQL Server 2005 and higher versions.

Automate Backup of Analysis Services Database Using SQL Server Agent Job

This article demonstrates how to create an SQL Server Agent Job to backup an analysis services database.

How to Restore an Analysis Services Database Using SQL Server Management Studio

This article demonstrates the steps which a database administrator needs to follow to restore an analysis services database.

How to Backup an Analysis Services Database Using SQL Server Management Studio

This article demonstrates the steps which a database administrator needs to follow to backup an analysis services database.

How to Delete Duplicate Records from an SQL Server Table

This article demonstrates how to take advantage of Common Table Expression (CTE) feature of SQL Server 2005 to delete duplicate records from a table.

Auditing SQL Server Logins

This article demonstrates how a database administrator can easily enable auditing in SQL Server for logins.

How to Hide an Instance of SQL Server 2005

Database administrator is often asked a question whether It is possible to hide an SQL Server Instance? so that it is not visible to users across the network. In this article we will go through the steps which DBA needs to follow in order to hide an instance of SQL Server.

New Date and Time Data Types in SQL Server 2008

SQL Server 2008 introduces four new DATE and TIME data types namely TIME, DATE, DATETIME2 and DATETIMEOFFSET. In this article we will take a look into each of these new data types in detail.

Overview of SQL Server Configuration Manager

An overview of SQL Server Configuration Manager Tool which was introduced in SQL Server 2005. Using this tool you can manage all the SQL Server Services, configure network and client protocols, change service accounts and update service account passwords.

Date and Time Functions in SQL Server 2008

SQL Server 2008 introduces five new functions namely SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, SWITCHOFFSET and TODATETIMEOFFSET. In this article we will take a look into each of these new functions in detail.

How to Remotely Shutdown, Restart or Log Off Windows Server across the network

Database administrators often find the need to restart a remote server once they have completed the installation of an SQL Server Service Pack or a Hot fixes or a Windows Monthly Patch etc. This article gives an insight into SHUTDOWN.EXE command and its usage.

Using Transparent Data Encryption Feature of SQL Server 2008

This article gives you an overview of Transparent Data Encryption feature of SQL Server 2008. Database Administrator can use this new feature of SQL Server 2008 to protect data and log files of databases.

Rowcount for all tables in SQL Server Database

This article describes the different options that are available to get the total number of rows within all tables in a SQL Server Database.

How to Cut Costs with the Help of Technology?

This article gives you a deeper insight into the various means of cutting cost with the help of technology.

New Features in Microsoft SQL Server 2008 R2

Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users, Developers and Database Administrators. This article gives you an overview of some of the new features in SQL Server 2008 R2.

Uninstalling SQL Server 2008

This article is a step by step guide which can be used by database administrators to uninstall SQL Server 2008 Enterprise Edition manually.

Configuring Database Instant File Initialization Feature of SQL Server

SQL Server Database Administrators can leverage Database Instance File Initialization Feature which is available in Microsoft Windows XP Professional, Windows Server 2003 or later versions to reduce the time taken to restore very large databases.

Microsoft SQL Server 2005 Build Versions

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

Microsoft SQL Server 2008 Build Versions

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

Microsoft SQL Server 2008 R2 Build Versions

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

Backup Compression Feature In SQL Server 2008

Microsoft SQL Server 2008 introduces much awaited Database Backup Compression feature. This article describes how database administrators can configure and use database backup compression feature in Enterprise and Developer Editions of SQL Server 2008.