This post is with reports and video on MS SQL Server

In June we conducted a MIT on Microsoft SQL Server - speakers from Yandex.Money, Kaspersky Lab, AwaraIT and SpbDev shared their experience with colleagues. And now upload the video to the public.
 
Under each video - timecodes of key places, but we advise you to watch, listen and listen whole.
 
Data-driven subscriptions in SSRS
 

for activities , learn SQL and subscribe to our habablog.
Only registered users can participate in the survey. Enter , you are welcome.
World Championship in DBMS. What are the best?
MongoDB
SQLite
Firebird
MS ...
+ 0 -

Development of multi-tenant applications on the SAP Cloud Platform in the Neo environment, Part 2: authorization and authentication

Development of multi-tenant applications on the SAP Cloud Platform in the Neo environment, Part 2: authorization and authenticationIn the second article from the cycle on developing applications on the SAP Cloud Platform in the Neo environment, we will touch on one of the most important aspects - authorization management and user authentication.
 
 
In this article, we show how to establish a connection between the SAP Cloud Platform and the identity provider (IDP) of an imaginary client, ABC PetroCorp, and add users to the IDP. Next, we'll look at how to assign roles to users from the client company in a specific application (from the IDP), and how to configure the SAML attributes to transfer them from the IDP to the application ...
+ 0 -

Functions for documenting PostgreSQL databases. Part Three

This is the third part of the article that describes user-defined functions for working with system directories: pg_class, pg_attribute, pg_constraints, etc.
 
First and the second is parts of the article were published earlier.
 
 
Functions for documenting PostgreSQL databases. Part Three
 
In this part of the article, functions that return are discussed. characteristics of sequences, inherited tables , as well as special characteristics of the attributes of tables .
 
Appendix .
 

Structure of the function returning a list of sequence characteristics of the table


 
...[/h]
+ 0 -

Lords of servers and networks - with the holiday

Lords of servers and networks - with the holiday
 
 
Today is not just Friday. Today is the last Friday of July - which means Day of the System Administrator! On this festive Friday, sysadmins do not bathe in fountains, do not fight in server rooms, do not drive with twisted pair at the ready for marketers. These toilers of servers and scripts all the time on the post, protect the peace of users and the nerves of the bosses - that one clicked with the mouse on the sites and in 1C, and the others did not have to calculate the losses from idle time. Let's say sincere "thanks" to the sysadmins for a smooth smooth work and raise their glasses of tea for ...
+ 0 -

Accelerate the bootstrap of large databases using Kubernetes

Accelerate the bootstrap of large databases using KubernetesWith this article, we open a series of publications with practical instructions on how to make life easier for yourself (exploitation) and developers in different situations that happen literally every day. All of them are collected from real experience of solving problems from clients and have improved over time, but still do not pretend to be ideal - consider them more like ideas and preparations.
 
 
I'll start with a "trick" for preparing large database dumps like MySQL and PostgreSQL for their rapid deployment for various needs - first and foremost, on development sites. The context of the ...
+ 0 -

Metadata S3 in PostgreSQL. Lecture of Yandex

Metadata S3 in PostgreSQL. Lecture of YandexThis is the second lecture from Y. Subbotnik on databases - first we published a couple of weeks ago.
 
 
The general database management team leader Dmitry Sarafannikov told about the evolution of the data warehouse in Yandex: how we decided to make the S3-compatible interface, why they chose PostgreSQL, what rakes came and how they managed it.
 
 

 
- Hello! My name is Dima, in Yandex I'm engaged ...
+ 0 -

The history of active sessions in PostgreSQL is a new extension of pgsentinel

Company pgsentinel has released the same extension pgsentinel ( repository github ), adding in PostgreSQL representation pg_active_session_history - the history of active sessions (similar to the v $ active_session_history).
 
 
In fact, it's just an every second snapshot from pg_stat_activity, but there are important moments:
 
 
 
All the accumulated information is stored only in RAM, and the amount of memory consumed is regulated by the number of last stored records.
 
The queryid field is added - the same queryid from the pg_stat_statements extension (a preliminary installation is ...
+ 0 -

Small tricks with Elasticsearch

Small tricks with ElasticsearchA small note, more for yourself, about small tricks to restore data in Elasticsearch. Unfortunately in the official documentation about these opportunities are silent.
 
official documentation .
 
 
In general, nothing complicated. In the simplest form, create a ball on another server, mount it to all nodes of the elastic by any convenient way (nfs, smbfs, whatever). Next, we use cron, your application or anything to send requests for the periodic creation of snapshots.
 
 
The first snapshot will be long, the subsequent snapshots will only contain delta between the index states. Note ...
+ 0 -

Functions for documenting PostgreSQL databases. Part One

Over the course of working with PostgreSQL, more than one hundred functions for working with system directories have accumulated: pg_class, pg_attribute, pg_constraints, etc.
 
 
Functions for documenting PostgreSQL databases. Part One
 
What to do with them? They are used relatively rarely. To include in any project? Krasnoyarsk customer for such "nonsense" will not pay. And yet, and suddenly they are useful to someone else besides the author. And I decided to put them out as read books in a public closet for those who wished.
 
Appendix .
 
 

What extended characteristics are we talking about?


 
In order to get an idea of ​​what is ...[/h]
+ 0 -

Functions for documenting PostgreSQL databases. Part Two

This is the second part of the article that describes user-defined functions for working with system directories: pg_class, pg_attribute, pg_constraints, etc.
 
Functions for documenting PostgreSQL databases. Part Two  
Texts of functions and their descriptions are given in the hope that they are useful to someone other than the author. In this article, some of these functions are laid out, like books read in the public cupboard for those who wish.
 
Appendix .
 
 

admtf_Table_Constraintes list of database table constraints and their characteristics


 
The source code can be viewed and downloaded here , and ...[/h]
+ 0 -