BY TOPIC
SQL SERVER BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
SQL Server blogs from Wise Owl (page 1 of 8)
Showing blogs 1-20 (out of 150)
This blog shows a clever way to annotate expression constraints in SSIS
Posted by Andy Brown on 27 April 2017
If you've added an expression constraint to control flow in a package in Integration Services, this blog will show you how to display what the constraint does automatically.
How to loop over the worksheets in an Excel workbook using Integration Services
Posted by Andy Brown on 21 April 2017
Follow this blog to learn how to use an SSIS package to loop over the worksheets in an Excel XLSX workbook, importing the contents of each.
Speed comparison of temporary tables against table variables
Posted by Andy Brown on 02 March 2017
When you're programming in SQL, you often have the choice of using table variables or temporary tables. This blog considers whether one method is substantially quicker than the other (spoiler alert: not really).
A list of one owl's 5 favourite system stored procedures in SQL!
Posted by Andy Brown on 03 February 2017
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.
Wise Owl coding standards for T-SQL (the SQL dialect used in SQL Server)
Posted by Andy Brown on 01 February 2017
A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.
Is the new(ish) FORMAT function in SQL Server slow?
Posted by Andy Brown on 16 January 2017
SQL Server 2012 saw the introduction of the T-SQL FORMAT function, making it easier to present dates nicely (no more remembering CONVERT arguments such as 103!). But is it too slow to be really useful? This blog aims to test this scientifically.
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.
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.
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.
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.
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.
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.