Open Tech Calendar

Glasgow Data UG October virtual event - SSIS and BIML with Ben

18:30 - Hello, introductions, news, and chat
19:00 -Ben Weissman - Let's build SSIS packaged with Biml - live!
Ben Weissman
Ben has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field.


@bweissman linkedin.com/in/weissmanben/ biml-blog.de (blog)

Let's build SSIS packaged with Biml - live!
You have heard about Biml? Maybe even seen a session about it before but still have doubts, how easy you can make something useful out of it? In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos! Everything is happening live! Starting with a blank staging database, we’re going to end up with a complete solution over the course of this session, to prove that it is not just easy to adapt existing Biml code but also to start from scratch and still be successful very quick!

Let’s see, how that goes…

https://www.eventbrite.co.uk/e/glasgow-data-ug-october-virtual-event-ssis-and-biml-with-ben-tickets-117658364335

https://www.eventbrite.co.uk/e/glasgow-data-ug-october-virtual-event-ssis-and-biml-with-ben-tickets-117658364335

Thu 8th Oct 2020 6:30pm (Europe/London)

Thu 8th Oct 2020 8:30pm (Europe/London)

changed

Europe/London

Yes

No

New Year, new name. Glasgow Data User group's first meetup

For our first meeting we have will the pleasure of John McCormack speaking to us

TitleThe Zero Budget DBA | SQL Community has got your back

Description

So your company has no budget for fancy 3rd party tools. Don’t worry, the SQL community has got your back.

It’s hard to believe how many free tools are available to data professionals. It’s even more amazing just how good these tools are. In this talk, I discuss some of the tools I couldn’t live without that are free to use and developed by members of the SQL Community. I’ll talk about how you can use them to make your job easier and how to convince your boss that they are safe to use.

John's session will be followed by Pizza and a discussion on suggestions for future session content

https://www.eventbrite.co.uk/e/first-meeting-of-glasgow-data-user-group-tickets-91297773097

https://www.eventbrite.co.uk/e/first-meeting-of-glasgow-data-user-group-tickets-91297773097

Thu 13th Feb 2020 6:30pm (Europe/London)

Thu 13th Feb 2020 9:30pm (Europe/London)

changed

Europe/London

changed

No

Yes

Statement Execution and the Plan Cache by Kimberly Tripp

We are delighted to have Kimberly Tripp of SQL Skills speaking to us this month, on Statement Execution and the Plan Cache

Kimberly will discuss the impact on caching / performance of different methods of statement execution. Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the best way to request data so that stable requests are cached and unstable requests are not (giving you the most optimal performance).

Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Pizza & refreshments will be provided courtesy of our sponsors

https://www.meetup.com/Glasgow-SQL-User-Group/events/248201914/

https://www.meetup.com/Glasgow-SQL-User-Group/events/248201914/

Thu 28th Jun 2018 6:00pm (Europe/London)

Thu 28th Jun 2018 8:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

R and Data Science with Steph Locke from Locke data

https://www.eventbrite.co.uk/e/r-and-data-science-with-steph-locke-from-locke-data-tickets-42227202700

https://www.eventbrite.co.uk/e/r-and-data-science-with-steph-locke-from-locke-data-tickets-42227202700

Thu 24th May 2018 6:00pm (Europe/London)

Thu 24th May 2018 9:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

Using a gateway to leverage on-premises data in Power BI with Adam Saxton

In this session, we will look at how the On-Premises Data Gateway works, and how to deploy a gateway in your environment. We also look at the latest features of the gateway including high availability and Kerberos SSO with DirectQuery. Throw in some common issues that customers have and a look at some ways you can troubleshoot the gateway.

Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft working with customers to help adopt Power BI. He is based in Texas, and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.

https://sqlglasgow.co.uk/2018/02/15/event-using-a-gateway-to-leverage-on-premises-data-in-power-bi-with-adam-saxton/

https://www.meetup.com/Glasgow-SQL-User-Group/events/243485820/

Thu 22nd Mar 2018 6:00pm (Europe/London)

Thu 22nd Mar 2018 8:30pm (Europe/London)

changed

Europe/London

changed

No

Yes

Tabular Automation With TMSL and PowerShell

This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.

Pizza & refreshments will be provided courtesy of our sponsors

https://www.meetup.com/Glasgow-SQL-User-Group/events/246780812/

http://bit.ly/2BexpCF

Thu 15th Feb 2018 6:00pm (Europe/London)

Thu 15th Feb 2018 8:30pm (Europe/London)

changed

Europe/London

changed

No

Yes

Data Warehousing Deep Dive & Git Source Control Intro

This month we'll be hosting 2 local speakers!

18:00 - Networking & Coffee
18:15 - Data Warehousing Deep Dive - Ian Mitchell
19:00 - Break for Pizza & Networking
19:30 - Git Intro - Paul Broadwith
20:15 - Networking / Wrap Up

Pizza & refreshments will be provided courtesy of our sponsors

https://www.meetup.com/Glasgow-SQL-User-Group/events/246606838/

http://bit.ly/2hYAIC8

Thu 18th Jan 2018 6:00pm (Europe/London)

Thu 18th Jan 2018 8:30pm (Europe/London)

changed

Europe/London

changed

No

Yes

Stored Procedure Optimization Techniques - Kimberly L. Tripp of SQL Skills

Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).

https://sqlglasgow.co.uk

https://www.meetup.com/Glasgow-SQL-Server-Meetup/events/242228870/

Thu 21st Sep 2017 6:00pm (Europe/London)

Thu 21st Sep 2017 8:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

https://www.eventbrite.co.uk/e/sql-gla-2017-tickets-36853075541

SQL GLA Event

SQLGLA is a training & networking event for data professionals & the first of its kind in Glasgow! 4 Microsoft MVPs will gather in Glasgow for a "not to be missed" afternoon of great sessions covering Azure, PowerShell & SQL Server. This event is organised by the Glasgow SQL User Group, who meet monthly to share & learn from fellow data professionals & community leaders! Check out details of upcoming meets here: https://SQLGlasgow.co.uk

http://sqlglasgow.co.uk/2017/08/08/sql-gla-2017/

http://bit.ly/sqlgla

Fri 10th Nov 2017 1:00pm (Europe/London)

Fri 10th Nov 2017 6:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

Lightning Talks

Our next meeting will be in August, after a summer break to enjoy the sunshine…..

We will be hosting an hour of short talks with speakers from our local community!

Lightning talks are a great way to give back to the community & get involved with presenting. We have a good selection of topics & speakers so far & we’ll update this post with details soon!

Make sure you sign up for free on our Meetup page so we have enough seats ready!

PS. There’s still room for 1 more speaker. Just 5-10mins on any SQL topic you like at any skill level and you’ll be in the raffle to win RedGate prizes!

https://sqlglasgow.co.uk/2017/07/07/event-lightning-talks/

https://www.meetup.com/Glasgow-SQL-Server-Meetup/events/241396980/

Tue 22nd Aug 2017 6:00pm (Europe/London)

Tue 22nd Aug 2017 8:00pm (Europe/London)

changed

Europe/London

changed

No

Yes