Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...
2016-10-21 (first published: 2016-10-14)
4,871 reads
Meagan Longoria
- Website: http://DataSavvy.me
Documenting your Tabular or Power BI Model
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,367 reads
BYO Time Zone Conversion With SSAS DMVs
This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...
2016-09-21
486 reads
DAX Date Dimension and Fun with Date Math
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
646 reads
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,449 reads
PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,140 reads
Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
797 reads
BimlScript – Get to Know Your Control Nuggets
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
466 reads
BimlScript – Get to Know Your Code Nuggets
In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...
2016-06-30
942 reads
Colorblind Awareness and Power BI KPIs
Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...
2016-04-23
588 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
Wa cs Qlola bri
Butuh panduan penggunaan QLola BRI? Melalui whatsapp 08136035412 Butuh panduan penggunaan QLola BRI? Hubungi...
Layanan wa Qlola bri
Layanan support QLola BRI tersedia melalui WhatsApp 08136035412 untuk membantu berbagai kebutuhan Anda, mulai...
Pusat bantuan qlola bri resmi
Layanan bantuan QLola BRI melalui whatsapp 628136035412 Layanan bantuan QLola BRI kini lebih mudah...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers