Academic literature on the topic 'Microsoft SQL (Computer file)'

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

Select a source type:

Consult the lists of relevant articles, books, theses, conference reports, and other scholarly sources on the topic 'Microsoft SQL (Computer file).'

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.

Journal articles on the topic "Microsoft SQL (Computer file)"

1

Yan, Hai Zhong. "Development Technology of Excel Data Server Application with DELPHI ADO + RemObjectcs Combined (Part 1: The Server Side)." Applied Mechanics and Materials 727-728 (January 2015): 959–64. http://dx.doi.org/10.4028/www.scientific.net/amm.727-728.959.

Full text
Abstract:
Microsoft office Excel is an important part of the Microsoft Office suite of software that can be processed, statistical analysis of various data, with its quick style and rich functionality has been generally welcomed, but with the database networking and sharing trends deepening, Excel application bottlenecks in stand-alone mode began to appear, and the network is the computer information technology in today's inevitable end, I imagine combining ADO technology developed by Delphi Excel data server in order to break this limitation, changes in non-network applications Excel mode.Excel Data Server is a set of services and client program, the server deployed on the server, the client is retrieved by the query language SQL, Excel data file can perform various operations and customer interface directly to form a Web-based application systems, customer service not only to support the application at both ends of the LAN, you can also support the application on the Internet. In this paper, Delphi7.0 support, using ADO and RemObjects SDK tools to develop an Excel data server. RemObjects referred to RO. RO version a lot, but it is recommended to use RemObjects Data Abstract 6.0.43.801, Delphi's experience in the development of it appear to be more stable, server-side and client-side data connections and programming efficiency, data manipulation more convenient.
APA, Harvard, Vancouver, ISO, and other styles
2

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 (September 1, 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 week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.
APA, Harvard, Vancouver, ISO, and other styles
3

Prasetyo, Kurniawan, and Suharyanto Suharyanto. "Rancang Bangun Sistem Informasi Koperasi Berbasis Web Pada Koperasi Ikitama Jakarta." Jurnal Teknik Komputer 5, no. 1 (February 20, 2019): 119–26. http://dx.doi.org/10.31294/jtk.v5i1.4967.

Full text
Abstract:
PT Indolife Pensiontama is a life insurance and pension fund corporation. IKITAMA Cooperation which is acronym of Indolife Pensiontama Employee Association Cooperation is a cooperation organization that having all permanent and active employees as members, in a routin activity IKITAMA Cooperative management manage daily transactions by manual using Microsoft Excel. If there is a new employee or not employed anymore then the record will be updated manually, and also there is no integration with existing human resource system, and all the data saved in Excel File without detail information. With all these problems so the author purpose to make a design and development of web-based cooperation information system. The design using object analytics oriented method by Unified Modeling Language (UML), C# .Net programming language with Microsoft Visual Studio 2012 as text editor and compiler and Microsoft SQL Server for the Database system. Keywords: Information System, Cooperation, IKITAMA.
APA, Harvard, Vancouver, ISO, and other styles
4

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 Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.
APA, Harvard, Vancouver, ISO, and other styles
5

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

Full text
APA, Harvard, Vancouver, ISO, and other styles
6

Glen Ferguson, David. "Redefining File Slack in Microsoft® NTFS." Journal of Digital Forensic Practice 2, no. 3 (December 9, 2008): 140–56. http://dx.doi.org/10.1080/15567280802587965.

Full text
APA, Harvard, Vancouver, ISO, and other styles
7

Wei, Yi Bo. "Design and Implementation of Intelligent Community Information System Based on WSN Technology." Applied Mechanics and Materials 686 (October 2014): 407–11. http://dx.doi.org/10.4028/www.scientific.net/amm.686.407.

Full text
Abstract:
This paper studies the management of intelligent community network at present and technology development of internet of thing at home and abroad, in-depth analyze the existing residential property management system, and design the green energy-saving software platform based on Internet of things for intelligent community, the system platform takes Microsoft Visual Studio 2010 as the development tool, taking SQL Server2008 as the database development environment. In order to meet the normal property management function demand, from the actual demand of the intelligent community management, increase the equipment management, file transfer, public security and other functions in the system. The software meet to the actual needs of the information society in the property management system, has a certain practical application prospect.
APA, Harvard, Vancouver, ISO, and other styles
8

Ji, Xuechun, Maoxian Zhao, Mingyu Zhai, and Qingxi Wu. "Query Execution Optimization in Spark SQL." Scientific Programming 2020 (February 7, 2020): 1–12. http://dx.doi.org/10.1155/2020/6364752.

Full text
Abstract:
Spark SQL is a big data processing tool for structured data query and analysis. However, due to the execution of Spark SQL, there are multiple times to write intermediate data to the disk, which reduces the execution efficiency of Spark SQL. Targeting on the existing issues, we design and implement an intermediate data cache layer between the underlying file system and the upper Spark core to reduce the cost of random disk I/O. By using the query pre-analysis module, we can dynamically adjust the capacity of cache layer for different queries. And the allocation module can allocate proper memory for each node in cluster. According to the sharing of the intermediate data in the Spark SQL workflow, this paper proposes a cost-based correlation merging algorithm, which can effectively reduce the cost of reading and writing redundant data. This paper develops the SSO (Spark SQL Optimizer) module and integrates it into the original Spark system to achieve the above functions. This paper compares the query performance with the existing Spark SQL by experiment data generated by TPC-H tool. The experimental results show that the SSO module can effectively improve the query efficiency, reduce the disk I/O cost and make full use of the cluster memory resources.
APA, Harvard, Vancouver, ISO, and other styles
9

Silalahi, Mesri. "PERBANDINGAN PERFORMANSI DATABASE MONGODB DAN MYSQL DALAM APLIKASI FILE MULTIMEDIA BERBASIS WEB." Computer Based Information System Journal 6, no. 1 (March 31, 2018): 63. http://dx.doi.org/10.33884/cbis.v6i1.574.

Full text
Abstract:
Database appeared and began to develop in line with the needs of processing and data storage to meet the information needs. Database is part of an important building block in an information system. In addition to a relational database (SQL), which stores structured datas in tables with defined schemes, there is a non-relational databases (NoSQL) with a dynamic scheme or unstructured. This study will compare the performance between NoSQL database (MongoDB) and SQL database (MySQL) for a web-based multimedia file storage application that stores files as BLOBs. Performance comparison is based on the speed of execution and the computer resources usage (CPU, memory, and virtual memory).
APA, Harvard, Vancouver, ISO, and other styles
10

Schuster, Andreas. "Introducing the Microsoft Vista event log file format." Digital Investigation 4 (September 2007): 65–72. http://dx.doi.org/10.1016/j.diin.2007.06.015.

Full text
APA, Harvard, Vancouver, ISO, and other styles
More sources

Dissertations / Theses on the topic "Microsoft SQL (Computer file)"

1

Chong, Yew Meng. "Microsoft Windows tutorial." Virtual Press, 1992. http://liblink.bsu.edu/uhtbin/catkey/834636.

Full text
Abstract:
Back in May of 1990, Windows was brought into the arena of viable operating environment due to the significant improvements Windows 3.0 made over its predecessor, Windows 2.11. Windows 3.1, another significant upgrade, was released in May, 1992. As the popularity of Windows has soared, the number of applications developed specifically for Windows has also sky-rocketed. This has translated into a huge demand for Windows programmers.Writing Windows code, however, is never an easy task. In fact, Windows has the reputation of being easy for users but hard for programmers. The difficulties in learning to program in Windows plus the increasing number of beginning Windows programmers lead to an urgent need to provide a solution to the problem: How to ease the learning curve of Windows programming?This is thus the theme of the thesis: building a comprehensive on-line Windows programming tutorial that helps ease the daunting learning curve. Through the use of interesting illustrations, example programs with on-line explanations, this tutorial makes Windows programming easier and more fun to learn.
Department of Computer Science
APA, Harvard, Vancouver, ISO, and other styles
2

Birgersson, Christoffer. "Site to Cloud lösning i Microsoft Azure." Thesis, Luleå tekniska universitet, Institutionen för system- och rymdteknik, 2017. http://urn.kb.se/resolve?urn=urn:nbn:se:ltu:diva-65764.

Full text
Abstract:
I dagens samhälle så blir vi allt mer och mer beroende av den teknik vi utvecklar, därför är det av större vikt att vi alltid skall ha tillgång till den information som vi behöver för att kunna göra våra dagliga sysslor. Detta lägger större press på att de system som utvecklas skall fungera felfritt och man skall ha snabba responstider för att allt ska flyta på så bra som möjligt och om det så skulle bli en kritisk systemkrasch så skall inte informationen gå helt förlorad. Därför har det blivit populärt att ändra från att ha personliga servrar till att köra allt mer och mer applikationer och information i det så kallade ”molnet”.  Därför är det av allt större intresse att ha koll på några av de större leverantörerna av molntjänster och hur man kan använda dessa för att få en bättre verksamhet. Därför kommer denna rapport att handla om hur ett arbete utförts på TeamNorrs begäran för att göra en jämförelse mellan Microsoft Azure, Google Cloud Platform och Amazon Web Services. Den kommer även gå igenom hur responstiderna ser ut till några av världens datacenter med en utgångspunkt från TeamNorrs huvudkontor i Umeå. Rapporten går även igenom hur man själv kan testa på Microsoft Azure, Google Cloud Platform och Amazon Web Services, och hur man i Microsoft Azure kan göra en så kallad ”Site to Cloud” lösning med en VPN tunnel för att kunna skapa en MSSQL backup i molnet. Sedan diskuteras för och nackdelar med det arbete som utförts, samt vilka förbättringar som skulle kunna vara aktuella i framtiden.
In todays society we become more and more dependent on the technology we develop, so it is of greater importance that we always have access to the information we need to do our daily tasks. It is more pressing than ever that the developed systems should work well and that you should have quick response times for everything to flow as smooth as possible and if there would be a critical system crash, the information should not be completely lost. Therefore, it has become more popular to go from, having personal servers to use more and more applications and information in the so-called "cloud". That´s why it is becoming increasingly important to keep track of some of the major cloud service providers and how to use them to archive a better business. This report will be about how a work was done at TeamNorrs request to make a comparison between Microsoft Azure, Google Cloud Platform and Amazon Web Services. It will also review the response times to some of the worlds data centers with a starting point from TeamNorrs headquarters in Umeå. It also describe how you can put up your own environment to test Microsoft Azure, Google Cloud Platform and Amazon Web Services, and how to do a so-called "Site to Cloud" solution with a Virtual Private Network tunnel in Microsoft Azure, where it will also show you how you can create an MSSQL backup in the cloud. Then discusses the pros and cons of the work done and what improvements could be relevant for the future.
APA, Harvard, Vancouver, ISO, and other styles
3

Atger, Dominique. "A Turing machines simulator using a Microsoft Windows' interface." Virtual Press, 1993. http://liblink.bsu.edu/uhtbin/catkey/865965.

Full text
Abstract:
The purpose of this thesis is to develop a software system simulating Turing machines using a Microsoft Windows' Interface.Developed in the 1930's by Alan Turing and Emil Post, Turing machines are defined as "abstract computers" . These machines seem able to solve all problems a modern computer can solve, however complex the problems may be. A Turing machine is a basic computational model for algorithms.The software provides a practical tool to students with a relative notion of Turing machines. The software contains introduction and general information on Turing machines that gives the beginner enough background to use the program. The user can create, modify or run Turing machines saved onto MS-DOS files. Some examples of Turing machines are preloaded. These examples give more help to the beginner.An on-line help facility is provided in order to direct and inform the learning student at each level of the software.The Microsoft Windows' Interface makes the software easy and friendly to use. The software has the modularity which will ease any future enhancement.
Department of Computer Science
APA, Harvard, Vancouver, ISO, and other styles
4

Lambert, Aric Brian. "A controller area network simulation application program for Microsoft Windows." Virtual Press, 1995. http://liblink.bsu.edu/uhtbin/catkey/958782.

Full text
Abstract:
My thesis is to design a Controlled Area Network (CAN) simulator For Microsoft Windows. In a modern world we deal with complex mechanical systems that require special electronic control to guarantee ultimate safety and efficiency. These electronic control systems are responsible for monitoring subsystems within the mechanical systems. A good example of this is the motor vehicles that are being driven on the road today. These vehicles have been designed with increased safety and efficiency, such as electronic controlled anti lock breaks, fuel injection, and power control steering. To run all of these components, the car needs a very well designed protocol to be able to control series of messages being passed from one subsystem to another. To determine which message being passed has higher priority than any other messages. To deal with such circumstances, the Controlled Area Network (CAN) was designed. The purpose of the CAN simulator is to gather statistical information concerning the arbitration, message transfer, error detection, error signaling, and retransmision. The CAN simulating model will consist of one to sixty nodes. Each node is considered as a subsystem for the CAN simulator. The subsystems will be characterized as the breaks, engine, transmission, or any part of a car which needs to be connected to the CAN system. Each node will send one to ten messages through the CAN system. The CAN system will take the messages from the nodes and place them into an Arrival queue. Each node will have its own Arrival queue, and no nodes can have two messages on the bus at the same time. The messages will be sorted in the queues in the order of the time needed to be released onto the bus. There will be an internal clock that will monitor the time for when the messages are needed to be placed onto the bus. If there is a situation where two messages need to be sent at the same time, the arbitrator will determine the priority of the messages to be placed onto the bus. Once the message is on the bus, it will go to a transfer queue. Periodically, there will be an error signal sent with the message that will be detected by the error detection, and it will be required that the message to be retransmitted. At critical points on the simulation, statistical information will be gathered for an analyzation. Some examples of information to be analyzed are 1) verification of the simulation performance on a single node with a single message, 2) network load which is a rate of a utilized bus time to the total bus time, 3) network throughput which is a total number of messages that are transmitted per second, and 4) average response time which will be the average time taken by all messages to gain bus access.PLATFORM DESCRIPTIONThe computer to be used in this project will be an Intel Pentum 100 with 16 megs RAM, two 853 megabyte harddrive, and a 17 inch super VGA monitor. The user interface will be windows 3.1 application. The compiling language to be used will be Microsoft Visual C++.
Department of Computer Science
APA, Harvard, Vancouver, ISO, and other styles
5

