Wise Owl Training - SQL Server versions blogs

Showing blogs 1-17 (out of 17)

What's new in SQL Server 2017? For SSAS Tabular, lots, it transpires.

Posted by Andy Brown on 23 January 2018

This blog summarises the main new features of SQL Server for non-administrators (that is, most of us). Most parts of SQL Server get minor changes at best, but SSAS Tabular 2017 gets a host of major improvements.

SQL Server 2016 contains lots of new goodies, as this blog explains

Posted by Andy Brown on 11 July 2016

Microsoft have made huge changes to SQL Server Reporting Services and Analysis Services (Tabular Model), and smaller ones to SSIS, SSAS (cubes) and SQL. This blog gives the main highlights, with links to blogs giving the full Monty for each area of SQL Server 2016.

An analysis of the main new features in SQL Server Reporting Services 2016

Posted by Andy Brown on 11 July 2016

Microsoft have put a lot of effort into SSRS 2016, including completely rewriting Report Manager (it's now called Web Portal) and creating separate software for publishing reports to mobiles. There are lots of new features to contemplate!

How to install Visual Studio 2015 Community and SQL Server 2016 Developer

Posted by Andy Brown on 11 July 2016

This short blog summarises how to get legitimate free copies of Visual Studio 2015 and SQL Server 2016 Developer installed on your laptop or computer.

This blog summarises the (many) new features in Analysis Services 2016 (Tabular)

Posted by Andy Brown on 08 July 2016

Microsoft have made lots of improvements to SSAS (Tabular model) - we particularly like the new DAX editor! This blog lists all of the most interesting changes, divided into 4 separate sections.

A quick summary of new features in Analysis Services multi-dimensional model

Posted by Andy Brown on 08 July 2016

What's new for cubes (or Analysis Services multi-dimensional models, to give them their full title)? Virtually nothing, as this oh-so-short blog makes clear.

A summary of the main new features in SQL Server Integration Services 2016

Posted by Andy Brown on 08 July 2016

My favourite new feature in SSIS 2016 is the ability to group components of a package together for reuse elsewhere, but there are quite a few more nice new ideas!

What's new in the T-SQL language for SQL Server 2016

Posted by Andy Brown on 23 June 2016

A quick summary of the (few) new language features introduced into SQL for SQL Server 2016.

What's new in Analysis Services 2012 versus 2008 R2

Posted by Andy Brown on 19 December 2014

If you're creating multidimensional models (as you probably will be), Analysis Services has barely changed between versions 2008 R2 and 2012 - and the small differences are mostly in the favour of the older version. This blog plays spot-the-difference between Analysis Services 2008 R2 and 2012.

A short blog showing that SSIS 2014 is the same as 2012

Posted by Andy Brown on 27 November 2014

Possibly the shortest Wise Owl blog, listing the changes between Integration Services 2012 and 2014 (there aren't any!).

A detailed blog exploring what's new in SSIS 2012

Posted by Andy Brown on 27 November 2014

If you're wondering whether to upgrade to Integration Services 2012, or just want to know what differences there are between SSIS 2008 R2 and 2012, this blog should help you!

How to use the LAG and LEAD functions included in SQL Server 2012

Posted by Andy Brown on 20 September 2013

SQL Server 2012 introduces new functions to find the previous or subsequent value for a row, without using a complicated self-join. This blog explains how to use LAG and LEAD, including partitioning row sets.

Tags:   SQL | Calculations    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

Differences between SSRS 2008 R2 and 2012 for Excel render format

Posted by Andy Brown on 17 June 2013

This blog shows how to conditionally hide, display or format parts of a report according to its render format (ie whether you're viewing it in Excel or not). The method used is slightly different between 2008 R2 and 2012.

Tags:   SSRS | Expressions    |    SQL Server versions | SQL Server 2012

Create a calendar table for PowerPivot or Analysis Services in SQL Server

Posted by Andy Brown on 04 January 2013

This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar    |    SQL Server versions | SQL Server 2012

New in SQL 2012 - code snippets and surrounding code

Posted by Andy Brown on 15 May 2012

In a previous blog on new features of SQL 2012, I missed out the ability to insert code snippets, and also to embed or surround code in an IF, BEGIN or WHILE block. This blog rectifies this!

Tags:   SQL | General    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

New features for SQL within SQL Server 2012

Posted by Andy Brown on 08 May 2012

SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.

Tags:   SQL | General    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

SQL Server Reporting Services 2012 versus 2008 R2

Posted by Andy Brown on 08 May 2012

SQL Server Reporting Services 2012 (SSRS 2012) has been completely rewritten (it's now called SQL Server Data Tools), and yet looks strangely familiar. This blog explains the new features introduced.

Tags:   SSRS | General    |    SQL Server versions | SQL Server 2012
This page has 0 threads Add post