Conditional Coloured Bar Charts in Excel with Upper and Lower Targets
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
569 reads
Terry's Business Intelligence
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview...
2014-03-25
766 reads
Introducing Microsoft Dynamics AX 2012 with SSRS Reports
Hi all, I’ve started a new job with eBECS which is a Microsoft Gold Partner in the ERP Business. Since...
2014-03-25
787 reads
First take on PowerPivot
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,656 reads
Understanding the PIVOT function
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,104 reads
Get list of dates using recursive Common Table Expression (CTE)
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,116 reads
Top 10 Tips when synchronising your database and Mailchimp
Okay, sooner or later someone is going to need to synchronise all those people who registered on your company website...
2013-10-17
585 reads
MailChimp Database Synchronisation Process
After giving you the Top 10 Tips when synchronising your database with MailChimp, I thought why not write up the...
2013-10-17
1,158 reads
Top 11 Qualities of a DataWarehouse Implementer
Top 11th Quality: Curious to explore different designs There are many ways to achieve the same thing. Before actually getting...
2013-10-14
535 reads
Building a simple forecast solution on SQL Server
Pricing Forecast is a marketing function that requires a lot of data crunching. Normally there are some factors that the...
2013-08-30
1,531 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers