SQL Server Database DB Mail Configuration Step by Step: This Article will help Configuring SQL Server Database mail in SQL Server for Alerts and Notifications.… Read More »SQL Server Database Mail Configuration Step by Step
What is SQL Server Health Check? Why is it important? A SQL Server health check looks at all aspects of your SQL Server environment in… Read More »What is SQL Server Health Check? Why is it important?
Database File Free space and checking Database Growth Trends is one of the important tasks for a DBA for Pre-Sizing the Database to avoid the… Read More »Database File Free space and checking Database Growth Trends
Moving system databases in SQL Server 2008, 2005 To move all the system and user databases from “C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATA” folder to “C:System databases”… Read More »Moving system databases in SQL Server 2008/2005
When performing some maintenance tasks, particularly in recovery situations, it is essential to limit access to databases by general users by restricting the user access.… Read More »When do we use SQL Server Database in Restricted User Mode?