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
Data Savvy
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,448 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
Trekking through the DAX Jungle In Search of Lost Customers
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
457 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,300 reads
Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
824 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers