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 159)
Five methods for creating partitions of SSAS Tabular tables programmatically
Posted by Andy Brown on 23 July 2018
Need to generate a partition for a fact table for each year, product or region? This blog gives five approaches, so that you can choose which method is for you.
Using partitions/processing to load a large fact table into a tabular data model
Posted by Andy Brown on 23 July 2018
This blog shows how you can load the empty structure of a large fact table into an Analysis Services tabular data model, then use partitions to bring in the data bit by bit.
Using MERGE and MATCHED in SQL
Posted by Sam Lowrie on 21 June 2018
Learn how to MERGE rows from two tables into one combined table, and how to remove unwanted data from both tables.
Resolving a problem with SSRS and a Windows 10 update
Posted by David Wakefield on 18 June 2018
After installing Windows 10 our laptops started returning a 503 error in Web Portal - this blog shows how to resolve this.
How to get rid of lots of blank rows in a Report Builder table
Posted by Andy Brown on 16 February 2018
There seems to be an occasional bug in Report Builder which fills a table with blank rows. Here's one owl's way to get round it.
Which should you learn: Report Builder or Reporting Services?
Posted by Andy Brown on 16 February 2018
Report Builder and SQL Server Reporting Services are almost identical - which makes the small but important differences even harder to explain.
Did you know there was an IIF function in SQL to test conditions? We didn't!
Posted by Andy Brown on 16 February 2018
You can use the IIF function in SQL as an alternative to the CASE WHEN statement. We thought we would share this new (for us) discovery with the world!
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.
Create your own snippets of SQL code, and insert them into your queries
Posted by Andy Brown on 23 November 2017
With SQL Server 2012 came the power not just to use pre-defined code snippets, but also to create your own - this blog explains how.
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 are 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.