SQL Server blogs from Wise Owl (page 1 of 8)

Showing blogs 1-20 (out of 144)

How to use the FOR XML keywords in SQL to concatenate ids

Posted by Andy Brown on 27 September 2016

If you want to group items in a SQL query, showing a comma-delimited list of ids for each, generating an XML file is not the obvious place to start - but it should be.

Tags:   SQL | General

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.

Tags:   SQL Server 2016 | General

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.

Tags:   SQL Server 2016 | General

Using SSIS to loop over the worksheets in an Excel workbook, importing each

Posted by Andy Brown on 07 April 2016

Looping over Excel workbooks is one thing, but how can you loop over all of the worksheets in a single workbook, importing the contents of each? This blog explains the steps you need to follow.

Tags:   SSIS | Files and folders

Unpivoting data in SSIS using the Unpivot transformation

Posted by Andy Brown on 07 April 2016

If you've been given the output from a pivot table or a cube, you can collapse it back into its original state using the UNPIVOT transform in Integration Services.

Tags:   SSIS | Data flow

In SSMS, how to add multiple aliases to tables using the ALT key

Posted by Andy Brown on 23 March 2016

It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.

Tags:   SQL | Tables and columns    |    T-SQL | Other

How to use security roles to restrict access to your SSAS Tabular model

Posted by Andy Brown on 26 February 2016

Perspectives in Analysis Services let you show different parts of your tabular model to different people, but they don't have any security. To ensure that the right eyes see the right bits of your model, you'll need to create and manage security roles, as explained in this blog.

Administrator access to a tabular Analysis Services instance

Posted by Andy Brown on 22 February 2016

This blog gives an outline of how to add administrators to an instance of SSAS, and how to set whether some accounts are automatically made administrators by default.

How to use DirectQuery to run queries in SSAS Tabular against SQL Server tables

Posted by Andy Brown on 22 February 2016

DirectQuery mode allows you to run queries in Analysis Services (Tabular) directly against the underlying SQL Server tables imported into the model. This blog explains what DirectQuery is, shows how to enable it and gives an idea of its pros and cons.

Find how to use table partitions in SSAS Tabular to process data more quickly

Posted by Andy Brown on 19 February 2016

You can partition a table in SSAS Tabular, which involves processing it in chunks rather than in one fell swoop. This blog explains how partitions work, and how to set them up and use them.

How to process tables in your model, and ideas for speeding processing up

Posted by Andy Brown on 19 February 2016

Processing tables involves loading data into your model, and can take a long time. This blog explains how processing works in SSAS Tabular and the different options available to you, shows how to process tables or models, and gives some ideas on how to make processing run more quickly.

Using tabular model perspectives to restrict which tables a user sees

Posted by Andy Brown on 18 February 2016

Perspectives in SSAS tabular are windows which allow you to control who sees which bits of your model. They're really easy to set up, as this blog shows, but aren't a substitute for setting security roles.

How PowerPivot differs from SSAS Tabular, and using it to prototype data models

Posted by Andy Brown on 18 February 2016

PowerPivot is virtually identical to SSAS Tabular underneatht the glossy exterior, but it has got a few extra features explained in this blog (which also shows how to import PowerPivot data models into Analysis Services, and why you might want to do this).

How to get data from tabular models using DAX queries in various programs

Posted by Andy Brown on 18 February 2016

Knowing how to write DAX queries is one thing, but where are you going to use them? This blog shows how you can integrate DAX queries into SSMS, SSRS, SSIS, Excel and PowerPivot.

How to write queries in DAX to interrogate SSAS tabular models

Posted by Andy Brown on 12 February 2016

As well as creating measures to aggregate data in tabular models using DAX, you can also write queries to extract data - this blog shows you how!

This page has 0 threads Add post