Latest Articles on Microsoft SQL Server, BizTalk Server & Sharepoint Server
Product Reviews
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
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 |
