-
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 Sql Server 2005 : Version 9 Query analyzer & enterprise manager are combined as SSMS XML datatype is introduced We can create max (2^20-1) databases Ranking functions (Row_Number,…
-
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 in various SQL versions like SQL 2005, 2008, 2008 R2 and 2012. SELECT SERVERPROPERTY(‘BuildClrVersion’) AS [BuildClrVersion] , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) AS ComputerNamePhysicalNetBIOS , SERVERPROPERTY(‘ServerName’)…
-
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 organisation relies solely on Database Administrators. Each company has its own sets of Policies applied to Logins & Users and these policies should be thoroughly reviewed…
-
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 on a system database. Below is a consolidated matrix (rows are restrictions) and when you see YES in the column, that means restriction is applied. If there is nothing, that…
-
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 others like Integration Services which does not support named instance. This means, we can have one and only one service of Integration Services on each server. By default, the…
-
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 we install Microsoft SQL Server, five system databases are automatically created for each SQL Server instance. These system databases allow the database engine and administrative applications to properly manage the…
-
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 troubleshooting questionnaire in this blog because I will post a separate Questions\Answers blog for the same. 1) Explain the SQL Server Database Data File structure? SQL server divides the…
-
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, Data File and Transaction Log Architecture Questions from this series because I will cover them in a complete separate series on Database Backup, restores and File Architectures. 1) How many types of files…
-
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. Though it takes lot of time to collect this information and summarize it in a question series but I feel very proud and happy that I am giving…
-
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 model database. You can not add User Defined File Groups in master, model and tempdb database. You can not change the recovery…
-
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 instance you must see one sqlservr.exe in task manager. Like in screenshot. An instance can manage six system databases. An instance can manage one or more…
-
What is SlipstreamMediaInfoCheck?
Checks whether the language of the original media is the same language as the specified service pack.
-
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 Service Pack 1 is already installed.
-
What is DEV10RTMDetected?
This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.
-
What is ServerCoreNetFxCheck?
Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.