T-SQL jaki jest każdy widzi. Nie wygląda na przesadnie skomplikowany, w codziennej pracy korzystamy z niego dosyć swobodnie – SELECT, INSERT, czy inny MERGE nie robią na nas wrażenia, a funkcje i procedury są jak fiordy – już oswojone i niemal jedzą nam z ręki. Czasem jednak jakiś wewnętrzny głos podpowiada, że gdzieś tam, hen…
Nadchodzi czas sztucznej inteligencji. Mamy do dyspozycji coraz lepsze narzędzia, skuteczniejsze algorytmy oraz rosnącą moc obliczeniową. Szybkimi krokami zbliża się rewolucja, która zmieni sposób naszej pracy i rozwiązywania problemów. Nie nastąpi to jutro czy za rok, ale przygotowania warto rozpocząć już teraz. Spotkanie z Łukaszem i Grzegorzem to świetna okazja aby poznać najważniejsze algorytmy i…
Nowadays the DevOps is the topic number one in many industries and companies. However, in some case, you see that the code repository is or will be the most important topic. The number of tasks could be overwhelming at first glance, however, there is no other way – you have to use the new tools…
Learn practical Columnstore Indexes tips and tricks such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode. With a nod to each…
We all know that the answer to almost any SQL Server tuning question is “It Depends!” In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of…
This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017, and some of the planned…
Data warehouse is a crucial part of every Business Intelligence system — its design and implementation determine if stored data can be used to answer business questions quickly and efficiently. Because data warehouses serve a different purpose than operational databases (OLTP), their structure is also different, which means that to create a successful data warehouse…
