Archives: July 2013
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with service-level agreement (SLAs) or within user expectations. One of the most effective techniques to achieve this objective is to create indexes on tables for your queries. SQL Server uses indexes… Read more
SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer already generates the necessary statistics for a high quality query plan; in a few cases, you need to create additional statistics or modify the query design for best results. By… Read more
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that only authorized users have access to this sensitive information. However, securing SQL Server in a way that won’t create errors is not an easy task, and as database administrators (DBAs),… Read more
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks. It is our responsibility as a database administrator (DBA) to ensure that the information in the databases is available all the time.
Although, a SQL Server various high-availability solutions tries… Read more
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Models here, in which I discussed how you can use BACKUP DATABASE and BACKUP LOG command to perform database and transaction log backup. In this article, I also shared my custom procedure (sp_BackupDatabase),… Read more
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Models here, in which you’ll learn about various SQL Server backup types, and how to add and use permanent backup devices and temporary backup devices to perform SQL Server database backups.
In this… Read more