Insufficient Disk Space (T-SQL Tuesday #88)
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,774 reads
Data Savvy
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,723 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
613 reads
Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
751 reads
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,821 reads
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,334 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
479 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
643 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,446 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,134 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...