BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python Python is widely used to analyze data. One such use is to find anomalies or outliers. In this article, Robert... 16 January 2018 16 min read
BI Rick Dobson in BI Historical Stock Prices and Volumes from Python to a CSV File Python is a versatile language that is gaining more popularity as it is used for data analysis and data science.... 05 January 2018 23 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 3: Plotting Data with Python One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis... 02 January 2018 26 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do... 18 December 2017 28 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services: Python with sp_execute_external_script Run Python scripts in SQL Server using sp_execute_external_script in Machine Learning Services. Part 1 covers enabling MLS, naming input/output variables,... 30 November 2017 21 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
Timothy Wiseman Python for the SQL Server DBA Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find... 27 August 2009 8 min read
Ron Dameron Comparing Python and PowerShell DBA Scripting Just when it seemed that there were were no adequate scripting systems for DBAs that could access .NET, along came... 03 August 2007 11 min read