Week 5 update:
It was another full house yesterday with 17 kids and 4 parents attending the course. #sqlfamily #microsoftnz
The first 20 minutes were spent in solving issues with questions like --
- 'I created a table but I cannot see it'
- 'I am getting a syntax error'
After this, when I did the recap of what happened last week, I was pleased to see most of the kids eagerly answering my questions regarding update and delete statements. They were keen to discuss some of the SQL functions I covered There was a bit of difficulty in understanding the substring function. But finally everyone understood this function.
One of them wrote a substring function by passing her name as the first argument instead of the field name and tried to return a substring of her name which was quite impressive.
Tuesday, August 07, 2018
Yesterday I have concluded the 12 weeks databases and data visualisation classes by running a #powerbi data visualisation competition for...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...