Zap Business Intelligence Installation
This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the...
2014-03-26
962 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
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
765 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,655 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,103 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,115 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,156 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
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
534 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,530 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers