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 1 of 4)

Showing blogs 1-20 (out of 62)

SQL Exercises using Wise Owl's Music Database

Posted by Andrew Gould on 05 June 2024

We've recently published a new set of exercises for our SQL training courses based on a database of concert tours. This blog provides a brief tour of the database and how to tackle the exercises on our website, even if you haven't attended a Wise Owl training course.

Tags:
SQL > General

Tricks to change column order in SQL and in Power BI

Posted by Andy Brown on 04 March 2024

Two little tricks to change the order of columns in SQL Server Management Studio and Power BI Query Editor, which (to our shame?) we've only just discovered.

Tags:
SQL > Selecting data Power BI > Query editor

Wise Owl are now running a new Introduction to MySQL course

Posted by Andy Brown on 25 September 2023

We've been teaching SQL to advanced level for a long time now, but it's always been using Transact SQL (T-SQL), the Microsoft SQL Server dialect. If you have a MySQL database we can now teach you using your correct dialect and coding environment (let us know if you are interested in PostgreSQL, PL/SQL for Oracle or any other dialect).

Tags:
MySQL > General MySQL

The differences between SSMS and Azure Data Studio

Posted by Andy Brown on 30 August 2023

Should you write your SQL queries in SQL Server Management Studio (SSMS) or Azure Data Studio (ADS)? Read this blog to find out!

Tags:
Azure Data Studio > General SQL > General

Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools

Posted by Andy Brown on 07 June 2023

One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).

Tags:
SQL > General Python > Progamming VBA macros > General Client script > JQuery Office Scripts > General

Write your queries more quickly with SQL Prompt from Redgate

Posted by Andy Brown on 26 April 2023

The SQL Prompt utility from Redgate has an annual subscription cost, but on the plus side it will complete tedious joins for you (among many other things).

Tags:
SQL > Joins

Implementing UPDATE queries using CTEs

Posted by Andy Brown on 26 April 2023

The syntax of update queries in SQL is fiddly and hard to remember - much better to create a CTE and do updates through this!

Tags:
SQL > CTEs, subqueries

Which dialects of SQL should Wise Owl teach next?

Posted by Andy Brown on 01 February 2023

Although we currently just train in T-SQL for SQL Server, there are many other dialects of this database language: such as MySql and PL/SQL, for example. Which ones would you like Wise Owl to run courses in?

Tags:
SQL > General

Making Reporting Services use consistent chart colours

Posted by Shaun Wantling on 28 October 2022

A simple way to ensure that SSRS allocates colours consistently to different charts in an embedded table

Tags:
SSRS > Charts

New SQL Language Features for SQL Server 2022

Posted by Andy Brown on 06 October 2022

SQL Server 2022 is now in preview (you can download an evaluation copy). It includes new functions to split strings, trim text and truncate dates, among other things.

Tags:
SQL > General

What is SQLCMD mode, and how can you use it?

Posted by Andy Brown on 24 November 2021

You can use SQLCMD mode to parameterise the connection, database name, table name and select columns for a query - and much more besides, as this blog explains.

Tags:
SQL > SQL programming

Practise SQL in your browser with SQL Fiddle

Posted by Sam Lowrie on 30 June 2021

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

Tags:
SQL > General

What to do when you get red squiggly lines in SSMS and no Intellisense

Posted by Sam Lowrie on 28 April 2021

Normally when SQL Server Management Studio underlines words with what Microsoft call "red squigglies" it's because you haven't refreshed your local cache, but it could also be because of a recent bug - here's how to get round this!

Tags:
SQL > General

The new SQL String_Split function for comma-delimited strings

Posted by Andy Brown on 22 March 2021

If you're using SQL Server with compatibility level 130 or greater you can now use the new String_Split function to divide a comma-delimited string into a table of values.

Tags:
SQL > Functions

What Power BI report server is, and how to create reports through it

Posted by Andy Brown on 23 December 2020

Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!

Tags:
Power BI > General SSRS > Report Manager

5 horrible SQL jokes and one puzzle

Posted by Sam Lowrie on 15 November 2023

Sam has a terrible sense of humour which is all too often inflicted on his delegates. Sadly, with this blog, on website viewers too ...

Tags:
SQL > General

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

This page has 0 threads

Add a new post

BY TOPIC