The Experts below are selected from a list of 17352 Experts worldwide ranked by ideXlab platform
Martínez Bermúdez, Mathias Alberto - One of the best experts on this subject based on the ideXlab platform.
-
Desarrollo de una aplicación web para la mejora de la gestión documental en el Instituto Nacional de Estadística e Informática
'Universidad Inca Garcilaso de la Vega', 2018Co-Authors: Martínez Bermúdez, Mathias AlbertoAbstract:The National Institute of Statistics and Informatics - INEI is a technical organism specialized to direct, coordinate and supervises the official statistical activities of Peru. Within its environment, the document processing system "Sisdoc 2000" has shortcomings in the documentary process; likewise, it does not have the option of attaching digital documents and the time to register documents is increasingly gradual due to the age of the system. Therefore, the purpose of the technological solution is to develop a web application using the RUP methodology to improve the document Management and at the same time the documents are digitized for a better conservation. For the development of the application we used the programming language C # with ASP.NET technology and as a database manager Microsoft SQL Server Management Studio. The results obtained during the tests were positive, where the quality indicators were satisfactorily metTesisEl Instituto Nacional de Estadística e Informática – INEI es un organismo técnico especializado de dirigir, coordinar y supervisar las actividades estadísticas oficiales de Perú. Dentro de su entorno, el sistema de trámite documentario “Sisdoc 2000” presenta deficiencias en el proceso documental; así mismo, no cuenta con la opción de adjuntar documentos digitales y el tiempo para registrar los documentos es cada vez más paulatino por la antigüedad del sistema. Por consiguiente, el propósito de la solución tecnológica es desarrollar una aplicación web utilizando la metodología RUP para mejorar la gestión documental y a su vez que los documentos sean digitalizados para una mejor conservación. Para el desarrollo de la aplicación se utilizó el lenguaje de programación C# con tecnología ASP.NET y como gestor de base de datos Microsoft SQL Server Management Studio. Los resultados obtenidos durante las pruebas fueron positivos en donde se cumplió satisfactoriamente con los indicadores de calida
Estrella Izurieta, Johan Alexei - One of the best experts on this subject based on the ideXlab platform.
-
Análisis e implementación para la creación de un clúster SQL server como solución centralizada de bases de datos satélites
2016Co-Authors: Estrella Izurieta, Johan AlexeiAbstract:The present project analyzes a viable and sustainable solution for companies that need to improve the availability, scalability, and security of their information by centralizing in a cluster a SQL Server database in SQL Server satellites. This will allow to decrease administrative time, increase high ability to information, and improve performance. Consequently, it will release hardware resources that could be reused on current requirements or in future projects, trying in this way to benefit companies that require it. To achieve this goal, a virtual infrastructure is created on which a SQL Server cluster consisting of two virtual nodes simulating an infrastructure of a companywill bedeployed, this will feature a virtual machine to handle the volumes of information presented to the cluster to storage the information, an Active Directory server for control and safety of the own accounts of the cluster, a computer that has SQL Management Studio for testing. Based on this implementation, an implementation manual is generated, which will serve as a guide for future implementations.El presente proyecto de titulación analiza una solución viable y sostenible en el tiempo para las empresas que requieren mejorar la disponibilidad, escalabilidad y seguridad de la información, al centralizar en un Clúster SQL Server las bases de datos SQL Server satélites de sus aplicativos, que permite lograr disminuir los tiempos administrativos, incrementar alta disponibilidad a su información, mejorar el performance y de esta forma liberar recursos de hardware que podrían ser reutilizados en requerimientos actuales o futuros proyectos, tratando de esta forma de beneficiar a las empresas que lo requieran. Para conseguir este objetivo se recrea una infraestructura virtual sobre la cual será desplegado un Clúster SQL Server conformado por dos nodos virtuales que simula una infraestructura de una empresa, la misma que contará con una máquina virtual para el manejo de los volúmenes de información presentados al Clúster para el almacenamiento de la información, un servidor Active Directory para el control y seguridad de las cuentas propias del Clúster, un computador que cuente con SQL Managment Studio para realizar las pruebas. En base a esta implementación se genera un manual de implementación, el mismo que servirá de guía en futuras implementaciones
Gutierrez Burgos, César Luciano - One of the best experts on this subject based on the ideXlab platform.
-
Sistema de información web para mejorar los procesos en el área de servicio de postventa de la Empresa Autonort Trujillo s.a
Universidad Nacional de Trujillo, 2019Co-Authors: Gonzales Sandoval, Rosa María, Gutierrez Burgos, César LucianoAbstract:El presente trabajo de investigación titulado “Sistema de Información Web para mejorar los procesos en el Área de Servicio de Postventa de la Empresa Autonort Trujillo S.A” tiene como fin lograr que el Servicio de Postventa tenga un mejor control, manejo y consulta rápida de la información. Así como la reducción de tiempos sobre los procesos de registro de citas y atención de las citas, ya que el cliente será un usuario y podrá ver a través de la web información sobre su cita, el mantenimiento de su(s) vehículos y cuando están listos para su entrega. Así mismo, el servicio de postventa permite a las agencias del sector automotriz conocer la opinión de los clientes, identificar oportunidades de mejora y evaluar los productos y procesos. Sin embargo, un deficiente servicio de postventa puede afectar negativamente los puntos de vista de los clientes y disminuir los niveles de ventas. Es así que teniendo la tecnología como herramienta principal reemplazará lo que en la actualidad se viene desarrollando de forma manual. El diseño general de esta Investigación es de tipo Cuasi-Experimental (Pre-Test y Post-Test). Se utilizó encuestas, entrevistas, y observación como técnica de recopilación de datos, se formuló preguntas abiertas y cerradas a los diferentes entrevistados (Asistentes, Asesores de Servicio y Clientes). Y para la contrastación de la hipótesis se utilizaron dos tipos de pruebas estadísticas, para los indicadores cualitativos se utilizó la Distribución t Student, y para los indicadores cuantitativos la Distribución Normal Z; para el modelado se utilizó la metodología RUP y para su desarrollo la tecnología Asp.net con lenguaje C# y JavaScript, IIS y gestor de base de datos SQL Server Management Studio. Con la implementación del Sistema de Información Web se logrará incrementar significativamente los niveles de satisfacción de los clientes, reducir los tiempos en la búsqueda de información de la cita, reducir los tiempos que utilizan los asesores de servicio en atender la Cita y en generar una orden de trabajo.TesisThe present research work entitled "Web Information System to improve processes in the Post-Sales Service Area of the Autonort Trujillo SA Company" Its purpose is to ensure that the After Sales Service has better control, handling and quick consultation of the information. As well as the reduction of time on the processes of record of appointments and attention of the appointments, since the client will be a user and will be able to see through the web information about his appointment, the maintenance of his vehicles and when they are ready for his delivery. Also, after-sales service allows automotive agencies to know the opinion of customers, identify opportunities for improvement and evaluate products and processes. However, a poor after-sales service can negatively affect the clients' points of view and reduce sales levels. Thus, having technology as a main tool will replace what is currently being developed manually. The general design of this research is of the Quasi-Experimental type (Pre-Test and Post-Test). Surveys, interviews, and observation were used as a data collection technique. Open and closed questions were formulated for the different interviewees (Assistants, Service Advisors and Clients). And for the testing of the hypothesis two types of statistical tests were used, for the qualitative indicators the Student t Distribution was used, and for the quantitative indicators the Normal Distribution Z; for modeling the RUP methodology was used and for developing technology Asp.net, C # language and JavaScript, IIS and database manager SQL Server Management Studio. With the implementation of the Web Information System it will be possible to significantly increase the levels of customer satisfaction, reduce the times in the search for information of the appointment, reduce the times used by the service advisors in attending the Appointment and in generating an workorder
Steve Jones - One of the best experts on this subject based on the ideXlab platform.
-
Visually Exploring SQL Server 2005 Management Studio
2010Co-Authors: Dale Elizabeth Corey, Steve JonesAbstract:This book was written to help SQL Administrators and Developers transition from SQL Server 2000 to SQL Server 2005 Management Studio. Topics include: Visually Exploring SQL Server 2005 Management Studio (SSMS), new features of SQL Server 2005 Management Studio, The SSMS Environment and Registered Servers, Object Explorer, Query Editor and Template Explorer, Solution Explorer, and Other Management Tools and Features of SQL Server 2005 including SQLCMD, Dedicated Admin Connection, SQL Configuration Manager, SQL Server Surface Area Configuration Tool, Profiler, and Database Tuning Advisor (DTA).
Buck Woody - One of the best experts on this subject based on the ideXlab platform.
-
administrator s guide to sql server 2005 microsoft windows server system series
2006Co-Authors: Buck WoodyAbstract:“Buck Woody's new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time.”-Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc.“SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!”-Doug Ellis, Area Technical Manager, Cognos“Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing 'DBA 101' sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced.”-Doug Holland, Visual C# MVP, Precision Objects“SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!”-Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest“A solid introduction to administering SQL 2005. The 'DBA 101' sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is.... Buck's conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days.”-Brad Russell, MCDBA, Visionary Integration ProfessionalsThe Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA!This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments.If you're a new SQL Server administrator, Buck will help you master core tasks rapidly-and avoid costly mistakes that only show up when it's too late. If you're familiar with previous versions of SQL Server, he'll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you'll find best practices, real-world scenarios, and easy-to-use automation scripts-all grounded in Buck's unsurpassed SQL Server knowledge.i? i? i? i? ·i? Timesaving tips, practical applications, and start-to-finish examples throughouti? i? i? i? ·i? Understand the key “decision points” at every stage of your SQL Server deploymenti? i? i? i? ·i? Perform day-to-day maintenance more efficiently, from hotfixes to backup/recoveryi? i? i? i? ·i? Automate maintenance tasks with the SQL Server Agenti? i? i? i? ·i? Establish and audit security on SQL Server 2005 and the underlying Windows Server platformi? i? i? i? ·i? Monitor and optimize SQL Server: baselining, profiling, index strategies, query refactoring, and morei? i? i? i? ·i? Maximize availability using replication, clustering, mirroring, and SQL Server's new online indexingi? i? i? i? ·i? Leverage important new improvements in Integration Services and Reporting Servicesi? i? i? i? ·i? Use Analysis Services to support enterprise-class Business Intelligence deploymentsi? i? i? i? ·i? Even set up a simple configuration of SQL Server 2005 for free-legally!Forewordi? xviiiChapter 1: Installation and Configurationi? 1Chapter 2: Architecture and Toolsi? 35Chapter 3: Maintenance and Automationi? 99Chapter 4: Securityi? 173Chapter 5: Monitoring and Optimizationi? 237Chapter 6: High Availabilityi? 295Chapter 7: Notification Services and the Service Brokeri? 365Chapter 8: Integration Servicesi? 399Chapter 9: Reporting Servicesi? 451Chapter 10: Analysis Servicesi? 515Appendix A: Upgrading to SQL Server 2005i? 581Indexi? 605
