SQL Server latest Cumulative Updates (Mar. 2014)

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

SQL Server 2008 SP3

Cumulative Update #16 for SQL Server 2008 SP3

SQL Server 2008 R2 SP2

Cumulative Update #11 for SQL Server 2008 R2 SP2

SQL Server 2012 SP1

Cumulative Update #9 for SQL Server 2012 SP1

Stay Tuned! :)

NuGet + Visual Studio: Automatic Package Restore of Different Solutions to the Same Folder

NuGet + Visual Studio: Automatic Package Restore of Different Solutions to the Same Folder

Originally posted on . Net Diaries:

Attachment with the sample: NugetPackageRestore.zip

Today I had a problem using nuget package restore in a quite complex project that has multiple projects and multiple solutions file located in different folders, so that nuget was restoring the packages in a wrong folder for some of my solutions.

For instance if you have a file structure like this:

1

AllMyProjects.sln simply contains all the projects (ProjectA.Model.csproj, ProjectA.Service.csproj, ProjectB.Model.csproj, ProjectB.Service.csproj).

When you run the build for all the 3 solutions, nuget by default will restores everything in a folder “packages” located at the same level of the solution file, producing something like this:

1
Root
|- Packages
|- (...all the packages...)

View original 484 more words

TFS: Delete Folder without a Workspace

Originally posted on . Net Diaries:

Sorry about this title, but actually you cannot delete a source controlled folder without assigning first a workspace, BUT, but you can avoid wasting disk space avoiding to recursively download all the files in that folder, so it’s what I think you want to do, and then here’s the steps:
  1. Open the “Developer Command Prompt for VS2013″
  2. Go to the workspace folder where you have the folder you want to get without recursively get all the items
  3. run the command “tf get <folder path>” without the /recursive switch

TF will get only the first level content of the <folder path>, then you can go back on visual studio team explorer, delete the folder and checkin the changes :)

View original

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!
A practical guide for dealing with capacikill in TFS

A practical guide for dealing with capacikill in TFS

suxstellino (Alessandro Alpi):

Very good article! Capacikill and real world team management

Originally posted on The Road to ALM:

Capacikill? What the … is that?

Actually it is a word I made up. To be honest it was a colleague who talked about capacity in a noisy room and I thought I heard him say it. I understood capacikill and the word had a meaning to me right away. As you can obviously see, it is a merge of the words capacity and kill but what do I mean by it?

This blog post is about giving meaning to this word to others besides me.

Scrum vs. Capacity planning

When doing Scrum in its purest form, capacity is the easiest thing to manage. There is a Scrum team consisting of a number of people. These people work full-time on sprint work. Capacity is simple. (Number of people in Scrum Team) x (Number of Days in Sprint) x (Number of Hours per Day)

The team maintains remaining work and this…

View original 877 more words

SQL Server latest Cumulative updates (jan. 2014)

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

SQL Server 2008 SP3

Cumulative Update #15 for SQL Server 2008 SP3

SQL Server 2012 SP1

Cumulative Update #8 for SQL Server 2012 SP1

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!