We normally run our Power BI Core Skills class as the 2nd day of the week in our 5 day BI Core Skills.
We’ve had extra demand for the Power BI day so we’ve added an extra one in Melbourne on May 10th. Details are here:
Early bird pricing ends April 26th.
2016-03-05
I love it when I get queries that are actually easy to answer.
Today, one of my developer friends asked me if it was better to use BETWEEN or to use >= and <= when filtering for a range of dates.
From a logic perspective, I like the idea that a single predicate expresses your intent rather than needing two predicates to do the same. For example, consider the following two queries:
2016-03-02
Hi Folks,
We’ve taken a fairly long break but now back into the swing for SQL Server 2016 and Power BI.
The first of the new series of shows is a show on the current state of Power BI with Jen Underwood.
You’ll find it here: SQL Down Under Podcast
Enjoy!
Regards,
Greg
2015-12-27
Hi Folks,
Couldn’t make it to Ignite? The team from Microsoft Australia recorded all the sessions and they are online now.
Here are the three sessions that I delivered:
Azure Datacamp Power Hour: NOTE: This event is now closed
Things I Wish Developers Knew About SQL Server: NOTE: This event is now closed
Working With SQL Server Spatial: NOTE: This event is now closed
Enjoy!
2015-12-11
AzureCon is the main #Azure related conference each year, and of course, it’s an online conference.
It’s coming up at the end of this month (September).
It’s time to register to see what ScottGu and the people from the Azure team have to tell us.
NOTE: This event is now closed
2015-09-10
We recently started working with the new Personal Data Management Gateway for Power BI. Overall, we really like it but the error messages in most of Power BI have left much to be desired.
One error that we were encountering made us feel like the service was flaky as it seemed to happen randomly. When we tried to refresh a dataset, we got this error:
The Power BI team came to the rescue and worked out what was happening. Turns out that you cannot currently refresh more than once every 5 minutes. That also includes within 5 minutes of your initial upload. Unfortunately, this is the error returned when you attempt it.
2015-07-14
Hi Folks, on the 5th June (yes that’s Friday next week), I’m running a Data Camp day for the local Microsoft team. It’s being held at Cliftons in the city.
We’ve got four topics for the day:
If you want to get your head around any/all of these, we’d love to see you there. Places are limited but you must register and can do so here: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032627085&Culture=en-AU&community=0
2015-05-25
The team at Microsoft Virtual Academy (MVA) have pushed out some new content that’s relevant to database people.
First, if you’re wondering about using Azure for SQL Server, the Jumpstart for SQL Server in Azure VMs is worth a look. Longer term, I suspect we’ll mostly end up using SQL Server as a platform service (Azure SQL DB) but in the short-term, implementing it in a VM will be more common as it’s probably both easier when migrating existing applications and a little more familiar to most.
2015-05-24
I find many of the MVA courses great for quickly getting across concepts or areas that I haven’t worked with before.
This month, the local MVP program has asked me to highlight the following MVA courses. The first two in particular look useful for SQL folk. The third one provides good background:
Azure IaaS Technical Fundamentals
Deep Dive into Networking Storage and Disaster Recovery Scenarios
Embracing Open Source Technologies to Accelerate and Scale Solutions
2015-04-18
Hi Folks, we’ve been working hard on a new Azure Machine Learning course.
Come and spend a solid day finding out why Azure Machine Learning should be part of your arsenal.
Our first Melbourne offering of Azure Machine Learning Core Skills is 31st July. I’d love to see you there:
2015-04-15
