The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,233 reads
Adam Aspin
Adding Time Intelligence to a Power BI Data Model
In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data
2017-10-27 (first published: 2016-06-06)
7,113 reads
Third Party Visuals in Power BI Desktop
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
2016-05-31
11,104 reads
Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI
In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data
2016-05-23
1,445 reads
Do It Yourself Load Balancing with SSIS
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
2015-08-03
7,099 reads
Data Load Optimisation using the SSIS Balanced Data Distributor
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
2015-07-02
7,578 reads
Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
24,381 reads
Data Profiling with T-SQL
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
25,829 reads
Slowly changing dimensions using T-SQL MERGE
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
2011-06-20
42,036 reads
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,651 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Kontak BCA KCU TANGERANG CITY Telp:(08218154392)
WA CS 08218154392 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl....
Alamat Kontak BCA KCP Bone Telp:(08218154392)
WA CS 08218154392 Jl. Jend. Ahmad Yani No.169, Watampone, Kec. Tanete Riattang Bar., Kabupaten...
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers