Squeeeeze

David Boulton • Jul 17, 2018

Oh no!! Here we go with another post about maintenance!

Yes - sorry, I know we keep banging on about maintenance, and how you should schedule a time each month to do it, to keep everything in "tip, top" shape!

But hang on, isn't that just common sense?

When you buy a car, you don't just run it forever, without replacement tyres, an oil change, new wiper blades? Do you?????

So the title of the BLOG is wrong, Squeeeeze was used for comedy effect. Really the BLOG should be called "Shrink" (but I couldn't find a suitable picture for that!).

Myriad v4 and Myriad 5 Playout use Microsoft (TM) SQL as their database engine. [Nerdy note: The database engine, is where lots of important information is stored and accessed really quickly. When you look at the "Log", we are asking the SQL for lots of information, displaying it on screen, and then telling SQL when you move / delete / play / etc an item.

I was looking at a customers' system the other day, helping them with some issues, and as an aside note they mentioned that things were "running a bit slow". Now this could have many, many causes! The one I go to, before anything else is the size of the SQL Database.
When you are running day in, day out, there are massive amounts of information stored to the SQL database, and this can grow in size. If left then the SQL Engine has to do a lot of hard work reading information from this large file (keeping some in memory), but this will have an effect on the speed it can deliver the information (and receive it) from Myriad / Autotrack / Myriad News.

So, let's get maintaining (ing, ing, ing).

The first thing you can do (and you don't have to be that technical) is read one of the first message boxes you see when you launch Autotrack:

Message box

Every time you schedule the Log, we are adding information into the SQL database. The history, is plain and simply where this item / artist was scheduled to be played. So, when you run the reports to see why a particular song seems to be coming around quite often, it uses this history.

That station I was telling you about, had ignored this message every time they opened and used Autotrack. This meant that they had 4 years' worth of histories for each item!

FANTASTIC, yes you can see over that period how many times it was scheduled, work out its rotations, see how the database has developed, etc.

BUT, as soon as you open a song or link card, it has to read that 4 year period - and display it on the history tab. In that stations case, 208 of these weekly grids need to be read from the database, and then drawn onto the song card, just in case you look at the history.

History grid

So, if we go back and read the first message box again........

  • Do you want scheduling histories and logs up to and including {Insert date} removed?
    If you say "YES", then the history grid will have less information to calculate the Play Count and Average Interval - these might be important to you, but do you really need 4 years' worth?
  • Note: You can have this done automatically by turning this prompt off in the Settings window.
    So no more annoying message box, it'll just keep performing this for you.

As you can see, if you tick the box, you'll get the message! If you don't, you won't!
You can also decide how long to keep those histories for, so if you have a particular need to look further back for your statisticalanalysis, you can!

Ok, good.....we're finished.....right?

Well, no, sorry.

As well as the "Autotrack Histories", the SQL Database also looks after the "Log", the "User Security History", amongst other items.

You can "Shrink" the main SQL databases, that the Broadcast Radio products use. This is a safe process, but as mentioned before, you should perform a backup before you start this. You can also perform this while the station is on air! Something that you could never do with the old "Access Database" used by earlier generation products!

To do this you will need to download and install Microsoft SQL Server Management Studio (which you can do using the link in the 3rd party section on this page). Once you have it installed, simply connect to the SQL instance and you can 'shrink' the database using the tools as pictured above. 

TIP: You can also backup and restore your database from this tool!


If you are not comfortable with this aspect of your maintenance routine, please consult with your engineer, or Broadcast Radio directly.

Everyone feels good after a nice squeeze :-)

by Liam Burke 28 Mar, 2024
In anticipation of the release of SmartSign 3, we are looking back at the history of our screen studio signage system as well as a quick look at what the future holds. SmartSign 1 (well just SmartSign) was originally conceived as a simple ‘tally’ indicator to how real world events such as when microphones are active or a phone is ringing. At the time, we were working on the BR Hardware Service as part of the general Myriad 5 development cycle, and wanted a way to showcase the virtual hardware events the BR Hardware Service introduced. One of the aims was to make the system as cost effective as possible so work began on building an application that would run on Windows IOT on a Raspberry Pi. The Pi was ideal as it included physical hardware I/O built in meaning that SmartSign could use both physical and virtual GPIO and even convert physical inputs to virtual inputs for use in other BR software such as Myriad Logging or other SmartSigns.  We soon started to add other ‘tiles’ to the system to allow clocks, date / time, text, images, RSS feeds and more. SmartSign was released in 2016 and was an instant hit with our customers.
Artists Group Management
by Liam Burke 27 Mar, 2024
Learn how to use Artist Groups to prevent Songs from associated Artists from scheduling close together.
by Peter Jarrett 08 Dec, 2023
The latest feature from Broadcast Radio can really make your station stand out from the competition
by Peter Jarrett 12 May, 2023
Myriad v6 Public Beta testing has been going well... REALLY well!
by Liam Burke 19 Apr, 2022
This smart microphone may be ideal for Myriad Anywhere users.
by Blanca Jonathan 28 Jun, 2021
Image Source: Pexels
by Liam Burke 26 Feb, 2021
We are often asked for recommendations for smaller, low cost mixers for stations that are launching on a tight budget or looking to add additional studio capacity as cost effectively as possible. Type 'stereo mixer' into Google and literally hundreds of options will come up but the vast majority of them are not really suitable for use with Myriad because they do not have enough stereo inputs, are designed for sound mixing or do not offer the basic facilities needed to present a radio show. But there are a few that could be considered as a possible alternative to a full broadcast mixer. The Behringer DX2000USB may be the ideal mixer for smaller stations, as long as they are willing to live the compromises it brings when used in a broadcast radio environment.
by Arran Hodges 04 Dec, 2020
This post was originally posted on Arran's blog https://thisisarran.me/index.php/2020/12/04/the-technical-side-of-a-radio-station/ and is reproduced here by his kind permission. If you have a post you'd like share, please contact us and let us know!
Home Studio Mixer Review For Myriad Anywhere
by Liam Burke 28 Jul, 2020
With the World still struggling to adapt to the 'new normal' of working from home and minimising social contact, more and more stations are using Myriad Anywhere to enable presenters to record Remote Voice Tracks or even prevent live shows from their own home studios. Generally, all you need is a good microphone and a pair of headphones (we recommend a headset if possible) but we are hearing from a number of customers who are looking to create a home studio setup to allow them to get more creative and emulate their studio experience. So we thought we would take a quick look at a couple of home mixer options that work well with both Myriad Anywhere and fully installed Myriad Playout.
by Liam Burke 29 Jun, 2020
Sometimes you want to repeat complete Log hours in your schedule. Under normal circumstances, Myriad Schedule (or AutoTrack) will generate a new Log Hour for every hour of the week. But once you have edited and Voice Tracked an hour, it is sometimes good to be able to re-use that Log Hour elsewhere in your schedule or maybe even on another Station (if you are running more than one. This can be done using the Log.CopyHour Command.
Show More
Share by: