kohera-logo-regular.svg

SQL Spot – Part 2

Hi there. Back again with more splendid community articles. Once again I tried gathering some noticeable information for you on common SQL Server topics regarding business, BI, Data Science, Azure, maintenance, tuning, learning and more…. As always, all rights go out to the community for putting in all the work.

Business, releases and news

Business

Releases

Trivial

Power BI

General

Power BI

Excel BI

SSIS

SSAS

Tabular 2016

  • The tabular object model (TOM) serves as an API to create and manage partitions. TOM was released with SQL Server 2016 and is discussed here. The Automated Partition Management for Analysis Services Tabular Models whitepaper is available here. It describes how to use the AsPartitionProcessing TOM code sample with minimal code changes.

SSAS Azure

SSAS vNext

  • CTP 1.3 introduces encoding hints, which is an advanced feature used to optimize processing (data refresh) of large in-memory tabular models.

DAX

SSRS

Data science

Machine Learning

  • To use the data, it needs to be cleansed, transformed and processed to a format that we can use to build predictive models. This process is called the data science process and it can be leveraged using machine Llearning techniques.

R

Stream Analytics

Cognitive Services

Maintenance

Backup and Restore

Storage

  • If you need to run SQL Server in an Azure virtual machine, your choice of Azure storage will have a great effect on its performance. Look here for some introduction on making your decisions.

Health Practices

Index

  • Kimberley Tripp releases a new version of her sp_helpindex solution, with newer functionality (included columns and filters) as well as being better at describing what’s really in your indexes.

Troubleshooting

Security

Tuning

Internals

Index Tuning

In-memory optimization

Practices

Learning

Samples

Courses

Literature

Vids

  • One of the more interesting Channel 9 series to follow: data exposed.
  • Some more learning vids from MSSQLTIGER January 2017 PASS Virtual Conferences, showing you how SQL Server 2016 changes the game using the power of In Memory OLTP.

General

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had...

Creating maps with R and Power BI

The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let...

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you...

Send mails with Azure Elastic Database Jobs

The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options,...

Sorting matrices in Power BI

Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report...

The world of data is evolving

The data landscape has changed dramatically over recent years. In the past, we mainly heard that we needed to do as much as possible “cloud-only”—but this trend has become more...