Log in

Relevant bibliographies by topics / Microsoft SQL Server / Journal articles

To see the other types of publications on this topic, follow the link: Microsoft SQL Server.

Journal articles on the topic 'Microsoft SQL Server'

Author: Grafiati

Published: 4 June 2021

Last updated: 25 July 2025

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'Microsoft SQL Server.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Naveen, Muppa. "Microsoft SQL Server to Snowflake." European Journal of Advances in Engineering and Technology 10, no. 7 (2023): 68–71. https://doi.org/10.5281/zenodo.13325325.

Full text

Abstract:

Microsoft’s SQL Server is a database server, and as such, it primarily stores and retrieves data. It is an implementation of both the Relational Database Management System (RDBMS) and the Structured Query Language (SQL). Today, many specialized versions of SQL Server exist catering to a wide spectrum of workloads and demands. For example, there is a data center version tailored to higher levels of application support and scale, and a scaled-down version available as freeware.

APA, Harvard, Vancouver, ISO, and other styles

2

Setiyadi, Didik, Henderi Henderi, and Rita Wahyuni Arifin. "Implementasi Import dan Export Database dengan Menggunakan SQL Server 2008." INFORMATICS FOR EDUCATORS AND PROFESSIONAL : Journal of Informatics 5, no. 1 (2020): 1. http://dx.doi.org/10.51211/itbi.v5i1.1413.

Full text

Abstract:

Abstrak: Import data adalah proses mengambil data dari database lain misalkan Microsoft Access kedalam SQL Server 2008, bisa juga Microsoft Excel yang telah kira miliki dilakukan import data kedalam SQL Server 2008. Pada import dari Microsoft Access bisa kita ambil seluruh table dan datanya atau sebagian saja yang diimport, demikian juga kalo kita akan melakukan import dari Microsoft Excel. Jika kita melakukan import dari Microsoft Access, maka primary key akan hilang dan demikian juga untuk tipe data akan berubah menyesuaikan dengan tipe data yang ada di SQL Server 2008, demikan juga jika mel

APA, Harvard, Vancouver, ISO, and other styles

3

Yuda Mahendra Hasibuan and Muhammad Irwan Padli Nasution. "Penerapan Database Impor dan Ekspor Menggunakan SQL Server 2008." MAMEN: Jurnal Manajemen 2, no. 3 (2023): 327–34. http://dx.doi.org/10.55123/mamen.v2i3.2043.

Full text

Abstract:

Import data is the process of retrieving data from another database, such as Microsoft Access to SQL Server 2008, can also be Microsoft Excel, you have imported data into SQL Server 2008. We can import from Microsoft Access if we wish, all tables and data or only some of them will be imported from Microsoft Excel. If we import from Microsoft Access, then yes the primary key is lost and the datatype is changed according to the existing data type in SQL Server 2008 and imported from Microsoft Excel. The data export process is the process of moving data from a database in SQL Server 2008, to anot

APA, Harvard, Vancouver, ISO, and other styles

4

Kristianto, Ryan Putranda, Edwin Alexander, Yulia Wahyuningsih, Yosefina Finsensia Riti, Stephanus Surijadarma Tandjung, and Andre Hartanto. "Penerapan Algoritma Simple Moving Average Untuk Prediksi Data Time Series Dengan T-SQL Microsoft SQL Server." Center for Sustainable Development Studies Journal (Jurnal CSDS) 1, no. 1 (2022): 15–21. http://dx.doi.org/10.37477/csds.v1i1.369.

Full text

Abstract:

Microsoft SQL Server merupakan DBMS yang sangat populer, yang digunakan sebagai media penyimpanan data. Kemampuan Microsoft SQL Server sebenarnya tidak hanya pada kemampuan memanajemen penyimpanan data saja, namun juga dapat digunakan sebagai data analytic. Pada tulisan ini dijelaskan penerapan algoritma Simple Moving Average untuk prediksi data time series pada Microsoft SQL Server. Teknik pemrograman query yang dipakai adalah T-SQL (Transact SQL) yang merupakan teknik bawaan SQL Server dan didalamnya termasuk teknik – teknik pemrograman query seperti looping, selection dan lainnya. Algoritma

APA, Harvard, Vancouver, ISO, and other styles

5

Guo, Hongfei, Dan Jones, Jennifer Beckmann, and Praveen Seshadri. "Declarative management in Microsoft SQL server." Proceedings of the VLDB Endowment 2, no. 2 (2009): 1294–305. http://dx.doi.org/10.14778/1687553.1687555.

Full text

APA, Harvard, Vancouver, ISO, and other styles

6

