Developers Club geek daily blog

Free tools for developers of databases

2 years, 4 months ago
After reading of article about useful and free plug-ins for SSMS — TOP (10) free plug-ins for SSMS, I decided to share the list of free tools which can be very useful to developers of databases, and not only. Some tools, paid, however contain rather full-function free editions which with the head are enough for small projects.

Read more »


TOP (10) free plug-ins for SSMS

2 years, 4 months ago
Before beginning to work with SQL Server I sense that and did not see databases in the person … I remember that set me SQL Server Management Studio 2005 and gave a task actively "to twist pedals".

After few weeks, as if so to speak, my performance on writing of requests was obviously around a plinth …

More experienced colleague bewildered looked at me and advised to deliver couple of plug-ins for SSMS

After that to work it became explicit more cheerfully.

In this post I want to share mine a top the list of free plug-ins for SSMS which I most often used.

Read more »


Development of the parser, kodogenerator and the SQL editor by means of EMFText

2 years, 4 months ago


It is the 6th article of a cycle on the development managed by models. In last article you gained general idea about development of domain-specific languages by means of EMFText. Time to pass from toy language to more serious came. There will be many drawings, a code and the text. If you are going to use EMFText or the similar tool, then this article has to save to you a lot of time. Perhaps, you learn something new about EMF (delegates of conversions).

Like the brave hobbit we will begin the way with BNF grammar of SQL, we will reach a terrible dragon (metamodel) and we will return back to grammar, but already another …

Read more »


Dynamic T-SQL and as it can be useful

2 years, 4 months ago
In our projects we should solve different problems. For a solution of some of them we use dynamic T-Sql (further in the text of dynamic sql).

For what dynamic sql is necessary? Everyone solves for himself. In one of projects with the help of dynamic sql we solved problems of creation of dynamic reports, in others — migration of data. Also dynamic sql is irreplaceable in cases when it is required to create/change/obtain data or objects, but values/names come as parameters. Yes, it can seem absurdity, but there are also such tasks.


Read more »


Design in PostgreSQL of the dokumento-oriented API: Complex requests (Part 4)

2 years, 4 months ago

Read more »


Design in PostgreSQL of the dokumento-oriented API: Full-text search and saving of many documents (Part 2)

2 years, 4 months ago
In the first part of this series of articles, I created good function of saving, as well as other function allowing to create the changeable dokumento-oriented tables on the fly. They work regularly and do that it is necessary, but we can make still a lot of things. Especially: I want the full-text search indexed on the fly and saving of many documents in transaction.

Let's make it.

Read more »


Design in PostgreSQL dokumento-oriented API (Part 1)

2 years, 4 months ago
This article is transfer, original article is here, the author of Rob Conery.

Postgres as many know, supports JSON as data storage type, and with an output 9.4, Postgres supports storage of JSON in the form of jsonb now — a binary format.

These are fine news to those who want to step further simple "storages of JSON as the text". jsonb supports indexing with use of a GIN index now, and also the special operator of requests who allows to get advantages of a GIN index has.

Read more »


We use TSQL for game in "Sudoka"

2 years, 4 months ago
After by means of TSQL it was successful "Head" (article) is solved I decided to try to solve on it "Sudoka" (thanks for idea of shavluk).

The solution to a pike perch turned out surprisingly rather simple.

The basic scheme has the following appearance:

Read more »


Data Modelling and Databases for the first-year student

2 years, 4 months ago
As to the first-year student of University Innopolis often ask me a question, than we are engaged here. Especially for a habr I wrote the narration how we "sawed" the project on DMD.



Attention! The author does not guarantee that his jokes will be clear and ridiculous.

Read more »


SQL Server 2016 CTP3.1 — that new to the developer?

2 years, 4 months ago
Until recently in my memory the announcement of SQL Server 2016 which was personally presented by Satya Nadella was postponed. And suddenly, suddenly, steel one behind one to leave fresh Community Technology Preview (at the moment the freshest version – CTP3.1). In process of acquaintance to the new version, there was a wish to share impressions more and more …

Further overview of new syntax counters of new SQL Server 2016.

#1 – DROP IF EXISTS


CREATE TABLE dbo.tbl (
    a INT, b INT,
    CONSTRAINT ck CHECK (a > 1),
    INDEX ix CLUSTERED (a)
)

If earlier before removal of object it was necessary to do check:

IF OBJECT_ID(N'dbo.tbl', 'U') IS NOT NULL
    DROP TABLE dbo.tbl

That more compact syntax appeared now:

DROP TABLE IF EXISTS dbo.tbl

Read more »