Iteration 1 on Gathering Knowledge about Microsoft SQL Server
The first iteration on gathering knowledge on Microsoft SQL Server is primarily a brainstorming session that will entail deepening my insight on the Microsoft SQL Server. The researcher will focus on the essence of this server that makes it widely applicable to organizations and industries. Through the brainstorming g session, the researcher will get to acquire much information regarding the server at hand and that will increase his knowledge on the same. The brainstorming was divided into three tiers whereby each one of them entailed gaining insight into the same topic as the researcher continued to build up his knowledge of Microsoft SQL Server.
The major aim of this session was the gathering of information on MS SQL Server so as to enhance the researcher’s knowledge and understanding as to why it has wide application in companies. A brainstorming session is arranged into two sessions whereby the first one involves group brainstorming while the second one involves individual brainstorming. The latter is the one that comes first after which the former builds on it so as to aid in developing a comprehensive report on the topic on which the research is taking place. The first tier will entail the examination of the architecture of the Microsoft SQL Server. That will help shed more light to the server and open a way to the second tier that will entail examining the features of the Microsoft SQL server. The third tier is where the examination of the various mainstream editions will take place, and the last one will involve the study of the main developments that have taken place on the same.
The Microsoft SQL Server is an RDMS (relational database management system) that was developed by Microsoft. That means that, as a database server, SQL Server is a software product that is primarily used to store and retrieve data when requested by other applications that are running on the same or another computer connected to a network (Buffington, 2010). MS SQL Server was considered in this study as the storage and management of data in organizations are very important. The researcher had to develop first the brainstorming session so as to have a guideline in place on how to carry out the research and make sure that it is successful at the end. The first thing that took place was the development of the questions that, if answered would offer the required knowledge into the area being researched.
The questions developed involved the ones concerning the architecture of the Microsoft SQL Server, its features, its major features, and the improvements that have taken place on the same over time. After the development of the questions took place, the next thing that followed was to have the developed team giving time for each person to collect as much information as they would to achieve the intended objectives. The process was aimed at making the group brainstorming productive. During this session also, there was the incorporation of any information that had been omitted of the clarification of any item on the question sheet. After the individual brainstorming, there was the group brainstorming where those questions had a discussion with the main focus on the architecture, features, mainstream editions, and the improvements that have taken place on the Microsoft SQL Server. The final report was then compiled, while paying attention to the validation of the data.
The researcher observed that the brainstorming session provided him with an in-depth understanding that the Microsoft SQL Server is one of the servers that have been applicable in organizations for quite a long time, and it has had many improvements to suit the technological and data management trends. The Microsoft Corporation markets more than a dozen of various editions of Microsoft SQL Server that is intended for different audiences as well as workloads that range from single computer applications to large Web-facing applications having concurrent users (Jacobson & Misner, 2006). It has had many developments since the first edition was released in the year 1989, SQL Server 1.0 that was used on the 16-bit machines. Below is the architecture that was examined and on which the researcher got to acquire much insight on the functionality of features of the same.
It was observed from the brainstorming session that the Microsoft SQL Server makes the data management self-organizing, self-maintaining, and self-tuning particularly with the Always On Feature, thereby offering near-zero downtime. The FILESTREAM feature supports the unstructured as well as the semi-structured data while accessing any files stored in the file system (Delaney, 2007). The server incorporates better compression features that also help to improve scalability. Its Resource Governor feature allows for resource reservation for specific users or workflows. It was also observed that mainstream editions of Microsoft SQL Server include Datacenter, Enterprise, Standard, Web, Business Intelligence, and Workgroup editions. These all have some features that differentiate one from another and thus suitable for a specific functionality. Also, the improvements that have taken place revolve around data storage, buffer management, concurrency, and locking; data retrieval and programmability among others.
Brainstorming is useful technique useful in generating ideas and coming up with creative solutions to the problems at hand (Furnham, 2000). The brainstorming session was well-arranged, and that resulted in the acquisition of the required information towards gaining in-depth understanding into the Microsoft SQL Server. The individual brainstorming helped to clarify some of the questions and to incorporate some other points that helped to garner useful information that informed the research topic. Also, the group brainstorming that built on the individual brainstorming session helped to join ideas and come up with reliable and valid data that would be useful in developing the final report. The first iteration helped the researcher to have the basic knowledge of the Microsoft SQL Server that in turn prepared him for the forthcoming iterations. The time was well-utilized resulting in the acquisition of much knowledge within the limited time.
Even though the brainstorming session helped the researcher to acquire much knowledge on Microsoft SQL Server, there were so many things that were left out due to the issue of time. More time would have to be dedicated to the remaining iterations so as to make sure that all the information that is in requirement is gathered and analyzed. The brainstorming session also needs to be supplemented with the training so as to grasp adequately the server concepts and the way one manages it and the data in storage. Also, some questions were very general, hence resulting in missing out useful points on the topic. There will be a requirement for improvement in the future whereby the brainstorming questions will be very narrow and specific so as to garner the exact information on a given topic.
Buffington, J. (2010). Microsoft SQL Server. Data Protection for Virtual Data Centers, 267-315.
Delaney, K. (2007). Inside MicrosoftSQLserver 2005: query tuning and optimization. Microsoft Press.
Furnham, A. (2000). The brainstorming myth. Business strategy review, 11(4), 21-28.
Jacobson, R., & Misner, S. (2006). Microsoft SQL Server (TM) 2005 Analysis Services Step by Step. Microsoft Press.