Erik Veerman's Blog, page 3

Azure ASR and SQL Server

Learn how to protect a SQL Server virtual machine in Azure from a disaster by replicating from the northern region of Europe to Western Europe. The process of testing the DR environment is straightforward and fast thanks to the automation offered by Azure. Protecting a single machine is only a small step within a DR strategy at the corporate level, which must take into account many more factors, as well as the dependencies between the different resources, services, etc

The post Azure ASR and SQL Server appeared first on SolidQ Blogs.

What is Machine Learning?

The increasing diversification of the type and volume of data, the cheapening of computational processing costs and storage costs have opened a window of opportunity for the resurgence of a discipline that already existed on paper and among equations: Machine Learning.

The post What is Machine Learning? appeared first on SolidQ Blogs.

Get data in Power BI from Oracle Database

Microsoft’s Business Analytics Service Power BI, enables us to connect to hundreds of data sources and produce beautiful reports that can be consumed on the web and across mobile devices, in order to deliver insights throughout our entire organization. In this post, I will walk you through the process to get data in Power BI […]

The post Get data in Power BI from Oracle Database appeared first on SolidQ Blogs.

Python for SQL Server Specialists Part 4: Python and SQL Server

Learn how to use SQL Server Python libraries in SQL Server. You can use two scalable libraries, the revoscalepy and microsoftml libraries, which correspond to equivalent R libraries.

The post Python for SQL Server Specialists Part 4: Python and SQL Server appeared first on SolidQ Blogs.

How to extract Twitter data with a windows service created with Python in Visual Studio 2017

Code a script in python (with Visual Studio 2017) to create a program to then execute as a windows service in order to extract (in almost real time) the tweets related to certain words or hashtags, store them in a SQL server database, and then consume them with Power BI.

The post How to extract Twitter data with a windows service created with Python in Visual Studio 2017 appeared first on SolidQ Blogs.

Python for SQL Server Specialists Part 3: Graphs and Machine Learning

In this article you will learn about the most important libraries for advanced graphing, namely matplotlib and seaborn, and about the most popular data science library, the scikit-learn library. You will learn how to do graphs with two Python libraries: matplotlib and seaborn. Matplotlib is a mature well-tested, and cross-platform graphics engine. In order to work with it, you need to import it.

The post Python for SQL Server Specialists Part 3: Graphs and Machine Learning appeared first on SolidQ Blogs.

How to refresh Power BI dataset from an on-premise Power Shell script

We will use the Power BI libraries for power shell to connect to our power Bi portal and send an instruction to refresh a data set. This could be useful to improve our ETL processes, refreshing our on-line datasets used in Power Bi portal before loading data into our data-warehouse and/or our OLAP/Tabular database send an instruction to.

The post How to refresh Power BI dataset from an on-premise Power Shell script appeared first on SolidQ Blogs.

Python for SQL Server Specialists Part 2: Working with Data

In this article, you will learn about the objects from the two of the most important Python libraries, namely, as mentioned, numpy and pandas.

The post Python for SQL Server Specialists Part 2: Working with Data appeared first on SolidQ Blogs.

Python for SQL Server Specialists Part 1: Introducing Python

Python is one of the most popular programming languages. It is a general purpose high level language. It was created by Guido van Rossum, publicly released in ...

The post Python for SQL Server Specialists Part 1: Introducing Python appeared first on SolidQ Blogs.

SQL Server Integration Services and Auto Adjust Buffer Size

In this post, we will talk about the new property that appears in the SQL 2016 version: Auto Adjust Buffer Size. This attribute is specific to the "DataFlow" component and can take the values of 'True' or 'False' (default). Furthermore, we will propose an approximate solution for previous versions.

The post SQL Server Integration Services and Auto Adjust Buffer Size appeared first on SolidQ Blogs.