Wehde, Ed. "Microsoft to beef up SQL Server security." Network Security 2000, no. 2 (2000): 4. http://dx.doi.org/10.1016/s1353-4858(00)87651-5.

Full text

APA, Harvard, Vancouver, ISO, and other styles

7

Lambert, Sherwood Lane, Jon Holladay, and Dawna M. Drum. "International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access." Journal of Emerging Technologies in Accounting 13, no. 2 (2016): 195–213. http://dx.doi.org/10.2308/jeta-51597.

Full text

Abstract:

ABSTRACT This education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled wee

APA, Harvard, Vancouver, ISO, and other styles

8

Sriramaraju, Sagi. "Microsoft SQL Server in the Modern Enterprise: An In-Depth Analysis of Architecture and Scalability." Journal of Scientific and Engineering Research 10, no. 7 (2023): 104–9. https://doi.org/10.5281/zenodo.10903165.

Full text

Abstract:

<strong>Abstract </strong>Microsoft SQL Server plays a critical role, in corporate environments offering efficient management of extensive operations. This article explores the evolution of SQL Server from a mere database system to a platform that integrates cloud and big data capabilities. The design of SQL Server is intricate and complex reflecting its importance in businesses handling tasks such as transactions, inventory management and healthcare record administration. With its Online Transaction Processing capabilities SQL Server proves invaluable in these areas. Additionally the article

APA, Harvard, Vancouver, ISO, and other styles

9

Chaudhuri, Surajit, and Vivek Narasayya. "Microsoft index turning wizard for SQL Server 7.0." ACM SIGMOD Record 27, no. 2 (1998): 553–54. http://dx.doi.org/10.1145/276305.276378.

Full text

APA, Harvard, Vancouver, ISO, and other styles

10

Kuntadi, Arif, and Yudi Feriandi. "Penggunaan SQL Server dalam Pengolahan Data Warehouse yang Praktis dan Berkelanjutan." Jurnal Algoritma 20, no. 2 (2023): 457–68. http://dx.doi.org/10.33364/algoritma/v.20-2.1522.

Full text

Abstract:

Untuk menampung data yang besar dibutuhkan data Warehouse yang terstruktur agar menghasilkan informasi yang lebih akurat dan menunjang pengambilan keputusan bagi pemangku kepentingan organisasi. Untuk membangun data Warehouse dapat digunakan piranti lunak seperti Microsoft SQL server yang memiliki keunggulan pada aspek data security, skalabilitas, kemampuan kolaboratif, serta extendability. Data serial kependudukan, tenaga kesehatan, ekonomi serta berbagai data primer maupun sekunder yang bersifat kontinyu dapat di unggah kedalam SQL Server sehingga dapat tersimpan secara terstruktur dan perio

APA, Harvard, Vancouver, ISO, and other styles

11

Paraskumar, Patel. "Navigating the Data Landscape: Evaluating Microsoft SQL Server and Presto for Enterprise Needs." Journal of Scientific and Engineering Research 7, no. 12 (2020): 210–18. https://doi.org/10.5281/zenodo.11220080.

Full text

Abstract:

In the realm of data management and analysis, the selection of appropriate technologies is pivotal for businesses aiming to harness the power of data for actionable insights and competitive advantage. This paper presents a comprehensive comparative analysis of two prominent technologies in the field: Microsoft SQL Server and Presto. Microsoft SQL Server, a robust relational database management system (RDBMS), is renowned for its enterprise-grade features, including advanced security measures, sophisticated performance optimization, and seamless integration within the Microsoft ecosystem. In co

APA, Harvard, Vancouver, ISO, and other styles

12

Wang, Dong Yun. "Advanced Studying on Microsoft SQL Server 2008 Data Mining." Applied Mechanics and Materials 20-23 (January 2010): 748–52. http://dx.doi.org/10.4028/www.scientific.net/amm.20-23.748.

Full text

Abstract:

Data mining application used by an enterprise is a powerful tool to help and guide your decision making to keep your products and services competitive. This paper introduces the relate contents for data mining and gives out an overview of typical data mining problems and the tools and models that are available in SQL Server 2008 for solving these problems.

APA, Harvard, Vancouver, ISO, and other styles

13

Kazemitabar, Seyed Jalal, Ugur Demiryurek, Mohamed Ali, Afsin Akdogan, and Cyrus Shahabi. "Geospatial stream query processing using Microsoft SQL Server StreamInsight." Proceedings of the VLDB Endowment 3, no. 1-2 (2010): 1537–40. http://dx.doi.org/10.14778/1920841.1921032.

Full text

APA, Harvard, Vancouver, ISO, and other styles

14

Hanna, Margo. "Data‐mining algorithms in Oracle9i and Microsoft SQL Server." Campus-Wide Information Systems 21, no. 3 (2004): 132–38. http://dx.doi.org/10.1108/10650740410544036.

Full text

APA, Harvard, Vancouver, ISO, and other styles

15

Shin, Jiho. "Comparison of Remaining Data According to Deletion Events on Microsoft SQL Server." Journal of the Korea Institute of Information Security and Cryptology 27, no. 2 (2017): 223–32. http://dx.doi.org/10.13089/jkiisc.2017.27.2.223.

Full text

APA, Harvard, Vancouver, ISO, and other styles

16

Nguyen, An Bao, Lam Nhut Nguyen, and Vi Thi Thuy Ha. "APPLIED DATA WAREHOUSE AND DATA VISUALIZATION IN AQUACULTURE DATA MANAGEMENT IN TRA VINH PROVINCE." Scientific Journal of Tra Vinh University 1, no. 28 (2017): 64–73. http://dx.doi.org/10.35382/18594816.1.28.2017.47.

Full text

Abstract:

This paper introduces an information system developed to maintain data management and reporting on aquaculture in Tra Vinh province. A data warehouse was also built for data analysis and visualization in order to produce general reports and charts that help the managers in decision making. The proposed system was built using .NET technology, Microsoft SQL Server 2014 DBMS, Microsoft SQL Analysis Services and OLAP features of Microsoft Excel 2013

APA, Harvard, Vancouver, ISO, and other styles

17

ŽOUŽELKOVÁ, Iveta. "MICROSOFT SQL SERVER 2008 - BUSINESS INTELLIGENCE DEVELOPMENT AND MAINTENANCE TRAINING KIT." Journal of Technology and Information 4, no. 1 (2012): 81–82. http://dx.doi.org/10.5507/jtie.2012.015.

Full text

APA, Harvard, Vancouver, ISO, and other styles

18

Hodun, Dominika, and Maria Skublewska-Paszkowska. "OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES." Informatics Control Measurement in Economy and Environment Protection 7, no. 3 (2017): 29–32. http://dx.doi.org/10.5604/01.3001.0010.5210.

Full text

Abstract:

The article presents a discussion of the optimisation methods involving the modification of query syntax on the example of the use of indexes that served for the application of the methods in practice, and the presentation and analysis of the test results and their comparison. All the queries were made in a Microsoft SQL Server Management Studio 2014 environment, using the AdventureWorksDW2012 test database provided by Microsoft. The object of the research were SELECT queries, which consequently returned the desired set of output data.

APA, Harvard, Vancouver, ISO, and other styles

19

Serik, Meruert, Meiramgul Mukhambetova, and Alibek Yeskermessuly. "Improving the Content of a Client-Server Technology Training Course: Set up and Collaborative Implementation of Local and Cloud-Based Remote Servers." International Journal of Emerging Technologies in Learning (iJET) 14, no. 21 (2019): 191. http://dx.doi.org/10.3991/ijet.v14i21.10643.

Full text

Abstract:

The integration of software solutions in the content of the training courses as a result of the socio-economic demand has a positive effect on the improvement of training the students for future professional activities. However, the latest achievements of hardware and software are not included in the content of the high education in a timely manner. Therefore, in our research we set the task to improve the content of the training course on the client-server technology using modern software capabilities. The content of the article consists of the conceptual structure of the training course, set

APA, Harvard, Vancouver, ISO, and other styles

20

Preeti, Tupsakhare. "From Legacy to Modern: Migrating with SQL Server Migration Assistant." Journal of Scientific and Engineering Research 7, no. 1 (2020): 304–8. https://doi.org/10.5281/zenodo.13918671.

Full text

Abstract:

In today’s fast-paced digital landscape, modernizing legacy IT systems is essential for organizations seeking to enhance performance, security, and scalability. This white paper delves into the SQL Server Migration Assistant (SSMA), a robust tool developed by Microsoft to streamline the migration of legacy databases to SQL Server. By automating key processes such as schema conversion, data migration, and compatibility assessment, SSMA simplifies the transition and reduces the risk of disruptions. Through a detailed exploration of SSMA’s features and the migration process, along wit

APA, Harvard, Vancouver, ISO, and other styles

21

Yang, Guang. "The Realization of Math Score Query on the Wireless Internet." Advanced Materials Research 756-759 (September 2013): 1141–45. http://dx.doi.org/10.4028/www.scientific.net/amr.756-759.1141.

Full text

Abstract:

Wireless internet is gaining wide spread usage in teaching affairs, especially in score query system development. This paper explores how simple Math score query system can be developed for mobile devices and introduces general framework for designing such score query applications. Using the framework, based on Microsoft database software SQL Server 2000, T-SQL clause is employed to program one stored procedure for Math score query. The framework utilizes mobile phones simulator software, Nokia WAP Toolkit, which interacts with a server-side ASP (Active Server Pages) in conjunction with the as

