Engage IT Services SQL Todo Explorer – our *FIRST RELEASE*!

Engage IT Services SQL Todo Explorer – our *FIRST RELEASE*!

In previous posts, I’ve spent a lot of words speaking about third party add-in for SQL Server Management Studio.

Finally we have developed a new extension! We’re proud to present….

Continue reading

Create C# enum template with SSMS Boost

Create C# enum template with SSMS Boost

I’ve spoken about SSMS Boost in this post and now I’m going to apply one of its feature in order to improve the productivity of my team. Speaking about the database side, a table that contains static data can be used as a foreign key referenced table. In my experience those kind of tables are often mapped to enums in our application layer. Creating that enum can be a tedious operation and sometimes it can be very uncomfortable. With SSMS Boost we can enhance our development experience. Continue reading

Suggestion for SQL Prompt and SQL Test (Red-Gate)

Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous Integration on database development. I evaluated some tools and Red-Gate was my first choice. In this post I’d like to share the suggestions I made on two of the most important tool I’m using atm:

  • SQL Prompt (productivity tool for code formatting, intellisense, code inspection, etc.)

suggestions: TODO highlights. I’d like to improve readability of TODO and HACK comments, like in the following picture:

todo
 For ReSharper user (and Visual Studio ones), this is very familiar.
 
  • SQL Test (addon for SQL Server Management Studio, unit testing utility)

suggestions:

“Expand/Collapse all” for avoiding clicks when you have lots of test procedures

Logical folders for grouping tests logically and not with the strict database schema names
If you think that those suggestions could help us, feel free to vote!
Stay Tuned!

Community Days 2014 – Milan

Italian Community Days 2014 are coming!

The event is totally free!

You fill find:

  • A very good agenda.
  • Three days of tech full immersion, dal 25 al 27 febbraio.
  • Five tracks
  • Sixty speakers!

I’ll present my “database under source control” session. My “mission” is to bring ALM knowledge on database side. I think that this topic is often underestimated.

here is the list of cummunities that will follow the event:

Click here for more info.

So, spread the word! hashtag: #CDays14

What are you waiting for? Subscribe now!

Stay Tuned!

SQL Saturday in Ancona and Verona – English slide decks available for download

You can download the english version of my sessions at SQL Saturdays (on SlideShare):

SQL Saturday 257 in Verona: “Put databases under source control

SQL Saturday 264 in Ancona: “Put databases in ALM backgrounds” (a special thanks to Gian Maria Ricci)

 

Stay Tuned! 🙂

 

SQL Saturday in Verona – Slide deck of “Put databases under source control” available for download

Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for SQL Saturday in Ancona on 13th December. See you there!

Stay tuned 🙂

SQL Saturday in Verona!

This year I will speak at PASS SQL Saturday in Verona with a session based on database and source control management.

PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, 
providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. 
Whether you’re attending a SQLSaturday or thinking about hosting your own, we think you’ll find it’s a 
great way to spend a Saturday – or any day. 
I would like to share my experience in using Visual Studio and Red-Gate tools for database source control and continuous integration with TFService. So, I’ll wait for you all!
This is the speaker list and these are the event details.
Stay Tuned!