THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Python   (RSS)
  • How would you do dynamic pivot SQL in Amazon Redshift? (This elegant script might be used in many other databases as well)

      Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language. Redshift is based on Postgre SQL 8.0.2 ( which was released in 2005 !!!! ) Anything you would want for this, not too difficult task,  does not ...
    Posted to Maria Zakourdaev (Weblog) by Maria Zakourdaev on November 7, 2017
  • Working with SQL Server for Linux Cross-Platform

    Next week, on August 24th a new webinar from the PASS Application Development Virtual Group will be aired. This time the topic is the Cross-Platform support introduced with the forthcoming SQL Server 2017. Maximo Trinidad will delivery the following session: Working with SQL Server for Linux Cross-Platform You're welcome to explore the ...
    Posted to Davide Mauri (Weblog) by manowar on August 15, 2017
  • PASS SQL Saturday #687 Slovenia 2017

    Here we go for the fifth time! The leading event dedicated to Microsoft SQL Server in Slovenia, PASS SQL Saturday #687, will take place on Saturday, December 9th 2017, at the Faculty of Computer and Information Science of the University of Ljubljana, Večna pot 113, Ljubljana (https://www.fri.uni-lj.si/en/about-faculty/how-to-reach-us). This is ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 11, 2017
  • Creating a Spark dataframe containing only one column

    I’ve been doing lots of Apache Spark development using Python (aka PySpark) recently, specifically Spark SQL, and one thing I’ve found very useful to be able to do for testing purposes is create a Spark SQL dataframe from literal values. The documentation at pyspark.sql.SQLContext.createDataFrame covers this pretty well however the code there ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 12, 2016
Privacy Statement