Li, Mingrui. "On the size of induced subgraphs of hypercubes and a graphical user interface to graph theory." Virtual Press, 1993. http://liblink.bsu.edu/uhtbin/catkey/879847.

Full text
Abstract:
The hypercube is one of the most versatile and efficient networks yet discovered for parallel computation. It is well suited for both special-purpose and general-purpose tasks, and it can efficiently simulate many other networks of the same size. The size of subgraphs can be used to estimate the efficient communications of hypercube computer systems.The thesis investigates induced subgraphs of a hypercube, discusses sizes of subgraphs, and provides a formula to give bounds on the size of any subgraph of the hypercube.The concept of spanning graphs and line graphs is useful for studying properties of graphs. An MS WINDOWS based graphical system is developed which allows the creation and display of graphs and their spanning graphs, line graphs and super line graphs.
Department of Computer Science
APA, Harvard, Vancouver, ISO, and other styles
6

Wheeler, Ryan. "BlindCanSeeQL: Improved Blind SQL Injection For DB Schema Discovery Using A Predictive Dictionary From Web Scraped Word Based Lists." Scholar Commons, 2015. http://scholarcommons.usf.edu/etd/6050.

Full text
Abstract:
SQL Injections are still a prominent threat on the web. Using a custom built tool, BlindCanSeeQL (BCSQL), we will explore how to automate Blind SQL attacks to discover database schema using fewer requests than the standard methods, thus helping avoid detection from overloading a server with hits. This tool uses a web crawler to discover keywords that assist with autocompleting schema object names, along with improvements in ASCII bisection to lower the number of requests sent to the server. Along with this tool, we will discuss ways to prevent and protect against such attacks.
APA, Harvard, Vancouver, ISO, and other styles
7

