Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

For those of you still using SQL Server 2005, Microsoft will completely end support on April 12th 2016. You can head over here to check out upgrade guidelines, download migration tools, and read more ...

Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data ...

In my last article, I told you a bit about Microsoft’s overall big data strategy in SQL Server 2014 (which has just become available to customers) with a deep dive ...

Microsoft deprecates SSRS, PBIRS and SSAS management packs for SCOM, ending support in 2027. The move signals a shift from on-prem SCOM extensions toward cloud-based SQL Server monitoring. IT teams ...

Today, at its Ignite conference in Orlando, Microsoft is announcing the general availability of a new version of its flagship operational database, SQL Server 2017. SQL Server is a product I have ...

The msmdsrv.exe file is associated with Microsoft SQL Server and is a component of SQL Server Analysis Services (SSAS). However, many users reported that Msmdsrv.exe ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...