Category: PASS

Here is my presentation about database modeling on SQL Saturday #738 that was held in Petah Tiqwa, Israel at April 26, 2018.
Database modeling in practice

Yesterday I’ve presented a session about SQL Server storage internals and DML operations on the SQL Saturday event that traditionally was held in Krasnodar, Russia. I was pleased that a lot of attendees were really interested on my topic.

Here are the presentation

Andrey Zavadskiy – Storage and DML operations (pdf)

and demo code collected in SQL Server Management Studio solution

Storage and DML operations (zip)

The 5th online conference 24 Hours Of PASS Russian Edition has started today. My session was the first in the list. I’ve talked a lot about transaction log, its internals and troubleshooting.

Here are my slide deck and demo code for my session:
Slide deck – Transaction log and troubleshooting (Russian)
Demo – Transaction-log

Also you can watch video from SQL PASS Russian Virtual Chapter channel
Direct link https://www.youtube.com/watch?v=WnLupnOoPXw (in Russian)

Last Saturday, October 17, 2015, I’ve presented a session about developing SQL Server databases with Visual Studio. Here you can download the presentation, demo code and demo solution with some valuable examples of database unit testing.

Presentation (pdf)

Demo code and solution (zip)

Special thanks to Alexander Speshilov for asking a lot of questions and sharing his experience in working with SQL Server Data Tools.

Here are the side deck and demo projects from my online session “Unit testing with SQL Server Data Tools” that I presented for the Global Hebrew Virtual Chapter at August 17, 2015.

Presentation (pdf)

Demo projects (zip)

Another great news comes today. I was selected as a speaker in Gothenburg event (to be frankly, I prefer the native name of the city Göteborg). My session is about a SQL Server transaction log internals and how to troubleshoot issues you might face when you’re not paying enough attention to transaction log.

It seems it would be a very good time for me – a week in Europe from SQLSat Oslo to SQLSat Göteborg. I hope it will be cool!

Here is the full schedule of the conference http://www.sqlsaturday.com/433/sessions/schedule.aspx

If you want to get a free training, deep your knowledge or ask a difficult question, you’re welcome. And don’t forget to invite your colleagues/co-workers/friends/spouse/children 🙂 who are interesting in SQL Server to join us in first-ever SQLSaturday in Sweden!

I’m very proud to be a part of this great event in Norway. That’s my lucky chance to visit Oslo, meet the colleagues and talk about SQL Server. I’ll present a session about transaction log and how to troubleshoot the issues that can cause database to stop or degrade its productivity.

Here you can find more information about SQLSat Oslo 2015

My slide deck and demos that I used in my session “Offline Database Development and Unit Testing with SSDT” on 24 Hours of PASS: Growing Our Community can be downloaded from PASS site. Click here.

Also you can download all these files directly from my blog:

• Presentation (pdf)
• ClientsDB_create_script
• ClientsDBTesting project

An exciting event will start tomorrow June, 24 at 12:00 GMT. We are growing our community!

24 live sessions will be delivered by speakers and experts from the PASS community. Just look at the schedule, choose the sessions you want to hear and register as quickly as you can. There’s a limit for 1000 attendees for each webcast.