APA, Harvard, Vancouver, ISO, and other styles

22

Li, Zhi Zhong, Shi Chun Yang, and Zi Tao Liu. "Development of Electric Vehicle Remote Monitoring System's Server and Client Application." Applied Mechanics and Materials 535 (February 2014): 26–31. http://dx.doi.org/10.4028/www.scientific.net/amm.535.26.

Full text

Abstract:

This paper analyzed the practical needs of remote monitoring of electric vehicle and illustrates the overall architecture of a remote monitoring system, and further developed a remote monitoring system of the Server and client application with the ASP.NET and Microsoft SQL Server database language, basically can meet the electric cars remote monitoring of the Server and client needs.

APA, Harvard, Vancouver, ISO, and other styles

23

Muslim, Much Aziz, and Nur Astri Retno. "Implementasi Cloud Computing Menggunakan Metode Pengembangan Sistem Agile." Scientific Journal of Informatics 1, no. 1 (2015): 29–37. http://dx.doi.org/10.15294/sji.v1i1.3639.

Full text

Abstract:

Cloud computing merupakan sebuah teknologi yang menyediakan layanan terhadap sumber daya komputasi melalui sebuah jaringan. Sumber daya yang di sediakan di dalam cloud computing meliputi mesin, media penyimpanan data, sistem operasi dan program aplikasi. Fitur dari cloud computing dipercaya akan jauh lebih hemat dan memuaskan. Masalah yang muncul adalah bagaimana mengimplementasi Cloud Computing dengan menggunakan Windows Azure Pack dan bagaimana provisioning Windows Azure Pack SQL Database. Fokus pada penelitian ini adalah pada proses deploying dan provisioning SQL Database Server. Pengimplem

APA, Harvard, Vancouver, ISO, and other styles

24

Ravi Babu Vellanki. "Microsoft SQL server in the modern enterprise: An in-depth analysis of architecture and scalability." World Journal of Advanced Engineering Technology and Sciences 15, no. 3 (2025): 2047–55. https://doi.org/10.30574/wjaets.2025.15.3.1067.

Full text

Abstract:

This article presents a comprehensive analysis of Microsoft SQL Server's evolution from a traditional database management system to an integrated platform supporting cloud computing and big data analytics. Through examination of its architecture, scalability features, and enterprise implementation strategies, it offers insights for database administrators, IT architects, and business decision-makers seeking to optimize their data infrastructure. The article explores SQL Server's core engine components, storage innovations, high availability mechanisms, cloud integration capabilities, and advan

APA, Harvard, Vancouver, ISO, and other styles

25

Raphaela Mei Lanny Br Aritonang, Gloria, Mhd Arief Hasan, Mohammad Khasbulla Ridwan, Muhamad Nur Iman, Ricky Carlo Pratama Silalahi, and Rizky Suranta Sipayung. "OPTIMASI QUERY SQL SERVER DENGAN TEKNIK INDEXING DAN PERFORMANCE MONITORING." JATI (Jurnal Mahasiswa Teknik Informatika) 9, no. 2 (2025): 3094–99. https://doi.org/10.36040/jati.v9i2.13179.

Full text

Abstract:

Pengelolaan database yang efisien merupakan salah satu tantangan utama dalam dunia teknologi informasi, terutama pada sistem dengan volume data besar dan kompleksitas query yang tinggi. Penelitian ini bertujuan untuk mengoptimalkan kinerja query pada Microsoft SQL Server melalui penerapan teknik indexing dan monitoring performa. Eksperimen dilakukan dengan membandingkan performa query pada database tanpa indeks dan dengan indeks, menggunakan data dummy sebanyak 1 juta baris. Hasil penelitian menunjukkan bahwa penerapan indeks mampu mengurangi logical reads hingga 89.77%, CPU time hingga 68.09%

APA, Harvard, Vancouver, ISO, and other styles

26

Dhiya' Ulhaq Ahmad Ramsi, Ahmad Alfian Ertiansyah, and Siti Mukaromah. "PERBANDINGAN PERFORMA WAKTU EKSEKUSI KUERI ANTARA DATABASE ORACLE DAN SQL SERVER." Prosiding Seminar Nasional Teknologi dan Sistem Informasi 3, no. 1 (2023): 254–59. http://dx.doi.org/10.33005/sitasi.v3i1.369.

Full text

Abstract:

