Firstly its good to know the types of startup accounts: Local User Account: This user account is created in your…
SQL Server TCP/IP Static and Dynamic Ports must be configured/known by a DBA. If Windows Firewall is active in a…
SQL Server 2008 Recovery Models In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and…
A SQL Server DBA given choice to select his Disk configuration should know the different Raid configurations and should select…
SQL Server 2008 in-built Auditing Functionality has a lot of advantages over traditional way of auditing: 1. SQL Server 2008…
Recycling Error log is another important thing in case if you are storing login auditing with login success to Error…
Quick Step by Step Procedure involved: • Perform a full backup of the database on the Principal server. • Perform…
Dynamic Management Views in SQL Server exists in SYS schema and their names start with DM_. To query a DMV,…
What is the Management Data Warehouse? The Management Data Warehouse(MDW) is a single database/Data Warehouse created inside of a SQL…
In some environments,running Fresh snapshot will take ages to synchronise the subscribers with publishers. Even if it is done in…
This website uses cookies.