Lundström, Anton. "Databasoptimering för användning med Power BI : Hur indexering och kompression kan förbättra prestanda vid datahämtning." Thesis, Högskolan i Gävle, Datavetenskap, 2020. http://urn.kb.se/resolve?urn=urn:nbn:se:hig:diva-32730.

Full text
Abstract:
I mätrummet på Sandvik Coromant finns en lösning för att visualisera maskinhälsa, mäthistorik och servicetider för olika mätinstrument. Lösningen för datavisualiseringen nyttjar verktyget Power BI och är kopplad till Excelfiler. När data väl hämtats in görs en rad modifieringar på tabellerna för att få fram visualiserbar data. Dessa modifieringar i kombination med många Excelark resulterar i att ledtiderna för att uppdatera en Power BI rapport blir väldigt långa. Nu önskas det att istället nyttja en databaslösning för den data dessa Excelfiler innehåller och därmed förbättra dessa ledtider. Således skapades en databas utifrån den data dessa Excelfiler innehöll. Power BI tillåter användaren att importera data från en databas till applikationen på två sätt, via Import Mode eller DirectQuery. Import Mode läser in samtliga tabeller som efterfrågas och lagrar dessa i minnet. DirectQuery ställer frågor direkt till databasen utifrån vad som efterfrågas. I och med denna skillnad i importsätt finns metoder för att optimera den databas som data läses in ifrån. Studien undersöker hur olika typer av indexering och olika typer av kompression av dessa index påverkar svarstiden på frågor ställda av Power BI för att besvara följande två forskningsfrågor: Hur påverkar olika typer av indexering av en databas datahämtningshastigheten vid användning av Power BI? Hur påverkar olika typer av kompression av index datahämtningshastigheten vid användning av Power BI? Studien utfördes genom att studera execution plans och exekveringshastighet för de frågor som ställdes mot databasen av Power BI. Med hjälp av T-SQL kunde exekveringshastigheten för en specifik fråga tas fram. Denna exekveringshastighet jämfördes sedan för de olika typerna av index och kompression mot exekveringshastigheten för samma fråga mot en tabell helt utan index. Detta utfördes sedan på tabeller med varierande antal rader, där antalet rader som testades var 33 001, 50 081, 100 101, 500 017 och 1 000 217. Resultatet av studien visar att för Import Mode är det bästa typen av index ett clustered rowstore index utan kompression, med undantag för tabeller med över 1 001 217 rader där radkompression presterade bättre. För DirectQuery presterade non-clustered rowstore index bäst, men för vilken kompression var resultatet tvetydigt. Detta eftersom samtliga typer av kompression presterade bäst för olika antal rader i tabellen. För tabeller med fler än 500 017 rader presterade dock ingen kompression allra bäst.
In the measurement room at Sandvik Coromant there is a solution for visualizing machine health, measurement history and service times for different measuring instruments. The data visualization solution uses Power Bi and connects to Excel files. Once the data has been collected, a number of modifications are made on the tables to produce something that is possible to visualize. These modifications in combination with many Excel sheets result in very long lead times for updating a Power BI report. Now it is desired to use a database solution for the data contained in the Excel files and thus improve these lead times. For this, a database was created based on the data that these Excel files contained. Power BI allows the user to import data from a database into the application in two ways, via Import Mode or DirectQuery. Import Mode loads all the requested tables and stores them in memory. DirectQuery runs queries directly to the database, based on what is requested. Due to this difference, there are methods to optimize the database from which the data is loaded. This study examines how different types of indexing and different types of compression affect the response time for queries ran by Power BI to answer the following two research questions: How do different types of indexing affect a database's data retrieval rate when using Power BI? How do different types of compression affect the data retrieval rate when using Power BI? This was done by studying execution plans and execution rate for the queries that was done towards the database by Power BI. With the help of T-SQL, the execution rate for a specific query was obtained. The execution rate for different types of index and compression was then compared against a table without an index. This was then performed on tables with varying numbers of rows, where the numbers of rows that were tested was 33 001, 50 081, 100 101, 500 017 and 1 000 217. The results of the study show that for Import Mode, the best type of index is a clustered rowstore index without compression, with the exception of tables with over 1 001 217 rows where row compression performed better. For DirectQuery, non-clustered rowstore index performed best, but for which compression the result was ambiguous. This was because all types of compression performed best for different number of rows in the table. However, for tables with more than 500 017 rows, no compression performed best.
APA, Harvard, Vancouver, ISO, and other styles
8

Poti, Allison Tamara S. "Building a multi-tier enterprise system utilizing visual Basic, MTS, ASP, and MS SQL." Virtual Press, 2001. http://liblink.bsu.edu/uhtbin/catkey/1221293.

Full text
Abstract:
Multi-tier enterprise systems consist of more than two distributed tiers. The design of multi-tier systems is considerably more involved than two tier systems. Not all systems should be designed as multi-tier, but if the decision to build a multi-tier system is made, there are benefits to this type of system design. CSCources is a system that tracks computer science course information. The requirements of this system indicate that it should be a multi-tier system. This system has three tiers, client, business and data. Microsoft tools are used such as Visual Basic (VB) that was used to build the client tier that physically resides on the client machine. VB is also used to create the business tier. This tier consists of the business layer and the data layer. The business layer contains most of the business logic for the system. The data layer communicates with the data tier. Microsoft SQL Server (MS SQL) is used for the data store. The database containsseveral tables and stored procedures. The stored procedures are used to add, edit, update and delete records in the database. Microsoft Transaction Server (MTS) is used to control modifications to the database. The transaction and security features available in the MTS environment are used. The business tier and data tier may or may not reside on the same physical computer or server. Active Server Pages (ASP) was built that accesses the business tier to retrieve the needed information for display on a web page. The cost of designing a distributed system, building a distributed system, upgrades to the system and error handling are examined.Ball State UniversityMuncie, IN 47306
Department of Computer Science
APA, Harvard, Vancouver, ISO, and other styles
9

Zakumba, Lwazi Xolisile. "A case study on the role of excel as a teaching and learning tool in influencing learners' interpretation of functions." Thesis, Nelson Mandela Metropolitan University, 2014. http://hdl.handle.net/10948/d1018756.

Full text
Abstract:
The aim of this study was to investigate the role Excel could play in influencing Mathematics and Mathematical literacy learners’ interpretation of functions and their attitude towards Mathematics. I used a Mathematical Graphical Diagnostic (MGD) test, an attitude questionnaire, a reflective questionnaire and semi-structured interviews as instruments. The MGD test and the attitude questionnaire were given to 72 volunteer grade 11 learners at a former Model C school in Port Elizabeth, in the Eastern Cape. This group included 50 pure Mathematics learners and 22 Mathematical literacy learners. From this group, a smaller group of 10 learners further took part in the rest of the study were they went through an intervention were Excel was used as a teaching tool, covering concepts concerning functions. This group included 6 pure Mathematics and 4 Mathematical literacy learners. The 10 learners then re-wrote the MDG test and refilled the attitude questionnaire after the intervention. A reflective questionnaire was administered to the 10 learners after the intervention, with 5 learners from the 10 undergoing interviews in order to meet the objectives of the study. The administration of the MDG test and attitude questionnaire, interviews and reflective questionnaire enabled me to explore the relationship between learner performance and their attitude towards Mathematics as a subject, as well as the comparing the attitudes and performances between pure Mathematics and Mathematical Literacy learners. The study followed a qualitative research design, with an element of quantitative research. The qualitative data yielded findings that revealed the effectiveness of using Excel in teaching functions while the quantitative data revealed the difference in attitude and ability between pure Mathematics and Mathematical Literacy leaners. The findings of the study revealed that Excel played a major role in improving pure Mathematics learners’ results but not those of the Mathematical Literacy learners. The study also showed that technology does not necessarily impact on learners’ attitudes positively.
APA, Harvard, Vancouver, ISO, and other styles
10