Pada era saat ini, kebutuhan sistem basis data menjadi sangat penting dalam sebuah aplikasi atau pengelolaan di suatu perusahaan. Informasi semakin meningkat sehingga memerlukan tempat penyimpanan yang baik agar dapat dikelola dengan mudah. Terdapat banyak faktor yang mempengaruhi individu atau perusahaan dalam memilih sistem basis data. Salah satunya yaitu kecepatan database dalam memproses eksekusi kueri. Pada artikel ini dilakukan perbandingan waktu kecepatan eksekusi kueri antara database Oracle dan SQL Server untuk perintah SELECT, UPDATE, dan DELETE dengan jumlah maksimal data sebanyak 1

APA, Harvard, Vancouver, ISO, and other styles

27

Nuriev, Marat, Rimma Zaripova, Andrey Potapov, and Maxim Kuznetsov. "Achieving new SQL query performance levels through parallel execution in SQL Server." E3S Web of Conferences 460 (2023): 04005. http://dx.doi.org/10.1051/e3sconf/202346004005.

Full text

Abstract:

This article provides an in-depth look at implementing parallel SQL query processing using the Microsoft SQL Server database management system. It examines how parallelism can significantly accelerate query execution by leveraging multi-core processors and clustered environments. The article explores SQL Server's sophisticated parallel processing capabilities including automatic query parallelization, intra-query parallelism techniques like parallel joins and parallel data aggregation, as well as inter-query parallelism for concurrent query execution. It covers key considerations around effect

APA, Harvard, Vancouver, ISO, and other styles

28

Menzies, D. "Review: 10 Projects You Can Do With Microsoft SQL Server 7." Computer Bulletin 43, no. 1 (2001): 31. http://dx.doi.org/10.1093/combul/43.1.31-c.

Full text

APA, Harvard, Vancouver, ISO, and other styles

29

Chen, Zhimin, Vivek Narasayya, and Surajit Chaudhuri. "Fast foreign-key detection in Microsoft SQL server PowerPivot for Excel." Proceedings of the VLDB Endowment 7, no. 13 (2014): 1417–28. http://dx.doi.org/10.14778/2733004.2733014.

Full text

APA, Harvard, Vancouver, ISO, and other styles

30

Agrawal, Sanjay, Surajit Chaudhuri, and Vivek Narasayya. "Materialized view and index selection tool for Microsoft SQL server 2000." ACM SIGMOD Record 30, no. 2 (2001): 608. http://dx.doi.org/10.1145/376284.375769.

Full text

APA, Harvard, Vancouver, ISO, and other styles

31

Lisovets, S. M., I. L. Kiva, O. G. Guida, and Ya S. Vyshemirska. "ORGANIZING ACCESS TO DATA IN SCADA SYSTEMS USING MICROSOFT SQL SERVER." Scientific notes of Taurida National V.I. Vernadsky University. Series: Technical Sciences 1, no. 2 (2023): 175–78. http://dx.doi.org/10.32782/2663-5941/2023.2.1/28.

Full text

APA, Harvard, Vancouver, ISO, and other styles

32

Tambunan, Leonard, and Karolina Talia Sela. "PERANCANGAN SISTEM INFORMASI PENDATAAN PEMAKAIAN BAHAN BAKAR KENDARAAN PADA PT.DAHEPA DAMAI PRATAMA DENGAN MENGGUNAKAN BAHASA PEMROGRAMAN VISUAL BASIC.NET DAN DATABASE SQL SERVER." JSR : Jaringan Sistem Informasi Robotik 2, no. 2 (2018): 130–36. http://dx.doi.org/10.58486/jsr.v2i2.38.

Full text

Abstract:

PT. Dahepa Damai Pratama is a company who working construction engineering & transportation services. In the process of processing Data collection of vehicles Fuel Consumption is still using Microsoft Excel applications, Microsoft Word in terms of recording or inputting data so it takes a long time in performing their duties and responsibilities respectively  This research carry out to develop data processing Data collection of vehicles Fuel Consumption system and make it easier. PT. Dahepa Damai Pratama need a new data processing information system by utilizing the computer sy

APA, Harvard, Vancouver, ISO, and other styles

33

Góźdź, Rafał, and Maria Skublewska-Paszkowska. "Analiza możliwości zarządzania bazą danych przechowywaną w chmurze." Journal of Computer Sciences Institute 2 (December 30, 2016): 127–32. http://dx.doi.org/10.35784/jcsi.128.

Full text

Abstract:

W artykule przedstawiono porównawczą analizę wydajnościową wybranych systemów baz danych. Porównano czasy wykonania zapytań SQL przez przygotowane bazy danych działające w usłudze chmurowej. Przygotowana baza danych Northwind działająca na SQL Server została przeniesiona na systemy Oracle i PostgreSQL, a następnie trzy wymienione bazy zostały umieszczone w chmurze Microsoft Azure. Proces badawczy został podzielony na trzy etapy. W pierwszej kolejności analizie podlegają zapytania typu Select. W drugim etapie analiza skupia się na kwestii wydajności zapytań SQL DDL, a końcowy etap opisuje anali

