Category: Server Properties
SQL Server Features

SQL Server Features

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

READ MORE +
0
SQL DBA Cheatcode : SQL Server properties

SQL DBA Cheatcode : SQL Server properties

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. It has been checked ...

READ MORE +
0
Keeping your Server Secure Part 1 : Login Password Policy

Keeping your Server Secure Part 1 : Login Password Policy

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 thing on which any ...

READ MORE +
0
System Databases : Restrictions Matrix

System Databases : Restrictions Matrix

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

READ MORE +
0
Configure SSIS to use Named Instances

Configure SSIS to use Named Instances

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

READ MORE +
0
March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model

March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model

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

READ MORE +
0
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture

March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture

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

READ MORE +
0
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties

March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties

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

READ MORE +
0
March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture

March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture

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 Architecture. ...

READ MORE +
0
10 Interesting things that ‘CAN NOT’ be done in SQL Server

10 Interesting things that ‘CAN NOT’ be done in 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 files in master and ...

READ MORE +
0
Database Engine Instances (SQL Server): A Quick Refresher

Database Engine Instances (SQL Server): A Quick Refresher

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 running SQL Server ...

READ MORE +
0
What is SlipstreamMediaInfoCheck?

What is SlipstreamMediaInfoCheck?

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

READ MORE +
0
What is RS_IsDotNet3_5Installed?

What is RS_IsDotNet3_5Installed?

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 .NET Framework 3.5 ...

READ MORE +
0
What is DEV10RTMDetected?

What is DEV10RTMDetected?

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

READ MORE +
0
What is ServerCoreNetFxCheck?

What is ServerCoreNetFxCheck?

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

READ MORE +
0