Search the site for the term 'SQL Server'

I finish the series dedicated to the ChessPosDB chess match database manager with this article. In this post, I will explain how to install and configure the database server used with the application, which can be Oracle, MySQL, or SQL Server. Whichever database server you choose, you can install it on the same computer as the application or on another more powerful computer that you can access through your local network.

[Read More...]

This post is the fifth in a series of articles about the ChessPosDB application, which allows you to store many chess games in different professional database engines and search for them with a wide variety of options. Here, I will show how to query the database with the filters explained in the previous ones. We will also see the chess match editing options, which allow adding comments and new tags.

[Read More...]

This article is the fourth of a series of articles dedicated to the ChessPosDB application, a chess game database manager with a powerful search engine. Here, I will finish the section about the search filters by showing the chess match filters. Those filters can include several movement or position filters, which we have already seen in previous posts.

[Read More...]

This post is the third of the series of articles about the ChessPosDB database manager application. Here you also have a link to the first article in this series, in case you want to start reading from the beginning. In the present article, I will continue commenting on the rest of the movement and position filters that can be applied to find chess games in the database. As you may recall from the previous article, we can combine these filters in multiple ways to build virtually any query that you can think of.

[Read More...]

In this series of articles, I will comment on a chess game database manager, ChesPosDb. In the first article in this series, I explained how to load chess games in the database using PGN files, which you can download from many Internet sites. In this article and the following ones, I will show the different filter types that you can build to search chess matches in the database.

[Read More...]

In this series of articles, I will present an application to manage a chess match database, ChesPosDb. It is not a program that plays chess; it only stores matches, but it allows queries with a large number of options: searching for games in which a series of moves occur, either one after another or separated by several moves, and even look for partially defined positions, no matter in which place on the board the pieces are located.

[Read More...]

WCF (Windows Communication Foundation) is a framework for creating distributed applications whose components communicate with each other through services, using a wide range of network protocols. In this article I will comment on the fundamentals of creating and configuring one of these services through a data connector for the DBTextFinder application, a program to search for texts in a database that can be extended to connect to any data management system.

[Read More...]

All major database servers allow the creation of executable objects, such as functions or stored procedures, using some type of SQL extension language, such as PLSQL in Oracle or T-SQL in SQL Server, so that we can create applications to access and manipulate data in a more sophisticated way. In this article I will show how we can access the source code of these objects from any program using the catalog views of three of the most popular RDBMS, MySQL, Oracle and SQL Server.

[Read More...]

In this article I will continue with the integration of CLR objects into a SQL Server database by showing how to implement triggers and create user-defined data types. It is a simple way to extend the functionality of our database applications with all the power provided by the CLR of the .NET framework.

[Read More...]

In this article I will show you how you can easily extend the SQL of your SQL Server servers with functions and data types of the .NET Framework CLR (Common Language Runtime). To do this, I will implement a function with scalar return value, another function with table return value, a pair of aggregation functions and a stored procedure.

[Read More...]

The PISA database contains, in addition to the scores of students, a lot of demographic, socioeconomic and cultural data about them, collected through a series of questionnaires, that allow contextualize the academic results and make studies with a great number of variables. Most of these data are categorical, making the correspondence analysis a particularly appropriate tool to work with them. In this article I will show you how to easily perform this analysis using the ca package of the R program.

[Read More...]

When you design a database, you can make a series of errors or omissions that, later, can result on many headaches, or you can shelve the use of some useful resources simply because of ignorance of them. In this article I will give you a few tips that can help you to better design and management of your data and applications that manage them, especially if you are a beginner.

[Read More...]

The catalog views contain all the information concerning the structure of the database: schemas, tables, table fields, data types of the fields, integrity constraints, stored procedures code, etc. The knowing of them is essential to develop tools for data management independent of the structure. In this article we will view an example of one of these tools, DBTextFinder, a simple application that will allow us to search for text in the records of our database and within the code of the views and stored procedures.

[Read More...]

In this post we will look at the data structures and the necessary interfaces to develop connectors for any database to add to the DBTextFinder application, a tool for finding text in registers, stored procedures and views. You can also download sample code, developed with Microsoft Visual Studio 2013 with connectors for SQL Server, Oracle 12c and MySQL.

[Read More...]

Every three years, since 2000, the OECD (Organization for Economic Cooperation and Development) performs a series of tests in a number of countries at national level to 15-years-old students, in order to assess the degree of knowledge in three main groups of areas: science, reading and math. This is the PISA program, whose last edition took place in 2015.

[Read More...]

In previous articles I have talked about the POD project, a database that centralizes access to other databases so that they can be consulted through a common interface. In this article we will see the tool that is used for data filtering and query on any of the databases integrated into POD.

[Read More...]

PISA (Program for International Student Assessment) is a program of the OECD (Organization for Economic Cooperation and Development) for the evaluation of education policies. It consists of a series of tests and surveys conducted to 15 years old students, schools and parents at national level in the countries participating in the program (in 2012 there were 65 participating countries, and in 2015 there are more than 70). These tests seek to assess the level of knowledge in three main areas: Reading, science and math.

In this article I make a brief introduction to SQL Server database created from the original data published by the OECD.

[Read More...]

In this page you can download the central PISA database, which contains all the common data for all countries, as questions, response values and territorial divisions.

[Read More...]

In this page you can find the instructions and the links to download and install each PISA national database with the responses of students, schools and parent questionaires of the years from 2000 to 2012.

[Read More...]

From this page you can download an installable copy of the POD Configuration database. You can find also instructions to install and setup it on the server, and to download a free version of SQL Server.

[Read More...]