The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,236 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,120 reads
Adding Slicers to a Reporting Services Report
This article shows you how to create dynamic slicers from a data set in an SSRS report
2016-08-05 (first published: 2015-04-23)
16,906 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,108 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,446 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,102 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,583 reads
Interactive Parameter Selection with Reporting Services
Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI
2015-05-21
8,834 reads
Maps in SQL Server Reporting Services
Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.
2015-04-13
10,165 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,408 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers