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




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.

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.

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.

How to Use 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.


How to Find Rowcount for all tables in a 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.

How to Uninstall SQL Server Manually

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

How to Configure Database Instant File Initialization Feature in 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.

Share this Article





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





Latest SQL Server Tips