As the business intelligence (BI) horizon continually expands, IBM’s TM1 (now known as IBM Planning Analytics) finds itself amidst a proliferating cluster of cloud-based BI tools. This powerful, multidimensional analysis tool has been vital for organizations seeking robust planning, forecasting, and reporting solutions. With the advent of versatile Cloud BI tools, the landscape appears saturated, …
Continue reading “Navigating Future Prospects: IBM’s TM1 Amidst a Cloud BI Tool Surge”
Azure Synapse, Microsoft’s integrated analytics service, empowers businesses with unmatched speed, performance, and security. For UK consultancy firms intent on facilitating data integration, exploration, and analysis for their clients, this robust platform offers invaluable tools, thereby simplifying the process and driving insightful business intelligence. At its core, Azure Synapse seamlessly combines big data and data …
Continue reading “Unleashing Potential: Azure Synapse at the Forefront”
The business intelligence (BI) landscape for Small and Medium Enterprises (SMEs) is awash with robust solutions, chief among them being Amazon Web Services (AWS) and Microsoft Azure. These giants offer compelling features tailored to bolster BI processes, though they differ subtly in terms of benefits and offerings. AWS: Unparalleled Scalability & Flexibility AWS excels in …
Continue reading “AWS vs. Azure: Navigating the BI Horizon for SMEs”
Being an SSD early(ish) adopter in my work laptop I’ve had my fair share of problems but as everything seemed to have settled down recently and particular after upgrading to Windows 8, I thought I’d go back to encrypting the disk. I know this comes with a performance hit but using Bitlocker in Win 8 …
Continue reading “SSD bad sectors, chkdsk rubbish,.NET Corruption and SFC can’t repair”
I’ve been an on-again-off-again DBA for over 15 years now but still get caught out by stupid little SQL Server behaviors! Today I was looking into why a perfectly good SQL statement that in testing hits an index perfectly and runs in milliseconds takes many seconds in Production when run as a stored procedure. The …
Continue reading “Stored Procedure execution plan different to Query – Parameter sniffing”
Just encountered a frustrating error that prevented a new SSIS package from compiling and running. FTP Tasks had stubborn red crosses against them with the cryptic errors. Error 1 Validation error. Delete C1 CTRL : Failed to lock variable “” for read access with error 0xC0010001 “The variable cannot be found. This occurs when an …
Continue reading “SSIS FTP Task Error: Failed to lock variable”
