Keynote
[MP4] [0:50:38] [2017/08/07]SQLDay 2017 keynote.
Czy DBA moe odnale si w wiecie DevOps?
[MP4] [0:58:04] [2017/08/07]Obowiązki dzisiejszego DBA to zadania typowo operacyjne. Natomiast świat IT coraz bardziej zmierza w agilowe zarządzanie procesem wytwórczym i utrzymaniowym oprogramowania. Na końcu są jednak bazy…
The Log, the whole Log and nothing but the Log
[MP4] [0:57:58] [2017/08/07]This session focuses on the transaction log. It begins with a quick glance on what goes on in and around the log in the different recovery modes. You'll then get a deep dive into log sequence numbers,…
Gems to help you troubleshoot query performance
[MP4] [1:04:04] [2017/08/07]BPCheck came to be back in 2011, as a way to empower Microsoft support engineers onsite with customers to gain insight on best practices not being followed, and evolved to include performance based…
Investigate TempDB like Sherlock Holmes
[MP4] [0:50:02] [2017/08/07]The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session, you will learn to…
Replikacja danych kto z kim, dla kogo, dlaczego i po co?
[MP4] [0:59:27] [2017/08/07]Podczas sesji zrobimy przegląd wszystkich rodzajów replikacji w SQL Server i dowiemy się jakie zasadnicze różnice są pomiędzy nimi oraz kiedy którą replikację warto stosować. Oprócz przykładów…
SSISDB i SSIS catalog od rodka
[MP4] [0:59:42] [2017/08/07]Możliwość publikowania całych projektów SSIS zamiast pojedynczych pakietów jest ogromnym ułatwieniem dla projektantów procesów ETL w SQL Server Integration Services. Wiele osób zapomina jednak, ze…
Kerberos for BI
[MP4] [1:02:52] [2017/08/07]Have you ever seen this message "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON"? Have you ever witnessed Kerberos mentioned in a conversation – or in a forum – and seen developers…
Blocking: How to Find and Fight LCK* Waits
[MP4] [0:58:28] [2017/08/07]When you're facing lock waits and blocked queries, it's tempting to just slather NOLOCK all over the queries. Thing is, this won't necessarily fix it, and there are much better ways to track,…
Introduction to Azure Analysis Services
[MP4] [0:54:55] [2017/08/07]With the release of Azure Analysis Services we have, at long last, got a crucial piece of the Microsoft BI stack available in the cloud. Azure Analysis Services is a SaaS version of Analysis Services,…
Enhancements that will make your SQL Server roar
[MP4] [1:02:59] [2017/08/07]Are you a: Production DBA that wants to know which new xEvents and DMVs/DMFs are available to get further insights into SQL Server operations?Production DBA that needs to troubleshoot a performance…
Watch Brent Tune Queries
[MP4] [0:58:38] [2017/08/07]Ever wonder how somebody else does it? Watch over the virtual shoulder of Microsoft Certified Master Brent Ozar as he walks you through the Stack Overflow public database export, shows you two…
What are all those Azure* and Power* services and why do I want them?
[MP4] [1:00:43] [2017/08/07]Still think the cloud is about VMs? Don't know your Power Apps from your Power BI, Flow, etc.? Developers and DBAs don't understand what is available today. In this rapid-fire session, Greg will…
When things go wrong Error Handling in SQL Server
[MP4] [0:59:24] [2017/08/07]In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server…
Granting Permissions through Stored Procedures
[MP4] [0:59:34] [2017/08/07]You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. However, this does not work with dynamic SQL.…
Things I Wish Developers Knew About SQL Server
[MP4] [1:02:32] [2017/08/07]SQL Server is a very forgiving product. It does an awesome job of dealing with what are often unreasonable demands placed on it by applications. In this session, Greg will describe the biggest issues…
Arsena programisty T-SQL A.D. 2017
[MP4] [1:02:35] [2017/08/07]W dobie SQL Server 2016 (i dodatku Service Pack 1 do tej wersji systemu) programista baz danych ma do swojej dyspozycji pokaźny arsenał składni języka T-SQL. Celem prezentacji będzie pokazanie…
Query Execution: Expectation Reality
[MP4] [0:57:01] [2017/08/07]Yes, this is a very common problem: you expect something, but reality is a bit different. You expect that query will run 1 sec, but it runs (Oh, my God!) 1 hour. You expect that your query will…
Proaktywny monitoring SQL Server
[MP4] [0:55:27] [2017/08/07]Wszystkie usługi SQL Server generują mnóstwo danych o swoim działaniu. Kiedy standardowe narzędzia typu DMV, ExecutionLog3 czy Extended Events to za mało, czas zaprząc do pracy nowe zabawki: PowerBI,…
SQL Server v.Next dla systemu Linux
[MP4] [0:58:31] [2017/08/07]Microsoft zaskoczył w zeszłym roku wielu ludzi ogłaszając, że SQL Server zostanie wydany na platformę Linux, No i stało się – pojawiają się kolejne wersje przedprodukcyjne, a wersja finalna jest coraz…
Od danych do inteligentnych programów w 60 minut z Microsoft R Server
[MP4] [0:58:58] [2017/08/07]Zaawansowana analiza danych i język R to już synonimy. Siłą tego języka jest dziesięć tysięcy specjalistycznych, ogólnodostępnych bibliotek i ogromna, zrzeszająca analityków, naukowców i ,…
Logical Data Warehousing and Data Virtualization in Action
[MP4] [0:58:56] [2017/08/07]During the talk we will cover the following topics: Introduction to Logical Data Warehouse (LDW) and Data Virtualization (DV) concepts vs conventional data warehousing and ETLHow Data Virtualization…
Stretching SQL Server Failover Clustered Instances & Availability Groups to a Disaster Recovery Site
[MP4] [1:04:01] [2017/08/07]Dealing with SQL Server Failover Clustered Instances and Availability Group for local high availability is already complicated with many external dependencies such as the network and the Windows…
Identifying and Fixing Parameter Sniffing
[MP4] [0:51:52] [2017/08/07]You swear nothing changed – but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the…