Wigholm, Johan. "Publiceringsfunktion i .NET." Thesis, Jönköping University, JTH, Computer and Electrical Engineering, 2006. http://urn.kb.se/resolve?urn=urn:nbn:se:hj:diva-414.

Full text
Abstract:

Axel Spetz AB är ett anrikt företag som driver en järnhandel i Falköping. Företaget har tidigare använt sig av marknadsföring i lokaltidningen men insåg fördelen med att använda Internet som verktyg. Deras idé var en ”Blocket.se”-liknande funktion på deras hemsida som skulle göra det möjligt för dem att marknadsföra artiklar.

Formuleringen på deras behov och det som legat till grunden för detta projekt var: Hur tillverkar man en avancerad publiceringsfunktion som är lätt att använda?

Inledningsvis gjordes en teoretisk studie inom områdena databaser, SQL, .NET och Visual Studio. Valet föll så här eftersom det var områden jag ville lära mig mer om.

Under utvecklingsarbetet i ovan nämnda tekniker hölls en tät kontakt med representanter från företag för att de snabbt skulle kunna ge respons på arbetet. Projektet resulterade i två olika saker:

-En lösenordsskyddad administrationsdel där all administration såsom publicering av artiklar, hantering av artiklar och kategorier, intresseanmälningar, ändring av öppettider m.m. kan skötas på ett enkelt sätt.

-Företagets hemsida där besökare kan ta del av aktuella erbjudanden, bläddra bland artiklar, kontakta företaget, läsa företagsinformation, lämna intresseanmälningar på artiklar m.m.

All programmering har gjorts med slutanvändarna, dvs. anställda på företaget och besökare på hemsidan i åtanke. Ett antal felkontroller både färdiga och egentillverkade har använts för att se till att fel inte uppstår i arbetet med databasen. Istället för ”riktiga” felmeddelanden visas förklarande texter om vad som måste åtgärdas.

I projektets slutskede så lanserades Axel Spetz nya hemsida och den började direkt användas som ett verktyg i företagets marknadsföring. Jag anser att det är ett bra bevis på att projektet var lyckat.

APA, Harvard, Vancouver, ISO, and other styles
More sources

Books on the topic "Microsoft SQL (Computer file)"

1

SQL fundamentals. 3rd ed. Upper Saddle River, NJ: Prentice Hall, 2008.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
2

SQL instant reference. 2nd ed. San Francisco, Calif: Sybex, 2000.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
3

The SQL programmer's reference: Windows 95/NT & UNIX. Research Triangle Park, NC: Ventana, 1998.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
4

Anderson, Mark. Microsoft SQL server 2008 administration for Oracle DBAs. New York: McGraw-Hill Osborne Media, 2010.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
5

Linoff, Gordon. Data Analysis Using SQL and Excel. New York: John Wiley & Sons, Ltd., 2007.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
6

Data analysis using SQL and Excel. Indianapolis, Ind: Wiley Pub., 2007.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
7

Scripting XML and WMI for Microsoft SQL server 2000: Professional developer's guide. New York: John Wiley, 2001.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
8

Sawtell, Rick. SQL Server 6.5 administration. San Francisco: Sybex Network Press, 1998.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
9

The Guru's guide to SQL server stored procedures, XML, and HTML. Boston: Addison-Wesley, 2002.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
10

Ron, Pihlgren, and Lee Denny Guang-Yeu, eds. Professional Microsoft PowerPivot for Excel and SharePoint. Indianapolis, IN: Wiley, 2010.

Find full text
APA, Harvard, Vancouver, ISO, and other styles
More sources

Book chapters on the topic "Microsoft SQL (Computer file)"

1

Pal, Shankar, Dragan Tomic, Brandon Berg, and Joe Xavier. "Managing Collections of XML Schemas in Microsoft SQL Server 2005." In Lecture Notes in Computer Science, 1102–5. Berlin, Heidelberg: Springer Berlin Heidelberg, 2006. http://dx.doi.org/10.1007/11687238_69.

Full text
APA, Harvard, Vancouver, ISO, and other styles
2

