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”

Naming Is Hard

Keep in mind…

way0utwest's avatarVoice 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! 🙂