APA, Harvard, Vancouver, ISO, and other styles

34

Zadrąg, Michał. "A comparative analysis of the performance of the relational database and the Hadoop environment in the context of analytical data processing." Journal of Computer Sciences Institute 28 (September 30, 2023): 210–16. http://dx.doi.org/10.35784/jcsi.3675.

Full text

Abstract:

The article presents a detailed comparative analysis of the performance of a Microsoft SQL Server relational database and an Apache Hadoop environment in the context of analytical data processing. The study was carried out by execut-ing more than a dozen research scenarios with different queries on datasets of varying sizes. For each research scenario, the average query execution time on different datasets was compared. Based on the results, it was found that the average execution time of queries from the presented scenarios is significantly shorter in MS SQL Server than in Apache Ha-doop.

APA, Harvard, Vancouver, ISO, and other styles

35

Khudaiberdiev, Sakhobiddin Abdurayimovich. "ANALYSING THE MOST CURRENT SERVER-BASED DATABASE MANAGEMENT SYSTEMS." Nazariy va amaliy tadqiqotlar xalqaro jurnali - SJ International journal of theoretical and practical research 5, no. 3 (2023): 36–47. https://doi.org/10.5281/zenodo.8159175.

Full text

Abstract:

<em>This paper discusses the signs by which it is possible to analyze the advantages and disadvantages of database management systems (DBMS). The main criteria considered in the study are performance, scalability, data availability, server functionality, DBMS openness, as well as the availability of development and administration tools for the most up-to-date DBMS, such as DB2, Oracle, Microsoft SQL Server and Informix. During the performance analysis, the indicators of query execution speed, transaction processing and scalability of the system with an increase in data volume are considered. D

APA, Harvard, Vancouver, ISO, and other styles

36

Billy Sabella, Heldalina Heldalina, Karima Zam Zam, and Veri Julianto. "PROGRAM APLIKASI PENGELOLAAN KAS MENGGUNAKAN MICROSOFT VISUAL BASIC 2015 PADA MASJID AL JIHAD BANJARMASIN." TEKNIMEDIA: Teknologi Informasi dan Multimedia 2, no. 2 (2022): 76–82. http://dx.doi.org/10.46764/teknimedia.v2i2.46.

Full text

Abstract:

Research purposes. This study aims to determine the proper cash management at Al Jihad Mosque, and to produce a computer-based Cash Management Application Program using Microsoft Visual Basic 2015 as the Front End, and Sql Server 2014 as a back end at the Al Jihad Mosque in Banjarmasin. Theoretical thinking framework. In this study the theoretical framework is analyzing the cash management that runs on the Al Jihad Mosque in Banjarmasin, by analyzing the information needed by management, related functions, accounting documents and records used, and flowcharts. The application program that was

APA, Harvard, Vancouver, ISO, and other styles

37

Lee, Kukjin, Anshuman Dutt, Vivek Narasayya, and Surajit Chaudhuri. "Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server." Proceedings of the VLDB Endowment 16, no. 11 (2023): 2871–83. http://dx.doi.org/10.14778/3611479.3611494.

Full text

Abstract:

Cardinality estimation is widely believed to be one of the most important causes of poor query plans. Prior studies evaluate the impact of cardinality estimation on plan quality on a set of Select-Project-Join queries on PostgreSQL DBMS. Our empirical study broadens the scope of prior studies in significant ways. First, we include complex SQL queries containing group-by, aggregation, outer joins and sub-queries from real-world workloads and industry benchmarks. We evaluate on both row-oriented and column-oriented physical designs. Our empirical study uses Microsoft SQL Server, an industry-stre

APA, Harvard, Vancouver, ISO, and other styles

38

Jayinudin, J. "Perancangan Sistem Informasi Akuntansi Pajak Bumi Dan Bangunan (PBB) Pada Kantor Kecamatan Cileunyi Bandung Dengan Menggunakan Microsoft Visual Basic 6.0 Dan Microsoft SQL Server 2000 Berbasis Client Server." is The Best [Accounting Information System & Information Technology Business Enterprise] 2, no. 2 (2017): 288–300. http://dx.doi.org/10.34010/aisthebest.v2i2.1825.

Full text

Abstract:

