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.
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.
This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2008 released by Microsoft.
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.
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.
This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2008 R2 released by Microsoft.
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.
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.
This article describes the different options that are available to get the total number of rows within all tables in a SQL Server Database.
This article gives you a deeper insight into the various means of cutting cost with the help of technology.
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.
This article is a step by step guide which can be used by database administrators to uninstall SQL Server 2008 Enterprise Edition manually.
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.
This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2005 released by Microsoft.
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.
|Trending SQL Server Tips|