kohera-logo-regular.svg

SQL Spot – Part 2

Vector_BG.png

SQL Spot – Part 2

Vector_BG.png

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

2319-blog-database-specific-security-featured-image
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
kohera-2312-blog-sql-server-level-security-featured-image
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
blog-security_1
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
DSC_1388
Aggregaties
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
blog-2303
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...