SQL Server Architecture – Are you ready ?

Explaining SQL Server Architecture in one diagram or Image is very difficult.

Even if we get the same from any blog or website, it is not so easy to understand.
Many of us till date did not even know, what are different engines and their use. Continue reading

Advertisements

Moving System Databases – SQL Server 2005

Here I have tried to explain how we can move system databases from one place to another step by step from my experience.

Please follow the below Tasks for moving system databases:

Continue reading

Professional Certification for SQL Server DBAs

Why get certified?

Earning a Microsoft Certification helps validate your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today’s rapidly changing IT marketplace, Microsoft Certifications help you use evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

Whether you are new to technology, changing jobs, or a seasoned IT professional, earning a certification demonstrates to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

Database Administrator IT Professional

This certification is designed for DBA Administrators, and includes three required exams:

  • Microsoft SQL Server 2005 – Implementation and Maintenance (70-431)
  • Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (70-444)
  • Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444)

Database Developer IT Professional

This certification is designed for DBAs who focus on database development, and includes three required exams:

  • Microsoft SQL Server 2005 – Implementation and Maintenance (70-431)
  • Designing Database Solutions by Using Microsoft SQL Server 2005 (70-441)
  • Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442)

Business Intelligence Developer IT Professional

This certification is designed for DBAs who specialize in Business Intelligence, and includes two required exams:

  • Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance (70-445)
  • Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005 (70-446)

SQL Server Security Interview Questions

During the interview I always like to ask below security questions to DBA. I found that sometimes DBAs are not able to answer these questions. Continue reading

SQL Interview Questions and Answers

    Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt! Feel free to email me ‘interview questions’ that you’ve faced. Continue reading

Table & Index Architecture

In this article, we take a brief look at the different kinds of indexes that exist in SQL Server, and how they work. To get us started on this journey, we first need to answer these two questions:

  • What is a table?
  • What is an index?

Continue reading

SQL Server Architecture

This page has moved here

https://sqldbasupport.wordpress.com/2011/06/23/sql-server-architecture-overview/