Skip to main content

How to kill all user sessions on a DB

Sometimes in SQL you need to delete some rows, delete a Table or the DB. But what if a user is still connected to it. The solution is simple, kill all the sessions on that DB with a simple script: USE master SET NOCOUNT ON DECLARE @DBName varchar(50) DECLARE @spidstr varchar(8000) DECLARE @ConnKilled smallint SET […]

WPF MultiBinding

WPF MultiBinding

In WPF, it’s pretty common to display differenct properties of an object as if there where one. Typycally, I have a User, which contains a FirstName and a LastName and I want them both to be displayed as one. <TextBlock> <TextBlock.Text> <MultiBinding StringFormat=”{}{0} ({1})” > <Binding Path=”User.FirstName”></Binding> <Binding Path=”User.LastName”></Binding> </MultiBinding> </TextBlock.Text> </TextBlock> Enjoy!

Create a simple REST Web Service: Step 3 – Consume the Service

In my previous post we were talking about how to create a REST web service. But now we want to build a client and consume this service. The address was http://localhost/DbUsersApi.php?action=get_user_list and the result was a JSON file: {“user_list”:[{“userid”:”D3B6F994-1DA5-47FB-8A2A-750A65AAB137″,”firstname”:”Joe”,”lastname”:”Bloggs”},{“userid”:”E19F2EC8-62B9-4C88-84DC-E0D6903177E0″,”firstname”:”John”,”lastname”:”Doe”}]} We will use a simple HTML file with Javascript. Consume the service with Javascript: Create a new file […]

Create a simple REST Web Service: Step 2 – PHP Service

In my previous post I was talking about how to install WAMP and create your DataBase. Here we will create a RESTfull web service with PHP. We created our User table with some users in it. Now we want to get this user list in a “universal” way. It means any kind of code could […]

Create a simple REST Web Service: Step 1 – DataBase

Context: Here we want to create a REST Web Service using PHP on a WAMPServer. The messages will be formatted as JSON entities. A Web Service is simply some online methods you can access from any kind of code (C#, Java, Javascript, Python …). RESTful web services are light weight, highly scalable and maintainable and […]

Connect to your Pi with SSH – PuttY

If you just receive your brand new Raspberry Pi, you probably tried already to connect your keyboard, mouse, screen and network cables. (see my post about how to create your SD card with NOOBS) But what if you want your Pi to run but disconnect all those cables and still be able to connect to […]

Initial config for Raspberry Pi

First of all, you can execute this command to set some default parameters: sudo raspi-config In the Boot menu, my advice will be to disable the automatic launch of the desktop environment and the autologin by selecting: Boot Options / B1 Desktop / CLI / B1 Console   But here you have more command lines […]