SQL Server with Red-gate SQL Source Control – Working folder management with TFS

I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind of approach brings a drawback, due to the nature of the plugin and VSO APIs: High latency when getting and syncing local database and workspaces.

Due to this problem, I’ve changed my settings when linking my databases, switching them from “Team Foundation Server (TFS)” to “Working folder“, as in the following picture:

Continue reading “SQL Server with Red-gate SQL Source Control – Working folder management with TFS”

SQL Server latest Cumulative Updates (Apr. 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2014 RTM (actually, for 2014 is also the first 😉 ):

SQL Server 2008 R2 SP2

Cumulative Update #12 for SQL Server 2008 R2 SP2

SQL Server 2014 RTM

Cumulative Update #1 for SQL Server 2014 RTM

logosql2014

Please note that there is an issue that affects the packaging of CU1 that is causing a failure during slipstream installation. More details on this KB Article.

 

Stay Tuned! 🙂

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 Server latest Cumulative updates (dec. 2013)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2012 RTM:

SQL Server 2008 R2 SP2

Cumulative Update #10 for SQL Server 2008 R2 SP2

SQL Server 2012 RTM

Cumulative Update #11 for SQL Server 2012 RTM

NOTE: This will be the final Cumulative Update for SQL Server 2012 RTM release. For more information on the lifecycle of SQL Server 2012 see the product support lifecycle page.

 

Stay Tuned! 🙂