Automatically link databases to Red Gate SQL Source Control

For the ones that have many databases to keep under source control, it can be really useful to speed up the link-to-source-control process. The only way we have now is to use the GUI provided by Red Gate SQL Source Control. Actually, there’s a github project called SOCAutoLinkDatabases by Matthew Flat, a Red Gate engineer, but, unfortunately it works only on a shared database model (centralised) in TFS. Let’s see how to manage the link using Working Folder (which is also good for many SCM) and dedicated database model (distributed).

Continue reading “Automatically link databases to Red Gate SQL Source Control”

Agile@School – 7th episode

In the 6th episode’s post we’ve spoken about the concept of “sprint failure” and “start again with a new spirit”. Now I can say that we have reached our goals and the application is up and running, ready to be shown during the exam sessions.

We are proud to introduce online Students’ Yearbook!

Continue reading “Agile@School – 7th episode”

Agile@School – episode 5

It’s time to review the work done.

The web application the students are working on is reaching its end, speaking about development. It’s not so good to see, we know it, but starting from this sprint, we will apply some graphical stuff and we’ll be ready to present the tool to the “board”.

Continue reading “Agile@School – episode 5”

Agile@School – episode 3

Agile@School project is growing and finally we’re reaching the most important part of the iteration.

In this third episode we played the planning poker game on a round table (which appears like a poker session at a first sight actually 🙂 ) and the students decided to skip the coffee break! You know how is really difficult for them to be focused.

Continue reading “Agile@School – episode 3”

Agile@School – episode 2

In this post, we’ve introduced the Agile@School project, a new way for managing school projects.

The second “episode” I’ve added an actor, Gabriele, a student which will be the scrum master. We’ve achieved the real number of team members, which is 9 and we’ve understood also the interests of each member. The final goal is to create a team and to manage the teachers idea of project for the final exams.
Scrum master
Gabriele, will be the scrum master. Since I’ll be the coach, I need also, let’s say, an “external” person. He’ll help me in separating the heavy amount of work and in facilitating the team.
The project
The project is based on a product called “Ex-students yearbook“. It’s a database of students which studied in the school, which provides also a web user interface for both the front end and the administration back end.
The team
We’ve got 9 members. Now, is time to understand the skill of each team member.
Next time, likely this saturday, we’ll go deeper and we’ll start to add user stories and PBIs on VSTS. We’ve got already the document with specifications. For each story we will define the Personas and after this step, we’ll start to play to Planning Poker.
In the end we want:
– Get VSTS with PBIs in Product Backlog
– Make PBIs with efforts
– Get the first Sprint backlog
– Get the list of tasks for the first sprint
– Get the capacity and the roles in the team
– Define the sprint duration and ceremonies schedule
Then, the students will start to coding!
Stay Tuned! 

Agile@School – A new way for managing school projects

Last Saturday, I’ve shown the Agile@School project at ITSOS Fornovo Taro, the school in which I’ve studied for five years, just before starting to work as a junior developer.

ITSOS has been (and this is true right now) at the forefront of computer technology and now, thanks to the new “technology course”, the project becomes really interesting. During the year, indeed, the teachers have spoken about development methodologies, both for Agile and Waterfall approaches. This sounds great, especially in Italy.

Continue reading “Agile@School – A new way for managing school projects”

How to manage SQL Server security with SQL Source Control

One of the most common issue you can find when source controlling the database is about the security. How to manage the users and the related permissions?

If you use to apply permission to users and to assign users to the database, this can be a problem, especially when you are in the deployment phase (or else when getting latest versions from the source control). Let’s see these two scenarios:

Continue reading “How to manage SQL Server security with SQL Source Control”