Conditions that occur in the calculation of land tax and building in the Cileunyi District Office already using is based on Law No. 12 of 1994, but in performing procedures tax such as making tax monthly and annual reports are still using Microsoft Office Excel 2007. To the problems, then writer take the title: "Perancangan Sistem Informasi Akuntansi Pajak Bumi dan Bangunan (PBB) Pada Kantor Kecamatan Cileunyi Bandung Dengan Menggunakan Microsoft Visual Basic 6.0 Dan Microsoft SQL Server 2000 Berbasis Client Server". The research used is basic research, the data used is qualitative data

APA, Harvard, Vancouver, ISO, and other styles

39

Ana, P., and PT Bukie. "Design and implementation of online examination administration system for universities." Global Journal of Mathematical Sciences 12, no. 1 (2015): 39–51. http://dx.doi.org/10.4314/gjmas.v12i1.16.

Full text

Abstract:

Online examination system is a web-based examination system where examination is taken online i.e. through the internet or intranet using computer system. It is an effective solution for mass education evaluation. We have developed an online examination system based on a Browser/Server framework using Microsoft Visual Studio 2008 for the design, C# 3.5 for coding, and Microsoft SQL Server as database. ASP.NET is the preferred web technology. The system carries out the examination and auto-grading for multiple choice questions which is feed into the system.KEY WORDS: Online, Examination, System

APA, Harvard, Vancouver, ISO, and other styles

40

Chavali, LN, Lal Hmingliana, Brindha Senthil Kumar, and P. Lakshmi Narayana. "An Approach to Fine Tuning Database Performance in Application Software." Science & Technology Journal 9, no. 1 (2021): 10–13. http://dx.doi.org/10.22232/stj.2021.09.01.02.

Full text

Abstract:

Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.

APA, Harvard, Vancouver, ISO, and other styles

41

Yao, Shuang Liang, and Shuang Tong Wang. "The Research of the Second Class Credit in the Credit System." Advanced Materials Research 989-994 (July 2014): 5209–12. http://dx.doi.org/10.4028/www.scientific.net/amr.989-994.5209.

Full text

Abstract:

In order to solve the problem of the second class credit reporting in manual states, we use the system flow diagrams and case diagrams to analysis the needs of users, and use ER diagrams to introduce the SQL database。This article designs the system of the second class credit reporting based on the campus network. The system uses C # as the development language, SQL Server database as a background and Microsoft Visual Studio 2010 as the development environment, with high security and stability.

APA, Harvard, Vancouver, ISO, and other styles

42

Widjiyati, Nur. "Penerapan Algoritma Greedy pada Query RDBMS Microsoft SQL Server sebagai Sistem Rekomendasi Pembelian Makanan Pokok." Smart Comp: Jurnalnya Orang Pintar Komputer 11, no. 2 (2022): 124–30. http://dx.doi.org/10.30591/smartcomp.v11i2.3507.

Full text

Abstract:

Makanan pokok atau sembako adalah salah satu kebutuhan utama masyarakat Indonesia, yang mana pada sembako meliputi barang sehari – hari yang digunakan masyarakat Indonesia, contohnya : beras, gila pasir, garam dan lain – lain. Dewasa kini, telah banyak terdapat transaksi berbasis layanan dalam bentuk sistem informasi berplatform website atau mobile yang menawarkan barang – barang sembako secara online. Bermacam – macamnya daya beli masyarakat dan frekuensi pembeliannya membuat pengusaha ecommerce sembako tersebut harus dapat mencari celah agar layanan platform ecommercenya tetap terus dipergun

APA, Harvard, Vancouver, ISO, and other styles

43

Aleksic, Slavica, Ivan Lukovic, Pavle Mogin, and Miro Govedarica. "A generator of SQL schema specifications." Computer Science and Information Systems 4, no. 2 (2007): 81–100. http://dx.doi.org/10.2298/csis0702081a.

Full text

Abstract:

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracl

APA, Harvard, Vancouver, ISO, and other styles

44

Chen, Yao Fei. "Research of SQL Server Automatic Marking Based on Logical Formal." Advanced Materials Research 328-330 (September 2011): 2376–79. http://dx.doi.org/10.4028/www.scientific.net/amr.328-330.2376.

Full text

Abstract:

The author proposes a scheme of SQL Server Automatic Marking based on logical formal. The scheme consists of three parts: generating paper, skill assessment and automatic marking. Describe the question's Marking information by using the logical formal method. Achieve automatic Marking by building the logical formal system. Focus on three components of the scheme: logical formal description, get information of database based on ADOX(Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security) and automatic marking of three database operations:Creat,Modify and Delete. Des

APA, Harvard, Vancouver, ISO, and other styles

45

Rubhiyati, Rini, and Retno Lestianawati. "SISTEM INFORMASI PENGELOLAAN PERSEDIAAN BAHAN BAKU BERBASIS CLIENT SERVER PADA CV. ALINEA JAVA SEMARANG." JURNAL TEKNOLOGI INFORMASI DAN KOMUNIKASI 9, no. 1 (2018): 11–18. http://dx.doi.org/10.51903/jtikp.v9i1.163.

