Level 300

April 1, 2020

Kick Start! SQL Server 2017/2019 Performance Tips and Tricks

Speaker: Pinal Dave Level: 300 Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 has introduced many new features. This session is carefully crafted to help overcome the beginner’s inertia for DBAs who have been using SQL Server […]

Read More
April 1, 2020

Poor Man’s SQL Server Job Monitoring with R

Speaker: Thomas Hütter Level: 300 Of course SQL Server (Management or Azure Data Studio) offers you a list view of the agent job history. But wouldn’t it be nice to have a graphical overview of job durations and how they develop? This session is for DBAs and R newbies alike: In one hour we’ll develop […]

Read More
April 1, 2020

Can I Join You?, One Table Asked the Other

Speaker: Thomas Hütter Level: 300 So you have your database beautifully set up according to Codd. What do you need when you have to retrieve data from related tables? Most probably a JOIN operator, but which one? From LEFT to RIGHT, when is it INNER and when OUTER? Is a CROSS JOIN something NATURAL? And […]

Read More
April 1, 2020

Advanced Analytics with Power BI

Speaker: Andrea Martorana Tusa Level: 300 Power BI makes advanced analytics handy for business users, allowing stakeholders to extract knowledge and insights from data, to solve business problems and make decisions. This session will introduce to the advanced analytics features of Power BI, showcasing some real word areas of application: forecasting, predictive analytics, data streaming […]

Read More
April 1, 2020

Tune Your PowerBI

Speaker: Tomasz Gołaszewski Level: 300 At first glance, PowerBI is strongly limited in terms of performance tuning by end user. That’s why it is really important to know how engine works, how acts in different situations and how to build a model within in the most efficient way. During this session we will smash few […]

Read More
  • 1
  • 2

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close