SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.
2020-03-11
In this article in the series, Robert Sheldon provides a deep dive into HDDs.
2020-03-09
DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in this series, Andy Brown explains how to write measures using the range of date functions in DAX, and also explains how time-intelligence functions work behind the scenes.
2020-03-06
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
5,822 reads
Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]
2020-02-03
1,061 reads
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
2,996 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2019-11-04
5,728 reads
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
3,988 reads
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2019-09-12
2,768 reads
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
7,512 reads
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Does anyone know of any existing script that would allow me to list all...
Hello, How to delete backups in blob storage from azure sql server VM to...
Ask SSC