Creating DataFrames from CSV in Apache Spark

 from pyspark.sql import SparkSession spark = SparkSession.builder.appName("CSV Example").getOrCreate() sc = spark.sparkContext Sp...

  • Optimizing SQL Server Performance
    Optimizing SQL Server CPU Performance A number of factors can affect CPU utilization on a database server: compilation and recompilation of ...
  • Portable DBA: Oracle
    This post contains examples of a number of the most commonly performed DBA activities. They are all listed in alphabetical order by the comm...
  • Move distribution database to another drive
    Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...