Sql Server 2000 : Version 8 Query analyzer & enterprise manager are separate We can create 65535 databases only Datetime datatype used for both ...

In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. ...

Dear readers,   Now we are going to cover very important activity from a DBA perspective. Database\Server Security is the one of the most important ...

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that ...

SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services ...

This blog is about the interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are ...

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not ...

This article comprises of Questions answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, ...

I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server ...

I was just thinking about few interesting facts about SQL Server properties which are good to be known for a SQL Server DBA. You can not add data and log ...

SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each ...

Checks whether the language of the original media is the same language as the specified service pack.

This rule determines if the Microsoft .NET Framework 3.5 Service Pack 1 is required on the system, based on the features you selected and whether Microsoft ...

This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.

Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.