On June 22 a delegation of fourteen Koherians went to Lingen in Germany to attend the event SQLGrillen 2018. Colleague Randi Vertongen joined the club. Read his report of a day full of databases, bratwurst and beer.
Many colleagues and I went to SQL Grillen last week. It was in my opinion the perfect balance between learning and fun. 6 sessions back to back is not to be underestimated, it’s not only about the BBQ and booze ;).
The sessions
First session I attended was statistics behind the curtain by Uwe Ricken, He was handed a beer by the organizators and off he went. It was a nice refreshing session on statistics, with some good examples on some common statistic pitfalls when designing queries. And what to look out for in your production environment.
The next session was a newcomer session on Recursive Cte’s: “Recursive CTEs – cursing again and again?” We actually went to that session since a colleague had issues with designing a recursive CTE to get information from top to bottom, but also include the parents of all the childs referenced.We came to the conclusion that that recursive cte design was probably not going to end wel… .
The last session before lunch was “Self Healing” Query execution in SQL 2017 by Christina Leo. The start was good and clear cut. Unfortunately one demo on the “adaptive query processing” did not work, which made the session a bit more “all over the place”. I still liked the presenter’s presentation style and the new upcoming features look very cool.
After the lunch, I attended DevOps for the DBA by Grant Fritchey. Grant is an experienced presenter, and it showed. A very dynamic and open session on DevOps.
The next session was SQL Containers in the cloud, an intro to running docker in Azure, I was lost trying to follow the code, but it really showed how easy it is to deploy images to azure, and spin up one or more nodes that are running in SQL Server, and a very interesting example why you should enable two factor authentication when using Azure.
The last session I followed was SQL Server Problem Tombola by Stijn Wynants, one of my colleagues.
What else can I say than that it was a very fun, entertaining session, and that I learned a very interesting fact about SQL Server. If you want to find out which fact(s), you will have to attend his session :-)
Fun for the whole (SQL) family
It was all in all a great event, I even entered in a raffle to win a drone (sadly, i did not win)!
I am really hoping to go next year as well!
Cookie | Duration | Description |
---|---|---|
ARRAffinity | session | ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user. |
ARRAffinitySameSite | session | This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie records the user consent for the cookies in the "Advertisement" category. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | CookieYes sets this cookie to record the default button state of the corresponding category and the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | The website's WordPress theme uses this cookie. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | Cloudflare set the cookie to support Cloudflare Bot Management. |
pll_language | 1 year | Polylang sets this cookie to remember the language the user selects when returning to the website and get the language information when unavailable in another way. |
Cookie | Duration | Description |
---|---|---|
_ga | 1 year 1 month 4 days | Google Analytics sets this cookie to calculate visitor, session and campaign data and track site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognise unique visitors. |
_ga_* | 1 year 1 month 4 days | Google Analytics sets this cookie to store and count page views. |
_gat_gtag_UA_* | 1 minute | Google Analytics sets this cookie to store a unique user ID. |
_gid | 1 day | Google Analytics sets this cookie to store information on how visitors use a website while also creating an analytics report of the website's performance. Some of the collected data includes the number of visitors, their source, and the pages they visit anonymously. |
ai_session | 30 minutes | This is a unique anonymous session identifier cookie set by Microsoft Application Insights software to gather statistical usage and telemetry data for apps built on the Azure cloud platform. |
CONSENT | 2 years | YouTube sets this cookie via embedded YouTube videos and registers anonymous statistical data. |
vuid | 1 year 1 month 4 days | Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos on the website. |
Cookie | Duration | Description |
---|---|---|
ai_user | 1 year | Microsoft Azure sets this cookie as a unique user identifier cookie, enabling counting of the number of users accessing the application over time. |
VISITOR_INFO1_LIVE | 5 months 27 days | YouTube sets this cookie to measure bandwidth, determining whether the user gets the new or old player interface. |
YSC | session | Youtube sets this cookie to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt-remote-device-id | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt.innertube::nextId | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
Cookie | Duration | Description |
---|---|---|
WFESessionId | session | No description available. |