Using SQL Server and R Services for analyzing Sales data (Part 3)
Using R integration for analyzing sales data in WideWorldImporters database
2019-02-08 (first published: 2017-01-17)
4,875 reads
Articles
Which Version of SQL Server Should You Use?
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
2019-02-08
4,012 reads
Protecting SQL Server Data Using Static Data Masking
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
2019-02-07
2,794 reads
Import data dynamically using R and Python in Power BI Desktop
Learn how to import data into Power BI using either R or Python scripts.
2019-02-06
2,238 reads
Better Code Reviews with GIT
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
2019-02-05
3,221 reads
Creating Your First Stored Procedure
Learn how to get started writing code modules inside of your SQL Server database,
2019-02-04
7,117 reads
Robotics Process Automation: The New Digital Assistant
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.
2019-02-04
2,164 reads
Installing R packages in SQL Server R Services
This article shows four ways you can use when installing missing R packages for Microsoft R Services.
2019-02-01 (first published: 2016-09-29)
6,019 reads
The 2019 Data Professional Salary Survey Results
How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it looks like on average, y’all got raises this year.)
2019-02-01
4,009 reads
Cyber Insecurity in Pakistan
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
2019-01-31
3,554 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers