anti patterns codin'

Amazon Athena tip: access denied or insufficient permissions to access Athena

Reading data from Athena via the command line - Comparing the options (AWS CLI, Python Boto, Java, AWS SDK)

Extracting JSON and nested JSON from an Athena column

Amazon Athena - ANSI SQL - Use inner or nested SELECT statements as alternative to temp tables or variables

Amazon Athena - ANSI SQL - Providing default value if NULL

Amazon Athena - ANSI SQL - use LIMIT to only select first few rows

Amazon Athena - ANSI SQL - Desktop Database Clients

Database performance: Hint to SQL Server to recompile a query

SQL to select from a stored procedure rowset into a temporary table

SQL convert datetime to string

DeploySQL - Python scripts to automatically upgrade SQL Server databases

SQL Server - rough notes on preparing tables for replication

SQL Server - fix up user login after restoring a database

SQL Server - constraint on values in a field, using search expression

Importing data from Excel to SQL Server

Exporting data from SQL Server to Excel

SQL Server Management Studio - Intellisense

SQL SERVER 2005 - to view info about database - location size etc.

SQL Server 2000 - select statement in stored procedure can break OUTPUT params

Viewing SQL Server Log