Category Archives: Python

Python and SQL Server Administration

Posted on January 8, 2018 by Prashanth Jayaram

Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server 2017. Why would a SQL Server DBA be interested in Python An overview of Python vs PowerShell for SQL Server … Continue reading →

Posted in Python, SQL 2017 | Tagged , , , , | Leave a comment

An overview of Python vs PowerShell for SQL Server Database Administration

Posted on November 2, 2017 by Prashanth Jayaram

Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been ported over to Linux, taking PowerShell along. PowerShell runs really well on Ubuntu, CentOS, RedHat Linux, and even Mac OSΒ X. … Continue reading →

Posted in PowerShell, Python, SQL 2017 on Linux | Tagged , , | Leave a comment

Why would a SQL Server DBA be interested in Python?

Posted on October 23, 2017 by Prashanth Jayaram

If we follow blogs and publications on the technological advancement with respect to SQL, we notice the increase in the number of references to Python, of late. Often, that makes us think: Why so much emphasis on Python these days? … Continue reading →

Posted in Python, SQL 2017, SQL 2017 on Linux | Tagged , , , | Leave a comment

How to use Python in SQL Server 2017 to obtain advanced data analytics

Posted on June 20, 2017 by Prashanth Jayaram

On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. Microsoft has, over the last few years, … Continue reading →

Posted in Python, SQL Server 2017 | Leave a comment