Goh, Kim Nee, Yoke Yie Chen, and Cheah Hui Chow. "Location-Based Data Visualisation Tool for Tuberculosis and Dengue." In Emerging Research and Trends in Interactivity and the Human-Computer Interface, 260–82. IGI Global, 2014. http://dx.doi.org/10.4018/978-1-4666-4623-0.ch013.

Full text
Abstract:
Malaysians suffer from both communicable and non-communicable diseases. Tuberculosis (communicable disease) is common in rural places and dengue (non-communicable disease) is a popular vector-borne disease in Malaysia. Health centres record information of the victims, but merely recording the address in a Microsoft Excel file does not provide much insight to viewers. Currently, an easy to use tool is not available for doctors, officers from the Ministry of Health, and also the public to analyse and visualise the data. It is difficult and time consuming to analyse and interpret raw data tabulated through Microsoft Excel. This research aims to develop a prototype tool that visualises disease data on a Google map. An interpretation is then generated along with the visualisation to give an impartial description about the data. This prototype obtained favourable feedback from a health officer as it can help them in analysing data and assist in the decision making process. The benefit of such application is helpful in tracking diseases’ spreading patterns, how to isolate diseases, as well as mobilising personnel and equipment to the affected areas.
APA, Harvard, Vancouver, ISO, and other styles

Conference papers on the topic "Microsoft SQL (Computer file)"

1

Sícoli, Fábio, and André Simão. "Finding Detached Microsoft SQL Server Database Files." In The Sixth International Conference on Forensic Computer Science. ABEAT, 2011. http://dx.doi.org/10.5769/c2011022.

Full text
APA, Harvard, Vancouver, ISO, and other styles
2

Wagner, Paul J. "The SQL File Evaluation (SQLFE) Tool." In SIGCSE '20: The 51st ACM Technical Symposium on Computer Science Education. New York, NY, USA: ACM, 2020. http://dx.doi.org/10.1145/3328778.3372599.

Full text
APA, Harvard, Vancouver, ISO, and other styles
3

Dong, Minghua, Qin Huang, Shumei Li, and Qingfen Wu. "Applying Microsoft SQL Server database in paper quality evaluation." In 2013 International Conference on Sport Science and Computer Science. Southampton, UK: WIT Press, 2014. http://dx.doi.org/10.2495/cccs130061.

Full text
APA, Harvard, Vancouver, ISO, and other styles
4

Ren, Zhijun. "Constructing a Business Intelligence Solution with Microsoft SQL Server 2005." In 2010 International Conference on Biomedical Engineering and Computer Science (ICBECS). IEEE, 2010. http://dx.doi.org/10.1109/icbecs.2010.5462387.

Full text
APA, Harvard, Vancouver, ISO, and other styles
5

"Changing Paradigms of Technical Skills for Data Engineers." In InSITE 2018: Informing Science + IT Education Conferences: La Verne California. Informing Science Institute, 2018. http://dx.doi.org/10.28945/4001.

