sql 312
- Assembly definition into SQL Server (Programmability / Assemblies) Dec 5, 2020
- SQL Server - Iterate records without cursor Dec 1, 2020
- OUTER APPLY Operator Nov 30, 2020
- sum values from two different queries (sum totals of two queries) Nov 26, 2020
- Persist a variable across GO Nov 26, 2020
- SQL Server Row Count for all Tables in a Database Nov 25, 2020
- SQL Server - Sparse column Nov 24, 2020
- order by field value length Nov 23, 2020
- Try..Catch inside Procedure (SP) Nov 11, 2020
- Substring with easy on SQL Server Nov 11, 2020
- Elapsed Time Calculation on SQL Server with dateDiff Nov 11, 2020
- SSMS 2018 v18.7.1 - A certificate chain could not be built to a trusted root authority (0x800B010A) Nov 10, 2020
- Execute dynamic SQL with parameters Nov 10, 2020
- Temporary Tables vs Table Variables in SQL Server Nov 9, 2020
- SQLite compiled to JavaScript Nov 7, 2020
- sql server query date field without hassle Nov 5, 2020
- Remove trailing zeros from decimal in SQL Server Oct 16, 2020
- TIME for a WTF MySQL moment Oct 6, 2020
- DuckDB - An embeddable SQL database like SQLite, supporting Postgres features Sep 20, 2020
- Please stop using this UPSERT anti-pattern Sep 5, 2020
- MySQL count filesize of database Aug 29, 2020
- Using Askgit - A SQL interface to your Git repository Aug 16, 2020
- SQLite 3.33 adds support for UPDATE FROM Aug 16, 2020
- Uncommittable transaction is detected at the end of the batch. The transaction is rolled back Aug 14, 2020
- Merge tables Jul 27, 2020
- Json-Base – Database built as JSON files Jul 3, 2020
- How does SQLite work Jun 28, 2020
- SSMS v18.5 (2018) Jun 26, 2020
- Get ID after Insert Jun 26, 2020
- SQLServer - Working with XML field Jun 22, 2020
- Table to List
Jun 19, 2020 - SQL Server DataReader.GetField return null instead of geography data Jun 15, 2020
- ISNULL with NULLIF to avoid empty string Jun 9, 2020
- Search every table and field in a SQL Server Database Jun 2, 2020
- Beekeeper Studio is a free and open source SQL editor and database manager May 31, 2020
- SSL Security Error for Microsoft SQL Driver May 25, 2020
- Sybase ASE May 9, 2020
- Set up a SQL Server in a docker container Apr 23, 2020
- Running SQL Server on a Raspberry Pi Apr 23, 2020
- Open sourcing the Java language extension for SQL Server Apr 23, 2020
- Database of Databases Apr 16, 2020
- Parsing SQL Apr 15, 2020
- Sending mail messages from SQL Server Apr 6, 2020
- Convert a SQL SELECT into an INSERT Script Apr 6, 2020
- Replication in NoSQL document databases Mar 31, 2020
- GraphQL client without queries Mar 31, 2020
- Golang SQLite Simple Example Mar 11, 2020
- Chartio SQL visual Mar 11, 2020
- mySQL - Find duplicates with having Feb 5, 2020
- mySQL - delete uncommitted rows Jan 17, 2020
- Mongo Aggregates and How to Explain Aggregate Queries Jan 15, 2020
- MySQL - Error Code- 1118 Row size too large Jan 8, 2020
- SQL Server on Linux on Docker quick and easy Dec 23, 2019
- How Microsoft brought SQL Server to Linux Dec 23, 2019
- Antijoin in MySQL 8 Dec 19, 2019
- Microsoft SQL Server 2019 on Linux Dec 13, 2019
- mySQL - drop all the tables from a database Dec 12, 2019
- Why Most Programmers Get Pagination Wrong Dec 8, 2019
- mysql loop through records procedure Dec 6, 2019
- mySQL - Search column name in all tables Dec 3, 2019
- How to monitor MySQL / MariaDB query progress Nov 27, 2019
- MongoDB Hello world! Oct 9, 2019
- Script to Find SQL Server Windows Login Expiration Date Oct 7, 2019
- LiteDB - Embedded NoSQL database for .NET Oct 7, 2019
- MySQL v8.0.17 minimal Sep 2, 2019
- Import CSV Files into SQL Server Database with SSIS Script Task Sep 2, 2019
- Dqlite Sep 1, 2019
- PostgreSQL outputs JSON Aug 22, 2019
- Google-style “Did you mean?” searches Aug 5, 2019
- Bulk Insert Data into SQL Server to SQL Server 2017+AZURE Aug 5, 2019
- Translate English to SQL Jun 5, 2019
- datediff with in operator May 23, 2019
- Joins In Steps May 11, 2019
- Generating Fractals with Postgres- Escape-Time Fractals Apr 22, 2019
- with or without -) Apr 16, 2019
- sqlmap Apr 16, 2019
- Northwind and pubs sample databases for Microsoft SQL Server Apr 16, 2019
- SSMS - Import excel file gets some values as null Apr 3, 2019
- update records via join table Mar 2, 2019
- How To Use Azure Blobs Mar 2, 2019
- BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN Mar 1, 2019
- group by range Feb 7, 2019
- AlaSQL Jan 14, 2019
- alash3al.sqler Jan 9, 2019
- Create missing index on a table on SSMS 2008 and above Dec 16, 2018
- SQLite EntityFramework 6 Tutorial Nov 29, 2018
- Connect to SQL Server running on VirtualBox Nov 16, 2018
- Comparison between SQL, NoSQL, and NewSQL Databases Oct 17, 2018
- Oracle DSN and tnsnames Oct 9, 2018
- Firebase2graphql- Migrate from Firebase to Realtime GraphQL on Postgres Oct 8, 2018
- MariaDB acquires Clusterix Sep 20, 2018
- SQL Server Script to Show How Much Database Has Changed Since Last Full Backup Sep 14, 2018
- LiteTree- SQLite with Branches Aug 29, 2018
- JSON Changelog with SQLite Aug 28, 2018
- PDO fetch statements Jun 3, 2018
- NetSPI.SQL Injection Wiki May 3, 2018
- New JSON functions in MySQL v5.7.22 Apr 27, 2018
- Implementing a Database Factory Pattern Apr 26, 2018
- Import data from Excel and CSV files into MySQL using PHP Apr 20, 2018
- New Regular Expression Functions in MySQL v8.0 Apr 9, 2018
- MySQL max pool size was reached Apr 8, 2018
- xampp - set mysql root password Apr 6, 2018
- MySQL v5.7.21x86 bone edition Apr 6, 2018
- Web Application Penetration Testing Cheat Sheet Apr 2, 2018
- Event Analytics- How to Define User Sessions With SQL Mar 28, 2018
- How To Corrupt An SQLite Database File Mar 14, 2018
- An Easier Way of Transposing Query Result in SQL Server Mar 14, 2018
- How Does Table Qualifier Work in INSERT Statement? Mar 3, 2018
- Top 10 MySQL v8.0 features Feb 17, 2018
- Protecting highly confidential sales data with Azure SQL Database Feb 17, 2018
- Export SQL Server Data to Multiple Excel Worksheets using SQL Server Integration Services Feb 17, 2018
- A query language for JSON Feb 17, 2018
- Hashing With SHA-256 in Oracle 11g R2 Feb 14, 2018
- Microsoft ODBC Driver 17 for SQL Server Feb 13, 2018
- How to Schedule a Job in SQL Server? Feb 13, 2018
- Advanced SQL window function quiz Feb 9, 2018
- Use and Generate PUT Stored Procedures Feb 1, 2018
- SQL Server Function to Generate Random 8 Character Password Jan 31, 2018
- How to Recover SQL Server Database Without Backup Jan 26, 2018
- MySQL 8.0.4 - New Default Authentication Plugin - caching_sha2_password Jan 25, 2018
- Vulnerability in phpMyAdmin Requires Immediate Patch (PMASA-2017-9) Jan 8, 2018
- Building A Generic SQLite Repository Jan 8, 2018
- Apache Drill Jan 7, 2018
- SQL Injection Explained by 7Safe Dec 1, 2017
- To JavaScript, or Not to JavaScript, That Is the Question Nov 18, 2017
- abc import - Import Your MongoDB, SQL, JSON, CSV Data Into Elasticsearch Nov 18, 2017
- Creating a Linked Server to an Azure SQL Database Nov 16, 2017
- Validate Email Address in SQL Server Nov 13, 2017
- So What-s Microsoft SQL Operations Studio? Nov 9, 2017
- Faster bulk loading in Postgres with copy Nov 9, 2017
- Writing Conditional Logic in PL/SQL Nov 8, 2017
- Work on SQLite4 has concluded, lest there be any doubt Nov 8, 2017
- Synchronize Table Data Using a Merge Join in SSIS Nov 8, 2017
- Simple Database Dump/Restore with Postgres on Heroku Nov 6, 2017
- MySQL vs MariaDB- Reality Check Nov 3, 2017
- Microsoft says 40 percent of all VMs in Azure now are running Linux Nov 3, 2017
- What If OpenDocument Used SQLite? Nov 2, 2017
- Different Ways to Connect to SQL Server Using sqlcmd Oct 31, 2017
- Backup and Restore a SQL Database with the Azure CLI Oct 31, 2017
- Bulk Copy Data from Oracle to SQL Server via PowerShell Oct 26, 2017
- Why PostgreSQL is better than MySQL Oct 16, 2017
- Efficient pagination of a SQL table with 100M records Oct 16, 2017
- SSIS Package to Centrally Monitor All SQL Servers Oct 13, 2017
- Google backs up Firebase with a second realtime NoSQL silo Oct 4, 2017
- How to List All Tables and Describe Tables in Oracle, MySQL, DB2 and PostgreSQL Oct 3, 2017
- Would you consider running SQL Server on Linux? Sep 27, 2017
- Why SQL is beating NoSQL, and what this means for the future of data Sep 26, 2017
- PHP application in SAP Cloud Platform Sep 26, 2017
- Blind SQL Injection Tool Sep 23, 2017
- LinkedIn Develops MySQL Query Analyzer Tool Sep 22, 2017
- SQLite is cool again on Android with kotlin.anko Sep 21, 2017
- Franchise - An Open-Source SQL Notebook Sep 21, 2017
- Oracle pagination Sep 19, 2017
- MySQL founder tries a new software licensing model Sep 17, 2017
- query Oracle date field Sep 14, 2017
- Permissions to Schedule a SSIS Package from SQL Server Agent and the File System Sep 13, 2017
- How to Create Linked Server to SQL Azure Database Sep 13, 2017
- How to use dapper (simple object mapper) for MySQL in C# Sep 12, 2017
- Why I’m dumping Firebase for Web? Aug 9, 2017
- SQL Server function to check dynamic SQL syntax Aug 2, 2017
- Postage - A fast replacement for PGAdmin Jul 30, 2017
- MSSQL - We would like to access tables from a database to another database Jul 30, 2017
- Working With Hierarchies in a NoSQL Database Jul 29, 2017
- Copy databases from 5 different SQL Servers in 100 seconds with the DBATools PowerShell Module Jul 29, 2017
- Convert a MSSQL Table into a C# Class Jul 29, 2017
- Count Week Days Between Two Dates Jul 24, 2017
- Convert to Datetime MM/dd/yyyy HH-mm-ss Jul 20, 2017
- Startup Engineers and Our Mistakes with MongoDB Jul 19, 2017
- How to See Scripts Executing in sp_executesql? Jul 18, 2017
- Simple Image Import and Export Using T-SQL for SQL Server Jul 17, 2017
- Differences in PREPARE Statement Error Handling With Binary and Text Protocol Jul 14, 2017
- Dynamic SQL Jul 13, 2017
- MySQL utf8 vs utf8mb4 Jul 12, 2017
- Why Did So Many Startups Choose MongoDB? Jul 7, 2017
- Execute SQL Server Script Files with the sqlcmd Utility Jul 6, 2017
- How to prevent users from accessing SQL Server / Oracle with Login Trigger Jul 5, 2017
- Find All Failed SQL Server Logins Jul 3, 2017
- How to Reset a WordPress Password from phpMyAdmin Jun 27, 2017
- Literate SQL Jun 25, 2017
- Proper convert UTC to Browser time Jun 23, 2017
- Protecting Data with Digital Signatures by Example using MySQL Jun 22, 2017
- Comparing In-Memory Databases- Redis vs. MongoDB Jun 19, 2017
- Case Statement in WHERE Clause? Jun 19, 2017
- UTF8 Encoding ... you, uh, you, uh Jun 11, 2017
- a query had to go Jun 6, 2017
- MSSQL - Finding Weekend Days in Month Jun 5, 2017
- Oh Man, I Accidentally Deleted Production Data From the MySQL Database May 31, 2017
- MySQL for Excel v1.3.7 has been released May 26, 2017
- Import a JSON Data Set into MySQL May 25, 2017
- SAP SQL Injections May 20, 2017
- Calling JavaScript functions from TSQL May 16, 2017
- Microsoft launches Azure Database for MySQL and PostgreSQL May 11, 2017
- LoveField - Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast May 11, 2017
- Getting Started With Blind SQL Injection May 10, 2017
- Database developer MariaDB picks up $27M from the European Investment Bank (EIB) May 8, 2017
- Will SQL just die already? May 6, 2017
- Precompiled Azure Functions Revisited May 5, 2017
- SQL is 43 years old - here’s 8 reasons we still use it today May 3, 2017
- MySQL v8.0- GROUPING function May 3, 2017
- SQL Server Express Benefits Apr 27, 2017
- MySQL for Visual Studio v2.0.5 has been released Apr 27, 2017
- MySQL JSON_PRETTY Apr 19, 2017
- How to Convert MySQL to MySQLi Apr 18, 2017
- Easy way to compare SQL Server table schemas Apr 18, 2017
- Reset root password on Galera Cluster (Percona or MariaDB) Apr 11, 2017
- Dealing with MySQL Error Code 1215- “Cannot add foreign key constraint” Apr 7, 2017
- SQL vs MongoDB Apr 2, 2017
- Redis as a JSON store Mar 22, 2017
- o100+ Free resources for learning Full Stack Web Development Mar 17, 2017
- Cloud Functions for Firebase Mar 10, 2017
- MySQL Connector/NodeJS v1.0.6 M5 has been released Mar 9, 2017
- Searching Blob Documents with the Azure Search Service Mar 7, 2017
- Azure general availability for MySQL in-app Mar 7, 2017
- usql is a universal command-line interface for working with SQL databases Mar 3, 2017
- MySQL vs MySQLi Mar 3, 2017
- JSON with MariaDB v10.2 Mar 1, 2017
- Converting comma separated fields to MySQL JSON – a case study Feb 23, 2017
- Public IP Addresses of Azure Datacenters Feb 16, 2017
- Install SQL Server on Linux Feb 16, 2017
- bulk insert from oracle to mysql database Feb 9, 2017
- DB-Engines Ranking Feb 3, 2017
- MySQL reporting using AutoSQL tool Feb 2, 2017
- MySQL Procedure Analyse Use Feb 2, 2017
- Happy 7th Birthday Microsoft Azure! Feb 2, 2017
- MariaDB ColumnStore Jan 31, 2017
- mymssqldump Jan 19, 2017
- Oracle rownum (sql top) proper use Dec 16, 2016
- Oracle show tables schema Nov 30, 2016
- Oracle query by date field Nov 30, 2016
- Oracle check for duplicates Nov 30, 2016
- Azure for Linux and PHP/Python support Nov 19, 2016
- Search all tables all fields on Oracle dbase Nov 9, 2016
- SQL Server Compact on framework 4 and oledb provider Nov 8, 2016
- SSIS Basics- Setting Up Your Initial Package Oct 29, 2016
- MySQL Connector/Node.JS 1.0.4 Oct 18, 2016
- Replacing JSON UDF Calls With Native Function Calls in MySQL 5.7 Oct 3, 2016
- MySQL 8.0 Labs- [Recursive] Common Table Expressions in MySQL Sep 22, 2016
- MySQL 8.0- JSON Aggregation functions Sep 16, 2016
- Google Sheet - Query Function - missing from Microsoft Office Aug 8, 2016
- why uber engineering switched from postgres to mysql Jul 27, 2016
- Users don’t need to know database scripting languages such as SQL to create new database queries Jul 24, 2016
- Export SQL Server Records into Individual Text Files Jun 20, 2016
- Excel to TSQL Jun 17, 2016
- Apply SQL Server snapshot locally at the Subscriber via Command Line Jun 17, 2016
- Differences of char, nchar, varchar and nvarchar data types Jun 15, 2016
- SSMS 2016 Jun 7, 2016
- PowerShell – Querying SQL Server May 25, 2016
- SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error May 24, 2016
- IP ranges for Azure May 16, 2016
- U-SQL May 12, 2016
- IQueryable and TSQL May 4, 2016
- Google OAuth 2.0 Ajax Login using jQuery & PHP May 4, 2016
- MySQL XDevAPI Protocol Apr 26, 2016
- Edit specific row(s) in Microsoft SQL Server Management Studio Apr 14, 2016
- Virtual Database Applications Apr 1, 2016
- SQL Server Encryption and Symmetric Key Encryption Tutorial Apr 1, 2016
- Altering a Table - Add Identity Column Mar 15, 2016
- Microsoft announces that it will be releasing SQL Server 2016 on Linux Mar 8, 2016
- search and replace Mar 4, 2016
- o[mysql] SQL injection with SLEEP() Mar 3, 2016
- Rebuild FullText Feb 25, 2016
- Phil Factor - parseJSON function Feb 25, 2016
- convert date.month to text Feb 22, 2016
- make a stoplist and exclude a word Feb 18, 2016
- sqlcmd Feb 17, 2016
- Securing web applications avoid injection attacks Feb 12, 2016
- JSON Support for Transmitting Data for SQL Server 2016 Feb 12, 2016
- SQLStudio - Create Snippets Feb 11, 2016
- PowerApps- Building Apps without Code Feb 10, 2016
- o[sqlite] bulk insert 16000 rows in 5seconds Feb 9, 2016
- sql-generate-insert Feb 9, 2016
- o[wordpress] Disable Post Revisions Feb 5, 2016
- Linked server Feb 5, 2016
- ConvertString2Greeklish Feb 5, 2016
- ping sql server instance over ip Feb 4, 2016
- A funny thing happened to set up Mirroring Feb 4, 2016
- see when the last backup was taken on a SQL Server Jan 29, 2016
- CRUD RESTful php service used with AngularJS and MySQL Jan 29, 2016
- identity field + constraints for a table Jan 27, 2016
- Entity Framework Jan 27, 2016
- Search for a string in all tables of SQL Server Database Jan 21, 2016
- temporary table + cursor loop Jan 19, 2016
- SQL Server 2008-14 Addons Jan 18, 2016
- Removing Duplicates from Strings in SQL Server Jan 15, 2016
- SQL Server 2014 - Import and Export Wizard Jan 14, 2016
- Open DBDiff + Simego.SQL Admin Studio Jan 14, 2016
- Full text search on SQL excludes single digits Jan 12, 2016
- DAX functions in SQL Server 2016 Jan 4, 2016
- CLR Assemblies in SQL Server Jan 4, 2016
- SQL Server 2016 - Opening JSON with OPENJSON() Jan 3, 2016
- SQL 2016 Always Encrypted Dec 23, 2015
- Compare Tables in SQL Server using checksum Dec 23, 2015
- Correlated Update Dec 21, 2015
- generate scripts + alternative Dec 11, 2015
- sql transaction Dec 9, 2015
- compare tables Dec 9, 2015
- SQL Server versions Dec 2, 2015
- Joins Experts Nov 24, 2015
- o[php/js/mysql] mass combo add w/ new functionality Nov 8, 2015
- count rows for each table Oct 27, 2015
- Search for a string in all tables of SQL Server Database Oct 20, 2015
- SQL Server 2012 Express Over the Network Oct 16, 2015
- o[asp.net] Repeater Example w/ ItemDatabound Oct 16, 2015
- o[vsexpress+mysql] asp.net using entity framework with mysql on visual studio express (old) Oct 15, 2015
- why LINQ beats SQL Oct 12, 2015
- Using LINQ to SQL (ORM) Oct 12, 2015
- linq anonymous method Oct 12, 2015
- SQLite compiled to javascript Sep 12, 2015
- o[php+mysql] comments system Sep 9, 2015
- Wordpress Changing URL Sep 7, 2015
- o[js+php+mysql] Facebook-like Vertical Timeline Sep 7, 2015
- Protecting MySQL passwords with sha256_password plugin Sep 1, 2015