This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

SQL and SQL Server blogs from Wise Owl (page 2 of 4)

Showing blogs 21-40 (out of 66)

Azure Data Studio versus SQL Server Management Studio

Posted by Andy Brown on 16 January 2020

Microsoft have brought out a new SQL editor called Azure Data Studio, to act as a substitute for SQL Server Management Studio, but this owl cannot see any justification for its existence!

Tags:
SQL > General

Introducing the new CREATE OR ALTER command in SQL

Posted by Andy Brown on 10 January 2020

From SQL Server 2016 onwards you can choose to CREATE OR ALTER a procedure, trigger, view or function, as this blog explains.

Tags:
SQL > SQL programming

You can now use AT TIME ZONE to access different time zones in SQL

Posted by Andy Brown on 25 November 2019

If you're working with different time zones, the AT TIME ZONE keywords introduced in SQL Server 2016 will make your life much easier - this blog explains how they work.

Tags:
SQL > Selecting data

A comparison of SQL Server Reporting Services and Power BI

Posted by Andy Brown on 18 October 2019

Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.

Tags:
SSRS > General Power BI > General

Introducing three new functions in SQL to make concatenating text easier

Posted by Andy Brown on 20 September 2019

The CONCAT function makes it much easier to join columns together, while the STRING_AGG and CONCAT_WS functions make it easier to create things like comma-delimited lists.

Tags:
SQL > Calculations

A table-valued function in SQL to split a comma-delimited list

Posted by Andy Brown on 11 June 2019

If you're creating Reporting Services reports using multivalue parameters and stored procedures, you'll find this function to split a list of values into a single-table column useful.

Tags:
SQL > Functions SSRS > Parameters

Wise Owl have found one SQL structure which slows down code more than any other

Posted by Andy Brown on 13 May 2019

If your stored procedures or SQL queries are running slowly, don't bother looking at correlated subqueries, cursors, functions or any of the other usual culprits. There's one SQL syntax which Wise Owl have found to be an order of magnitude worse than any other, as this blog shows.

Tags:
SQL > General

Mapping stored procedure parameters to SSRS parameters

Posted by Andy Brown on 02 May 2019

This blog explains why you might want to use the PARAMETERS tab in the Dataset Properties dialog box in SSRS.

Tags:
SSRS > Parameters

A new acronym for the order of SQL keywords

Posted by Andy Brown on 29 March 2019

Someone has finally won our competition to think of a better acronym for the order of keywords in SQL, we're pleased to announce.

Tags:
SQL > Selecting data

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.

Tags:
SSAS tabular > Partitions and processing

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.

Tags:
SSAS tabular > Partitions and processing

Using MERGE and MATCHED in SQL

Posted by Sam Lowrie on 19 June 2018

Learn how to MERGE rows from two tables into one combined table, and how to remove unwanted data from both tables.

Tags:
SQL > Programming tables

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.

Tags:
SSRS > Report Builder

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.

Tags:
SSRS > Report Builder SSRS > General

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!

Tags:
SQL > Calculations

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.

Tags:
SSIS > Control flow tasks

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.

Tags:
SSIS > Data flow

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).

Tags:
SQL > Programming tables

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.

Tags:
SQL > Stored procedures

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.

Tags:
SQL > General

This page has 0 threads

Add a new post

BY TOPIC