Full text

Abstract:

Abstract The management of raw material inventory is a very important part for a company. In the process of inventory management of raw materials conducted on CV.Alinea Java until now still using conventional system using Microsoft Excel 2007, starting from material estimation, ordering process of goods to supplier, process of receipt and expenditure of raw materials, raw material returns, addressed to the leadership and related sections. And the utilization of wireless networks that are less effective because only connected computer warehouse administration and purchasing, not all users, to o

APA, Harvard, Vancouver, ISO, and other styles

46

Giska Melvy Anggraini, Maya Ardila Pasaribu, Nur Annisa, et al. "Perancangan Sistem Informasi Eksekutif Penggajian Karyawan Pada Galon Air Fino Water." Jurnal Sistem Informasi dan Ilmu Komputer 1, no. 4 (2023): 213–29. http://dx.doi.org/10.59581/jusiik-widyakarya.v1i4.1903.

Full text

Abstract:

Executive Information Systems (ISE) have become an integral part of modern corporate management, providing executives with relevant and immediate information to support decision making. This journal discusses the implementation of the Executive Information System in the employee payroll process using the Microsoft Visual Studio 2010 development environment and SQL Server database. This research includes the design, development and implementation of an Executive Information System application for the employee payroll department. The system development methodology focuses on requirements analysi

APA, Harvard, Vancouver, ISO, and other styles

47

Faradila, Alya, and Lutfi Rahmatuti Maghfiroh. "Modeling Metadata and Data from Censuses and Surveys with Graph Databases." Jurnal RESTI (Rekayasa Sistem dan Teknologi Informasi) 7, no. 5 (2023): 1088–96. http://dx.doi.org/10.29207/resti.v7i5.5273.

Full text

Abstract:

Relational database users are switching to non-relational databases because non-relational databases are better able to handle dynamic data storage. One of the institutions that require dynamic data storage is Statistics Indonesia (BPS). Currently, data storage for census and survey activities at BPS is done using a relational database, even though there are metadata changes in each activity. Accommodating metadata changes in each activity requires one database, which creates problems when retrieving some raw data. There is an opportunity for convenience if the data collected is stored in a no

APA, Harvard, Vancouver, ISO, and other styles

48

Telaumbanua, Sri Mahdalena. "Sistem Informasi Akuntansi Penerimaan Dan Pengeluaran Kas Pada Pt. Kawasan Industri Medan (KIM) Persero." Cebong Journal 2, no. 2 (2023): 56–61. http://dx.doi.org/10.35335/cebong.v2i2.123.

Full text

Abstract:

Penerimaan kas merupakan suatu catatan yang dibuat untuk melaksanakan kegiatan penerimaan uang dari penjualan tunai atau piutang yang siap dan bebas digunakan untuk kegiatan perusahaan, sedangkan Pengeluaran kas merupakan suatu proses yang dilakukan untuk melaksanakan pengeluaran kas baik dengan cek maupun uang tunai untuk kegiatan perusahaan. Sistem ini bertujuan untuk memberikan informasi laporan keuangan di PT.KAWASAN INDUSTRI MEDAN(KIM)Persero. Aplikasi yang digunakan dalam penyelesaian skripsi ini antara lain Microsoft Visual Basic 2010, Microsoft SQL Server, dan Unified Modelling Languag

APA, Harvard, Vancouver, ISO, and other styles

49

Rymarski, Piotr, and Grzegorz Kozieł. "Analysis of the possibilities of optimizing SQL queries." Journal of Computer Sciences Institute 19 (June 30, 2021): 151–58. http://dx.doi.org/10.35784/jcsi.2641.

Full text

Abstract:

Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining t

APA, Harvard, Vancouver, ISO, and other styles

50

Xue, Fei, and Xiao Feng Zhang. "Research on Machining Knowledge Base for Numerical Control System." Applied Mechanics and Materials 271-272 (December 2012): 1628–31. http://dx.doi.org/10.4028/www.scientific.net/amm.271-272.1628.

Full text

Abstract:

According to the rapid and efficient requirement of numerical control machining process, a machining knowledge base is developed by building the parameterized models based on the Pro/Engineering three-dimensional design software, using the Visual C++. NET and Microsoft SQL Server software as knowledge base background server. Because of the renewable, large capacity, and three-dimensional model characteristics, the machining knowledge base has the ability of reducing tool stock and preserving optimized parameters, which greatly increase productivity and decrease manufacturing costs.

APA, Harvard, Vancouver, ISO, and other styles

We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!