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”

Naming Is Hard

Keep in mind…

Voice of the DBA

I ran across Aaron Bertrand’s naming post recently, which I liked overall. Your team needs to agree how things are named, and be consistent, but I agree that some of the rules I’ve seen put down by people aren’t practical. However I also know that naming things becomes hard, especially over time as your systems evolve and the scale grows.

I’ve run into some strange naming patterns in the last few years that struck me as odd. I grew up in the Hampton Roads area of Virginia, and with a parent selling real estate, I traveled all over the area, often reading a map to navigate. I can rarely remember seeing the same names used over and over, despite the fact this was a relatively populous area.

However when I came to Colorado, I found things to be different. Either the people in charge of naming weren’t creative, or they were…

View original post 264 more words

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”

PASS SQL Saturday in Parma (#sqlsat462) – Second Edition

The 28 of November, PASS SQL Saturday will be held in Parma, in the north of Italy. This year event will be important, due to the new releases of SQL Server 2016.

SQLSAT462_print

Location

Parma University Campus, Computer Science department

Marchio_uni

Continue reading “PASS SQL Saturday in Parma (#sqlsat462) – Second Edition”

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”

SQL Server Security Bulletin MS15-058 Released

A SQL Server security bulletin (MS15-058) was released yesterday (14-Jul-2015).
This update resolves vulnerabilities in Microsoft SQL Server that could allow remote code execution if an authenticated attacker runs a specially crafted query that is designed to execute a virtual function from a wrong address. This leads to a function call to uninitialized memory.
It applies to:
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

If you feel confused about what version is affected, please read the blog post by Aaron Bertrand (an useful matrix here).

The KB is the #3065718, more details here.

 

Stay Tuned! 🙂

SQL Server Infernals – Circle 4: Anarchic Designers

spaghettidba

Infernals

Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is found in Database Design: no good data can exist without constraints.

What they say in Heaven

Constraints define what is acceptable in the database and what does not comply with business rules. In Heaven, where the perfect database runs smoothly, no constraint is overlooked and all the data obeys to the rules of angels:

  • Every column accepts only the data it was meant for, using the appropriate data type
  • Every column that requires a value has a NOT NULL constraint
  • Every column that references a key in a different table has a FOREIGN KEY constraint
  • Every column that must comply with a business rule has a CHECK constraint
  • Every column that must be populated with a predefined value has a DEFAULT constraint
  • Every table has a PRIMARY KEY constraint
  • Every…

View original post 498 more words

SQL Server Infernals – Circle 3: Shaky Typers

spaghettidba

Infernals

Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. It is not just about performance or space usage: the data type is the first constraint on your data and it decides what can be persisted in your columns and what is not acceptable.

Choosing the wrong data type for your columns is a mistake that might make your life as a DBA look like hell.

What they say in Heaven

Guided by angelic spells, the hands that design databases in Heaven always choose the right data type. Database architects always look at the logical schema and ask the right questions about each attribute and they always manage to understand what the attribute is used for and what it will be used for in the future.

What will put you to hell

Choosing the…

View original post 994 more words