MSSQL

Speaking at DevConf.cz 2017 about ASP.NET Core

This Saturday I will be speaker at DevConf.cz 2017 event and I will speak about ASP.NET Core debvelopment on Linux. It’s my first time to speak at some Linux conference and I’m very excited to see how things go there. I’m not complete noobie on Linux but still I cannot consider myself as professional. Still I found Linux to be interesting platform and I’m clad that also Microsoft supports it. Here’s the overview of my presentation.

TemperatureStation: My Windows 10 IoT Core solution on Github

I published to Github sample temperature measuring solution that runs on Windows 10 IoT Core and that is built on Visual Studio. Source code with basic documentation is available too. This demo project is there to give some starting point to those who are visiting my Brewing Eisbock with Raspberry PI and Windows 10 IoT sessions in different conferences.

Speaking at CodeCamp Cluj 2016

There will be Romanian CodeCamp event at Cluj on 19.11.2016 and I’m invited there with my Windows IoT Core and eisbock brewing presentation. Talking about building real-life solutions is one of my favorite things and for CodeCamp Cluj I have prepared nice presentation that makes attendees think about good things like beer and be more innovative when thinking about things around us that can be automated.

Making Entity Framework 7 and Azure Data Sync work together

I have local database where I insert some data and I want this data to be available also in cloud. As a lazy guy I don’t want to synchronize data manually. After setting up local and cloud databases I activated Azure Data Sync to just find out that it conflicts with EF7 insert and update queries. As I don’t have many tables and my database is pretty small I invented simple workaround.

Using database unit tests in Visual Studio

Stored procedures in SQL Server database can be unit tested using Visual Studio database unit tests. It may seem as simple thing to do at first but when you start writing tests then you will find out it’s more complex task to do then expected. In this posting I will introduce database testing with Visual Studio tools.

Using Visual Studio database projects in real life

Visual Studio database projects are good to support software development. I have successfully used database projects for years and I think it’s time to share my experiences also to global developers audience. In this posting I will introduce you how to effectively use database projects so developers are working with up-to-date schema and test data all the time.

Creating dynamic pivot reports on SQL Server

In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic – admins can define new states and save them to states table. This means that I cannot hardcode names of states to queries. Instead I need dynamic pivots. In this posting I will show you how to write reporting procedures that offer dynamic pivoting capabilities.

Previous Posts