Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Data Science
How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a "from the field" real project feedback.This session will explore all the possibilities offered by Power Bi Report server: What are the difference with the classical SQL Server Report Server ? What is the difference with Power BI Service ? What kind of data sources are used ? How to manage the refresh ? What infrastructure is needed to make it working ? How to manage the authentication from the data source to the report ?
Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Database Admin
Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Development
But, what to expect exactly from a graph database? How to query it? Is SQL Server fully featured compared to other products? In this session we answer these questions. We start illustrating the concepts behind the model; how relationships are handled and what are the common patterns and issues for a graph. What are the data connections a graph can easily represent. Then we compare the semantic model with SQL Server to discover how to apply it to real world. We analyze some case study: pattern matching, path finding, aggregation, ranking … For each of them we show how to use standard T-SQL and how to rewrite the query using graph objects. What is the benefit of reformulate our queries in terms of clearness and performances, what is already available in order to consider SQL Server a valuable player.
Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
Being at SQL Saturday, we'll focus on SQL Server Reports, but the methodology is system-agnostic and will enable you to create a monitoring report for anything.
In the first part of the session, you'll learn why we're using PowerBI for such task and what are the limitations, explaining the PowerBI basics, architecture and components.
In the second part, we'll analyze 5 examples of ready-to-go and license free monitoring reports tailored for SQL Server:
This will give you both some reports that you can start to use right now, and the inspiration to build your own.
Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Database Admin
Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Cloud
How can the AI make my BI application smarter? Everybody is talking about AI but what can you do with it today? Currently there are tools like the Cognitive Services, Azure ML or Azure Bot Framework, which can help in the classic ETL process to prepare or enrich data. Examples are the analysis of large data streams from the IoT area, how can I improve my demand planning of a call center or the analysis of social media regarding trends. If you already have your BI application in the cloud, Azure Data Factory, Logic App or Azure Stream Analytics would be the right components for an AI extension.
Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Database Admin
Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Development
SQL Server 2019, per esempio, introdurrà per la prima volta con i nuovi Big Data Cluster il supporto nativo ad Apache Spark, rendendo concreta la convivenza tra il carico di lavoro tipico di un engine relazionale e il calcolo distribuito.
Proveniendo da un ambiente SQL, l'approccio ad Apache Spark tramite il suo dialetto Spark SQL può sembrare molto naturale e poco ostico. La sensazione di "sentirsi a casa", però, non deve far dimenticare che l'engine sottostante ragiona in modo molto diverso da quello a cui siamo abituati.
In questa sessione proveremo ad avvicinarci ad Apache Spark partendo dalle sue basi, così da capire come ragiona e conoscerlo per affrontarlo al meglio.
Event Date: 23-11-2019 - Session time: 11:00:00 - Track: DevOps
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, DbaTools and many more) to collect important performance metrics, analyze the data they collect, set up alert for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Data Science
For projects carrying a simple or well kown problem we can find a lot of ready-made solutions, but this extremne easy to use could be one of our best enemy when facing with specific custom problems. With this session we will cover how to apply best practices in configurin ML but much more, do we reaaly need it always? The second part will cover vulnerabilities of ML discovering how easy could be to fool a neural network by some techinques (Like pixel attack) and their implication in projects that requires no security issues.
Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Cloud
In questa sessione vedremo in che modo sfruttare l'estensibilità delle Azure Functions per implementare Trigger, Binding o supportare i nostri servizi per l'accesso a SQL Server.
Event Date: 23-11-2019 - Session time: 12:10:00 - Track: DevOps
Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Database Admin
Negli anni sono state fatte parecchie ottimizzazioni dell’architettura del tempdb. In questa sessione verranno illustrate tutte le configurazioni, ottimizzazioni e best practices riguardanti il tempdb da SQL Server 2005 ad oggi.
Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Database Admin
Simplifying the performance troubleshooting by analysing query plans, runtime statistics and query history captured (all by using the Query store) we will be combining the data from extended events. With both powerful system insights, we will add the statistical abilities of Microsoft R server and create advanced statistical analysis (clustering type of errors occurring, discriminating the events and reducing the complexity of gathered information). Further more, we will be adding also predictive models for specific events (disk IO, size of temp db) or queries.
Session will cover demos and use cases, especially which statistical approaches and cases can help you enhance the monitoring and predicting next possible event.
Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Cloud
Let's see what are the main topic to consider during the design process of this kind of systems.
Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Database Admin
The creation of a new index on a large table, as we will see, could require a long time to complete, could take locks for the entire process and occupy a lot of disk space. In several situations hypothetical indexes can help, although, in order to create and use them, we have to rely on a couple of undocumented features. In this session we are going to give all the known details of these features and apply them in examples and practical situations.
Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Data Science
Event Date: 23-11-2019 - Session time: 16:00:00 - Track: DevOps
Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Database Admin
In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.
We will cover both Basic Availability Groups (BAGs) and full deployments, and also cover their use in Windows and Linux environments as well as look at the new SQL Server 2019 availability group support on containers in a Kubernetes cluster.
If you want to finally get to grips with SQL Server Always On Availability Groups, then this is the session for you!
Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Analytics and Visualization
Quali sono i concetti e come poterli affrontare con i miglioramenti aggiunti a Polybase presenti in Sql Server 2019 è lo scopo di questa sessione
Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Cloud
Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Development
Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Database Admin
Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Database Admin
Questa sessione ne illustra i concetti e l'evoluzione delle tecniche e degli strumenti disponibili nella piattaforma SQL Server, con un particolare accento sulle novitrà introdotte dalla versione 2019
Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Analytics and Visualization