Library
150 results
SQL ServerBeginnerTurn rows into columns with the T-SQL PIVOT operator, handle NULLs and unknown column lists, and know when conditional aggregation is the better choice.
#t-sql
Compare gzip, bzip2, Snappy, LZ4, Zstandard and LZO in Hadoop, understand why splittability matters, and choose a codec for MapReduce, Parquet and ORC.
#hdfs#open-source
SQL ServerBeginnerDelete rows safely in SQL Server: choose between DELETE, TRUNCATE and DROP, archive rows with OUTPUT, and batch large deletes to limit locking and log growth.
#sql-server-2014
SQL ServerBeginnerCreate a SQL Server credential with T-SQL or Management Studio and use it for Agent proxies and backups to Azure Blob Storage or S3, then change or remove it safely.
PostgreSQLBeginnerUnderstand PostgreSQL table, row and advisory locks, see which session is blocking which, handle deadlocks and run schema changes without stalling the application.
CouchbaseBeginnerInstall Couchbase Server on Linux, Windows, macOS or Docker, pick the right edition, initialise the cluster, and verify it by creating a bucket and running a query.
#data-modeling
SQL ServerBeginnerSummarise data with COUNT, SUM, AVG, MIN and MAX, group and filter it with GROUP BY and HAVING, and add running totals with window aggregates.
Apache HadoopBeginnerIn this article we will learn how to install Cloudera Distributed for Hadoop (CDH) Virtual Machine .
MongoDBBeginnerWhat the mongod server process does, how it differs from mongos and mongosh, the options and config file that control it, and how to start and stop it safely.
#open-source
SQL ServerIntermediateSQL Server R Services is now Machine Learning Services. See what changed, how to enable it, how to run R or Python against a table, and when to avoid it.
Apache HadoopBeginnerLoad files, database tables and event streams into HDFS with the HDFS shell, WebHDFS, DistCp, Spark JDBC and Kafka, now that Sqoop is retired and Flume is dormant.
#big-data#hdfs
