Some features to automatically record blocks in SQL Server
<<For a moment, nothing happened. Then, after a second or so, nothing continued to happen.>> (Douglas Adams)
"Blocked" queries are most annoying in SQL Server; stalling, delaying or even cancelling transactions.
To thoroughly investigate and analyze these conflicts it is necessary to automatically record these issues.
That's what this stuff is about ...
2 smart Stored Procedures to handle "Missing Indexes" in SQL Server
<<Why Did It Have to Be Snakes?>> (Indiana Jones)
This "Ix Adder" is deadly venomous for "Expensive Queries"!
It taps from SQL Server's "Missing Index" proposals and cleans them up sufficiently before installing them automatically.
IXA balances the Cost/Benefit of an Index to significantly improve READ performance while not degrading WRITE performance.
But take care: used in a wrong way this viper could also bite your very own butt!
"Ix Adder"'s little pal is "Ix Strictor" which...
Model driven code generation can improve coding standards, speed, quality of development and reduce your costs. From my experience generating code from XML using XSLT is one of the best and fastest solutions.
This is just the base of the framework presenting the idea, any code template can be implemented upon request.
Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java
The main target is to generate DTO/BDO/POJO objects based on the database definitions in...
SAADA transforms a set of heterogeneous astronomical data FITS files in a powerfull database deployed on the Web and including VO features. The database is located on your host and keeps under your full control. This job doesn't require to write cod
Deploy in 115+ regions with the modern database for every enterprise.
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
PL/SQL packages to perform Oracle 11g tasks within a very few number of lines : dump/load LOBs, compute CRC, get Mime Type from a BLOB, send XMPP messages, list directory contents as a table, interact with Twitter,deal with QrCodes, ...
Biomedical Information Management System (BIMS) is a modular multilayer object - oriented software architecture, which provides a flexible computational solution to capture and manage a heterogeneous biomedical data: textual and visual information.
PIP on GT.M is a mature and proven complete FOSS stack for developing transaction processing database applications with superb scalability, transaction throughput & unique functionality for extreme levels of business continuity.
This is a generic security implementation of Users/Roles/Functionality/Permissions through a database back-end, stored procedures and client maintenance tools.
Temporal database extensions for Oracle and PostgreSQL. Complete toolkit to model, store and manipulate timespans, periods, or anchored intervals (different names for similar concepts).
Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.
Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
Four Oracle PL/SQL software packages designed to process and classify discontinued Vessel Monitoring Systems (VMS) data from longline fisheries. Main output: Determination of fishing operations' geographic boundaries and duration by vessel trip.
Send XMPP (Gtalk/Google Talk also supported) messages (thanks to Jabber) within a single line of PL/SQL code, get buddies list and status in relational tables (or xml) on Oracle 11g.
Orate is a source-level tracing facility for Oracle PL/SQL. Programmers insert calls to Orate in the code and Orate captures and writes run time information to a table. These data are suitable for debugging, testing and profiling the application.
The Simplified Heuristic Export/import Management Program (SHEMP) provides a simple, table-driven framework that implements data exports, data imports and reporting for Oracle databases. SHEMP exports and imports in multiple file types, including Excel.
A CMS designed for the Semantic Web, with WYSIWYG page editing, RDF summaries of profiles and news, and countless other quality features you expect to find in a CMS.
JReplica is a java distributed database replication system developed during a European Research Project in the department of Informatics of University "La Sapienza" of Roma under the supervision of Prof.ssa Catarci, Prof. Santucci and Ing. Curci.