Sql Server: Backup all the databases of the instance

ahahahah, thank you Michael 🙂

Michael Denny's avatar.Net Diaries

security8

They told me (Alessandro Alpi), to don’t blog this 🙂 because there’s a lot of this stuff out there, but this my blog, and it is too cool when developing in load testing environment, and you need to backup, try load test data, and restore previous version, so forgive me about this:

Change the “C:_Databases_BackupDatabases” into your default BackupDirectory found in the instance facets, to avoid security problem.

DON’T USE THIS CODE IN PRODUCTION!!

View original post

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

Michael Denny's avatar.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:

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:

Now, if you first compile the ProjectA.sln and ProjectB.sln, also the AllMyProjects.sln will compile fine, but this just because the packages will be correctly restored by the two specific solution ProjectA.sln and ProjectB.sln, but if you try to clean up all the packages folder, and build the AllMyProjects.sln first, you…

View original post 260 more words

TFS: Delete Folder without a Workspace

Michael Denny's avatar.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 post

A practical guide for dealing with capacikill in TFS

Very good article! Capacikill and real world team management

Rene van Osnabrugge's avatarThe 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 post 877 more words

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!

SSMS Boost another cool addin for SQL Server Management Studio

During my SQL Devlife I tried lots of SQL Server management studio add-ins. Some days ago I tried SSMSBoost. Since I’ve already spoken about SSMSToolsPack and SQLPrompt, I’d like to focus this post on the capabilities that SSMSBoost adds to Sql Server Management Studio. I’ll speak about some of the available features, in the following order:

  • UI/User experience capabilities
  • Connections management
  • Searches
  • Extended menu options
  • Grid commands

Continue reading “SSMS Boost another cool addin for SQL Server Management Studio”