SQL Server 2016 announced as SQL Server 2005 support nears its end

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 ...
Analytics Insight

SQL Server or Oracle? Find Out Which Database Fits You Best

SQL Server supports quicker deployment across enterprise tools through integration services and hybrid system support.Oracle Database is structur ...
Redmond Magazine

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...
Analytics Insight

Install Microsoft SQL Server Easily: Quick Beginner’s Guide

Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...
Chris Webb's BI Blog

Power BI, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...