Forced optimization of PostgreSQL queries

 3r-33199. 3r3-31. What to do when there is a closed source application that does not access the database in the most optimal way? How to pull requests without changing the application, and possibly the database itself? 3r3186.  3r-33199. 3r3186.  3r-33199. If you haven't asked such questions, you are a very successful and strict DBA :)
 3r-33199. Well, if you ask, let me share my suffering and experience. 3r3186.  3r-33199.
3r3186.  3r-33199. 3r3186.  3r-33199.

Need to store more data, or setting a problem

3r3186.  3r-33199. 3r3186.  3r-33199. This section can be safely browsed if the history ...[/h]
+ 0 -

Databases and Kubernetes (review and video report)

+ 0 -

Between Security and Paranoia: Trends in Large Corporations

 
3r3-31. Monitoring the lives of large corporations drives me into a depression. This is a wild paranoia and at the same time terrible, gaping security holes. However, perhaps these things are just connected - because the paranoid is focused on certain things, and can easily overlook the obvious. He can go out into the street, frantically rustling with foil, which he has wrapped from head to foot, and be hit by a bus.
 
 
Between Security and Paranoia: Trends in Large Corporations  
 
I’ve seen a company where they closed the USB data storage profile for VDI machines, but they didn’t close the USB Hub profile, that is, you could plug in the USB Hub and then a USB ...
+ 0 -

How to run SQL Profiler Trace at night, at a specific time?

 3r3182. 3r3-31. How to start the SQL profiler trace when the problem needs to be caught from 3:00 to 3:30 in the morning? This can be done using server-side tracing, but this is extremely inconvenient. It is not difficult, but uncomfortable, and always lazy. Finally, I decided to automate this once and for all. Like this:
 3r3182.
 3r3182. How to run SQL Profiler Trace at night, at a specific time?  3r3182.
 3r3182. Jenkins here, by the way, is completely optional and serves only as an interface to invoke the script with the necessary parameters:
 3r3182.
 3r3182.  3r3182.
 3r3182...
+ 0 -

Consistency and ACID guarantees in distributed storage systems

Consistency and ACID guarantees in distributed storage systemsDistributed systems are used when there is a need for horizontal scaling to provide increased performance indicators that a vertically scaled system cannot provide for adequate money.
 
 
Like the transition from a single-threaded paradigm to a multi-threaded one, migration to a distributed system requires a kind of immersion and an understanding of how it works inside, what you need to pay attention to.
 
 
One of the problems that confronts a person who wants to migrate a project to a distributed system or start a project on it is which product to choose.
 
 
We, as a company that has “eaten ...
+ 0 -

Search for a damaged object by the number of the damaged page in MS SQL Server 2005

Search for a damaged object by the number of the damaged page in MS SQL Server 2005 3r3r1616. 3r3-31. The other day, one of the MS SQL Server databases went to Suspect, there was an error message in the log: 3r3151.  3r3r1616. 3r33939. Msg 710? Level 2? State ? Line 14
 3r3r1616. Database ID ? page (1: 386499), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can be read uncommitted data on a data page. Run DBCC CHECKTABLE. 3r33939. 3r3151.  3r3r1616. The base was transferred to Emergency and attempted to perform DBCC CHECKDB, but execution stopped immediately: 3r3151.  3r3r1616. 3r33939. Msg 892? Level 1? State ? Line 13
 3r3r1616. Check ...
+ 0 -

Problems of access to personal data on behalf of all participants in the process

 3r33320. 3r3-31. Greetings dear habrovchane. 3r3308.  3r33320. 3r3308.  3r33320.
Lyrical digression [/b]
As a user of one of the “highly developed” resources of the Runet, I discovered a fairly common picture in the admin area of ​​my profile: spam was sent on my behalf. 3r3308.  3r33320. For me, this became some kind of signal, because during that time (an active user of Internet resources from 1999) while I used access methods to my resources in the form of a login and password, I did not have a single (at least registered) case of hacking or leakage of such data. For each resource I use a unique ...
+ 0 -

How to make a time machine for a

How to make a time machine for aradio.Radio Spectrum Archive will give you listen to the old program as if live 3r-35. 3r376.  3r376. 3r311. The spectrum of recording on AM frequencies made on a VHS film in 1986. You can clearly distinguish the individual stations in the form of peaks scattered over the digitized record.  3r376. 3r376. Thomas Witherspoon makes a kind of time machine. With it, you can select a date and listen to the radio program as if you have a radio capable of receiving programs from the past. Of course, popular shows have access to their previous episodes, but with the help of Witherspoon’s time machine, it ...
+ 0 -

Proactive optimization of Oracle

Proactive optimization of Oracledatabase performance. 3r3-1055. 3r3-31. If you work with combat servers, then you have a good idea of ​​what performance incidents mean. You need to drop everything and quickly solve the problem. RNKO "Payment Center" LLC works with many agents, and for them it is very important that such problems be as small as possible. Alexander Makarov at HighLoad ++ Siberia told what was done to significantly reduce the number of performance incidents. Proactive optimization came to the rescue. And why and how it is produced on the combat server, read below. 3r31042.  3r3-1055. 3r31042.  3r3-1055. Alexander Makarov (3r3133...
+ 0 -

MongoDB is changing its open source license

MongoDB is changing its open source license
 3r350.
MongoDB is somewhat offended by the fact that some cloud providers, especially in Asia, use their open code and offer the commercial version of their database in the cloud to their users, not playing according to the rules of open source software. To combat this, MongoDB today announced the release of a new software license - 3r310. Server Side Public License
(SSPL), which will be used in all new releases of their MongoDB Community Server, as well as in all patches to previous versions.
 3r350.
Earlier, MongoDB used 3r3188. GNU AGPL v3
licensed, they have now sent the SSPL for approval at the Open ...
+ 0 -