Latest Articles on Microsoft SQL Server, BizTalk Server & Sharepoint Server
Product Reviews
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.
Microsoft SQL Server Articles
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 illustrates how to use mirrored database backup feature in SQL Server along with its advantages, disadvantages and best practices.
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.
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' because this component is turned off as part of the security configuration for this server
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.
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 backup in SQL Server.
How to Backup Database in SQL Server
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
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
Microsoft SQL Server 2008 R2 Build Versions
This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2008 R2 released by Microsoft.
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
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.
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.
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.
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.
Install Microsoft Office SharePoint Server 2007 on Windows Server 2003 – Part 1
In this article you will see the overview of the steps which you need to follow in order to install and configure all the Prerequisites for Microsoft Office SharePoint Server 2007 on Windows Server 2003.
Install BizTalk Server 2006 on Windows XP or Windows Server 2003 – Part 1
In this article you will see the steps which you need to follow in order to install BizTalk Server 2006. Install previous versions of BizTalk Server was never an easy task. However, in BizTalk Server 2006 the installation process is streamlined. As many of you will be using this product with Windows XP or Windows Server 2003, in this article I will be cover the end to end installation process for those two operating systems.
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. The Database Instance File Initialization feature internally skips zeroing out of data pages thereby reducing the time taken when performing operations such as creation of new databases, adding new data or log files to an existing database, increasing the size of an existing data and log files (including database file auto grow operations) or restoring a database or a filegroup.
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.
Database 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.
Liked it? Share this Article |
