Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Archives: July 2013

Guide to SQL Server Table Indexes (Part 1)

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

0 comments, 564 reads

Posted in Basit's SQL Server Tips on 15 July 2013

Understanding SQL Server Query Optimization Statistics

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

0 comments, 401 reads

Posted in Basit's SQL Server Tips on 15 July 2013

Microsoft SQL Server security best practices checklist

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

1 comments, 1,066 reads

Posted in Basit's SQL Server Tips on 15 July 2013

Understanding SQL Server Database Restore Process

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

1 comments, 290 reads

Posted in Basit's SQL Server Tips on 15 July 2013

SQL Server Database Backups and Recovery Models – (Part 3)

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

0 comments, 261 reads

Posted in Basit's SQL Server Tips on 15 July 2013

SQL Server Database Backups and Recovery Models – (Part 2)

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

0 comments, 296 reads

Posted in Basit's SQL Server Tips on 15 July 2013