Full text
Abstract:
Aim/Purpose: [This Proceedings paper was revised and published in the 2018 issue of the journal Issues in Informing Science and Information Technology, Volume 15] This paper investigates the new technical skills that are needed for Data Engineering. Past research is compared to new research which creates a list of the 20 top tech-nical skills required by a Data Engineer. The growing availability of Data Engineering jobs is discussed. The research methodology describes the gathering of sample data and then the use of Pig and MapReduce on AWS (Amazon Web Services) to count occurrences of Data Engineering technical skills from 100 Indeed.com job advertisements in July, 2017. Background: A decade ago, Data Engineering relied heavily on the technology of Relational Database Management Sys-tems (RDBMS). For example, Grisham, P., Krasner, H., and Perry D. (2006) described an Empirical Soft-ware Engineering Lab (ESEL) that introduced Relational Database concepts to students with hands-on learning that they called “Data Engineering Education with Real-World Projects.” However, as seismic im-provements occurred for the processing of large distributed datasets, big data analytics has moved into the forefront of the IT industry. As a result, the definition for Data Engineering has broadened and evolved to include newer technology that supports the distributed processing of very large amounts of data (e.g. Hadoop Ecosystem and NoSQL Databases). This paper examines the technical skills that are needed to work as a Data Engineer in today’s rapidly changing technical environment. Research is presented that re-views 100 job postings for Data Engineers from Indeed (2017) during the month of July, 2017 and then ranks the technical skills in order of importance. The results are compared to earlier research by Stitch (2016) that ranked the top technical skills for Data Engineers in 2016 using LinkedIn to survey 6,500 peo-ple that identified themselves as Data Engineers. Methodology: A sample of 100 Data Engineering job postings were collected and analyzed from Indeed during July, 2017. The job postings were pasted into a text file and then related words were grouped together to make phrases. For example, the word “data” was put into context with other related words to form phrases such as “Big Data”, “Data Architecture” and “Data Engineering”. A text editor was used for this task and the find/replace functionality of the text editor proved to be very useful for this project. After making phrases, the large text file was uploaded to the Amazon cloud (AWS) and a Pig batch job using Map Reduce was leveraged to count the occurrence of phrases and words within the text file. The resulting phrases/words with occurrence counts was download to a Personal Computer (PC) and then was loaded into an Excel spreadsheet. Using a spreadsheet enabled the phrases/words to be sorted by oc-currence count and then facilitated the filtering out of irrelevant words. Another task to prepare the data involved the combination phrases or words that were synonymous. For example, the occurrence count for the acronym ELT and the occurrence count for the acronym ETL were added together to make an overall ELT/ETL occurrence count. ETL is a Data Warehousing acronym for Extracting, Transforming and Loading data. This task required knowledge of the subject area. Also, some words were counted in lower case and then the same word was also counted in mixed or upper case, thus producing two or three occur-rence counts for the same word. These different counts were added together to make an overall occur-rence count for the word (e.g. word occurrence counts for Python and python were added together). Fi-nally, the Indeed occurrence counts were sorted to allow for the identification of a list of the top 20 tech-nical skills needed by a Data Engineer. Contribution: Provides new information about the Technical Skills needed by Data Engineers. Findings: Twelve of the 20 Stitch (2016) report phrases/words that are highlighted in bold above matched the tech-nical skills mentioned in the Indeed research. I considered C, C++ and Java a match to the broader cate-gory of Programing in the Indeed data. Although the ranked order of the two lists did not match, the top five ranked technical skills for both lists are similar. The reader of this paper might consider the skills of SQL, Python, Hadoop/HDFS to be very important technical skills for a Data Engineer. Although the programming language R is very popular with Data Scientists, it did not make the top 20 skills for Data Engineering; it was in the overall list from Indeed. The R programming language is oriented towards ana-lytical processing (e.g. used by Data Scientists), whereas the Python language is a scripting and object-oriented language that facilitates the creation of Data Pipelines (e.g. used by Data Engineers). Because the data was collected one year apart and from very different data sources, the timing of the data collection and the different data sources could account for some of the differences in the ranked lists. It is worth noting that the Indeed research ranked list introduced the technical skills of Design Skills, Spark, AWS (Amazon Web Services), Data Modeling, Kafta, Scala, Cloud Computing, Data Pipelines, APIs and AWS Redshift Data Warehousing to the top 20 ranked technical skills list. The Stitch (2016) report that did not have matches to the Indeed (2017) sample data for Linux, Databases, MySQL, Business Intelligence, Oracle, Microsoft SQL Server, Data Analysis and Unix. Although many of these Stitch top 20 technical skills were on the Indeed list, they did not make the top 20 ranked technical skills. Recommendations for Practitioners: Some of the skills needed for Database Technologies are transferable to Data Engineering. Recommendation for Researchers: None Impact on Society: There is not much peer reviewed literature on the subject of Data Engineering, this paper will add new information to the subject area. Future Research: I'm developing a Specialization in Data Engineering for the MS in Data Science degree at our university.
APA, Harvard, Vancouver, ISO, and other styles
6

Nanda, Jyotirmaya, Rob Iera, Stella Clarke, Timothy W. Simpson, and David Klinikowski. "A Web-Based Information Management System for Bus Test Data for the Pennsylvania Transportation Institute." In ASME 2002 International Design Engineering Technical Conferences and Computers and Information in Engineering Conference. ASMEDC, 2002. http://dx.doi.org/10.1115/detc2002/cie-34455.

Full text
Abstract:
Computer-based information management systems have allowed many companies and facilities to greatly improve their data storage and processing capabilities over traditional paper and file methods. The Internet and its associated web-based technologies have further contributed to information processing capabilities. The Federal Transit Administration’s Bus Testing Program, operated by the Pennsylvania Transportation Institute at the Pennsylvania State University requires an upgrade to such a system. Currently, all bus test data is entered directly into a hardcopy report, and data analysis must be performed manually. The objective in this research is to develop an information management system for the bus test data to facilitate access to the data, enable search queries, and perform statistical analyses to examine current trends or predict performance characteristics of future buses. A database has been created in Microsoft Access and linked to a user-friendly graphical user interface developed in Visual Basic for fast and nearly error-free data entry. A web-based infrastructure comprised of HTML, XML, ASP, and customized COM objects is used to display, search, and analyze the bus test data. The resulting information system saves time and money for PTI while enabling easy access to bus test reports.
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!

To the bibliography