SQL

LINQ to DB

https://linq2db.github.io LINQ to DB is the fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database

Microsoft/sqlopsstudio

SQL Operations Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. https://github.com/Microsoft/sqlopsstudio

Announcing Microsoft Edge for iOS and Android, Microsoft Launcher

https://blogs.windows.com/windowsexperience/2017/10/05/announcing-microsoft-edge-for-ios-and-android-microsoft-launcher/#7QloAAXdbbz6QBft.97

FaunaDb

https://fauna.com Adaptive operational database from the team that scaled Twitter

mongodbmanager

MongoDB GUI tool with intelligent Shell for you. https://www.mongodbmanager.com

Robomongo

Native and cross-platform MongoDB manager  https://robomongo.org

Equivalent of Oracle’s RowID in MySQL

SELECT @rowid:=@rowid+1 as rowid FROM table1, (SELECT @rowid:=0) as init ORDER BY sorter_field

Jet Profiler for MySQL

Real-time query performance and diagnostics tool for the MySQL database server. http://www.jetprofiler.com

sp_describe_first_result_set

interessante s,p disponibile dalla versione Sql server 2012, che restituisce i metadati per il primo set di risultati daell'istruzione in ingresso sql come parametro in input declare @tsql nvarchar(max) set @tsql = 'select * from table' exec sp_describe_first_result_set @tsql

[MYSQL] ricercare il nome di una colonna in tutte le tabelle

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('columname') AND TABLE_SCHEMA='dbname';

Full SQL Archive

«December»
SunMonTueWedThuFriSat
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456