this post was on my list for quite some time now, but I gave my post last week
about the Technical
Preview for Power BI in SSRS priority because of the "hotness" of
the topic. So without further ado, here's my SQLSatHolland write-up.
time of year again: it was SQLSaturday in the Netherlands, a.k.a.
always nice to meet up with SQLFamily, (Twitter) friends/old colleagues and new
I also volunteered for the first time by being a timekeeper for the speakers
and making sure the session evaluation forms were distributed before the
sessions started and collecting them at the end of the session. It was a good
and fun experience and I will try to keep giving back more to the community
where I can.
down some notes of the following sessions:
If a machine can learn, why can't YOU learn Azure
Machine Learning? by André Melancia (t)
an introduction into AML by André where he started out with some theory and
explained what ML is not and the difference with AI. We learned how to create a
free Azure subscription, set up a ML workspace and start using ML Studio, which
is very much alike the Integration Services graphics of connecting processes
through intermediate steps using arrows. He then walked us through the demo of
creating our first model and experiment in ML.
Using PowerShell for SSIS by Joost van Rossum
used the first few minutes to explain what PowerShell (PS) is and goes right
into the demo's after that. He even ignores the best practice of not typing in
a demo, but all goes well fortunately :-) He showed us some neat Star Wars
"song" of PS-beeps and also explains what you can actually use PS
for: a.o. deploying IsPacs and environments, download packages from the
catalog, search within multiple packages/projects and setting authorization.
Azure SQL Data Warehouse by James
starts with explaining what SQL DW is and is not. Analytics, aggregates and
large data volumes are the key words when you want to use SQL DW. When NOT to
use it: RBAR-processing,
OLTP, incompatible formats like JSON and XML. You pay for the data you store
and the compute you provision. You can choose between Hash and Round Robin
where you have to take into account that the distribution key is read only.
Continuous Integration and the Data Warehouse by
John Tunicliff (b|t)
watch (a shorter version of) this session recorded at an earlier conference on YouTube. John talks
about the problems why CI is still not a basic part of database development,
the main point being the data in the database. TeamCity Build Server,
PowerShell and psake is mentioned also for implementing CI, all with different
use cases. Another key point to CI is a test framework, e.g. NUnit BI which is
an open source framework to test BI solutions. A best practice when using SSDT
for database design is not to upgrade projects, but to start over with a clean
import and transfer over the pre- and post-deploy scripts.
Q&A BI with Joost van Rossum, Jan Pieter
Posthuma (b|t) en Remko de Boer
Q&A sessions were a try-out to see if we liked them and they could be a
succes. Our BI session was mostly questions to the speakers but sometimes
turned out to be a discussion between several attendees and speakers. It was
really an open hour, and I really enjoyed it. Questions ranged from performance
of Azure, Power BI, the new MS Certification paths (which I wrote about here)
and the Master Data Services session from Remko, which was a very good session
I heared from several people.
Introducing the SQL Server 2016 Query Store by
Enrico van de Laar (b|t)
actually attend this session, but rumors say it was an exciting one so I have
to share it with you. Let's start with some pictures, they say more…
started when he was about to begin with his session:
heard from a lot of people (and also from Enrico himself), is that the session
still was great and he turned it into a Q&A. He even turned to the
whiteboard to get the picture across! Well done for the professional approach
and for thinking in solutions when this happened.
want to know more about one of the sessions listed above or are just interested
in any of the other sessions of SQLSatHolland, the session materials can be
found at the SQL Saturday website,
although at the time of writing not all materials have been added to the site.
I hope to
also see you next year at SQLSatHolland!