Loading ...

Category: Database

  • MsSql – For Json auto

    For Json variations Index Syntax Description Example (Simplified) Results (Simplified) 1 FOR JSON PATH Formats the result as JSON with nesting SELECT name, surname FROM users FOR JSON PATH [{ “name”: “John”, “surname”: “Doe” }] 2 FOR JSON PATH, ROOT(‘name’) Adds a root element to JSON output SELECT name FROM users FOR JSON PATH, ROOT(‘users’)…

    Continue reading

  • Text search in mass files – comparison

    grep: Traditional command-line text search utility, widely available. sift: Modern, fast, supports complex searches with an intuitive interface. ack: Optimized for programmers, great for searching through codebases. ag (The Silver Searcher): Focused on speed and efficiency, especially in large codebases. ripgrep (rg): Extremely fast, respects .gitignore, offers powerful regex support. git grep: Tightly integrated with…

    Continue reading

  • MongoDB VS ElasticSearch

    Index Parameter Elasticsearch MongoDB Score for Elasticsearch Score for MongoDB 1 Type Search engine based on Lucene NoSQL document-oriented database 85 95 2 Data Model JSON-like documents BSON (binary JSON) documents 90 98 3 Query Language Query DSL based on JSON Rich query language 85 95 4 Indexing Inverted indexing for full-text search Secondary indexing…

    Continue reading

  • Elastic search alternatives – search big data

    Index Platform Name & Link Description Free/Paid Has API Advantages Disadvantages OS Grade 1 Python Versatile programming language Free No Wide-ranging libraries, flexible Requires programming knowledge Windows, macOS, Linux 95 2 Elasticsearch Distributed, RESTful search engine Both Yes Scalable, fast searching Complexity in setup Windows, macOS, Linux 90 3 Apache Solr Open-source search platform Free…

    Continue reading

  • Useful links AI / ChatGPT / Certifications

    AI Tools ChatGPT install ChatGPT to your PC  הנה כמה תוספים שישפרו את השימוש שלכם באחד הכלים הכי פופולריים בעולם כרגע GitHub AI Collection Artificialintelligence Character.AI  בינה מלאכותית שמאפשרת לכם לנהל שיחה עם מפורסמים מהעולם כולל אנשים מתים היא לומדת את הבן אדם ממידע שנמצא עליו ברשתות ויוצרת צ׳אט שמחקה את הצורה שבה הבן אדם…

    Continue reading

  • How to create a linked server

    Article that actually works: How to create a linked server mssql

    Continue reading

  • ERD – Entity relations diagram

    ERD – Entity relations diagram

    Click to Enlarge Right click to download full size Download Academic courses HERE.

    Continue reading

  • Big Data / NoSql

    Big Data / NoSql

    MongoDB Tutorials Tutorial 1 (guru99) Terms Quick Reference show dbs – show all dababases show collections – show all collections in database. use [db name] – switch to the specific database. db.[collection].find() – find records in the collection. db.[collection].find({email:”[email protected]”}) – find specific value db.[collection].findOne() – find one record in the collection. db.[collection].findOne({email:”[email protected]”},{password:”12345″}) – find specific…

    Continue reading

  • Graph database

    Graph database

    In computing, a graph database is a database that uses graph structures for semantic queries with nodes, edges and properties to represent and store data. A key concept of the system is the graph (or edge or relationship), which directly relates data items in the store. This contrasts with conventional relational databases, where links between…

    Continue reading

  • SQLite – References

    SQLite – References

    Top 5 Sqlite management tools: http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/ http://sqliteadmin.orbmu2k.de/ Youtube Video tutorial: http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/  

    Continue reading

  • How to install PhpMyAdmin on C9.IO

    How to install PhpMyAdmin on C9.IO

    here is a link of how to: https://docs.c9.io/docs/setting-up-phpmyadmin

    Continue reading

  • How to setup PhpMyAdmin at your website

    How to setup PhpMyAdmin at your website

    1. Download PhpMyAdmin. 2. Upload it to your Server/Domain. 3. Browse to www.your-domain.com/phpMyAdmin/Setup 4. Click on “New Server” button: 5. Under “Server hostname” write your host name. 6. Under “User for config auth” (might be under authentication tab) write MySql username. 7. Under “Password for config auth” write MySql password. 8. Under PhpMyAdmin top level…

    Continue reading

  • SSMS / Visual Studio Sql server database project

    SSMS / Visual Studio Sql server database project

    Database good practice Tools to use: SSMS – sql server management studio Visual Studio The following video is the best to describe the process How To Create a Database Deployment Project in 10 minutes In short: Using VisualStudio connect to Database. Right click on the DB and select create new project. At this point there…

    Continue reading

  • The Connection Strings Reference

    The Connection Strings Reference ConnectionStrings.com help developers connect software to data. It’s a straight to the point reference with connection strings, a knowledge base of articles and database connectivity content and a host of Q & A forums where developers help each other in finding solutions. http://www.connectionstrings.com/    

    Continue reading

  • MS SQL Server Editions

     MS SQL Server Editions Also include Express editions http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

    Continue reading

  • Step by step of executing SSIS 2012 package through stored procedure

    Step by step of executing SSIS 2012 package through stored procedure http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx

    Continue reading

  • How to find Object ID by name at SQL Server

    How to find Object ID by name at SQL Server Example of how to find ID of tables at database according to tables name: SELECT * FROM   sys.columns WHERE  object_id = Object_id(’employees’)

    Continue reading

  • Multiplication Table – Stored Procedure

    ALTER PROCEDURE [dbo].[Mulsp] @Size INT AS BEGIN DECLARE @X INT=2 DECLARE @Y INT=1 BEGIN try DROP TABLE [dbo].[multable] END try BEGIN catch END catch CREATE TABLE [dbo].[multable] ( c1 INT ) –create the rows  DECLARE @CN NVARCHAR(max)=” DECLARE @TSql NVARCHAR(max) WHILE @x <= @Size BEGIN SELECT @cn = ‘c’ + Cast(@x AS NVARCHAR) PRINT @cn SET @TSql=‘alter table MulTable add ‘ + @cn + ‘ int’ PRINT @Tsql EXEC sys.Sp_sqlexec @Tsql SET @x=@x + 1 END –at this point build each line query  SET @X=1 DECLARE @EachLineQuery NVARCHAR(max) WHILE @Y <= @Size BEGIN SET @EachLineQuery=‘insert into MulTable values (‘ WHILE @x < @Size BEGIN SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR) + ‘,’ SET @x=@x + 1 END SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR) + ‘)’ EXEC sys.Sp_sqlexec @EachLineQuery PRINT @EachLineQuery SET @EachLineQuery=” SET @y=@y + 1 SET @x=1 END SELECT * FROM   multable END

    Continue reading

  • Can’t browse SDF files in Visual Studio 2013

    In Visual Studio 2013 you could double click a SDF database file within Solution Explorer and it would automatically open the database file and allow you to view the database tables, add tables, edit data etc. In Visual Studio 2013 this native support seems to have ‘fallen off’, double clicking an SDF file simply assumes it…

    Continue reading