-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Alessandro Alpi

Alessandro Alpi worked in the IT area as a developer from 2000 to 2005 and as a DBA/DBDeveloper/.net Developer since 2005. He worked as a web solutions developer (between ASP to the most recent versions of ASP.NET), windows application and services developer with languages C# and VBNet. But recent years he begins to study the data layer, using SQL Server deeply. He is also a trainer in companies, taking sessions on object-oriented programming based on Framework and Microsoft SQL Server, with particular attention to Integration Services. He is a Microsoft Certified Professional and Microsoft Certified Trainer. He managed his blog on dotnethell.it. He is a staff member of this community and he replies in the discussions on dotnethell.it forums. He likes sports and he’s trying to reach handicap on his favourite sport: golf. He plays indoor soccer, swimming and surfing with his snowboard. In the spare time he reads (his favourite books are SQL Server manuals) and he plays on RPG on line.

Managing migrations with RedGate SQL Source Control 5

This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control  and I’ve tested the feature against all my typical cases so that I can share my findings with you.

What is the migrations feature?

When a change… Read more

0 comments, 2,051 reads

Posted in Alessandro Alpi on 30 June 2016

SQL Server 2016 CTP3 – new features and the JSON support improvements

SQL Server Community Technology Preview 3 has been released some days ago.

The SQL Server team added a lot of features related to:

  • SQL Server Engine (Query Store, Temporal Tables and In-Memory improvements)
  • Cloud-ready stuff (Transactional replication from and to Azure SQL Databases, Stretched database enhancements)
  • New releases of Management…

Read more

0 comments, 473 reads

Posted in Alessandro Alpi on 9 November 2015

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… Read more

0 comments, 1,887 reads

Posted in Alessandro Alpi on 15 August 2015

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… Read more

0 comments, 261 reads

Posted in Alessandro Alpi on 15 August 2015

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned! :)


Read more

0 comments, 146 reads

Posted in Alessandro Alpi on 26 March 2015

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned!


Read more

0 comments, 516 reads

Posted in Alessandro Alpi on 26 March 2015

A 2015 full of DLM

After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:

PASS Italian Virtual Chapter, April 14. I’ll demonstrate the SQL source control usage on SQL Server database
PASS SQL Saturday Torino, May 23, I’ve proposed two sessions (source control and…

Read more

0 comments, 401 reads

Posted in Alessandro Alpi on 24 March 2015

A 2015 full of DLM

After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:

PASS Italian Virtual Chapter, April 14. I’ll demonstrate the SQL source control usage on SQL Server database
PASS SQL Saturday Torino, May 23, I’ve proposed two sessions (source control and…

Read more

0 comments, 186 reads

Posted in Alessandro Alpi on 24 March 2015

SQL Saturday Parma – English Slide decks available to download

My SQL Saturday Parma slide decks are available to download on SlideShare.

The main topic of those presentations is database lifecycle management (DLM) on SQL Server.
Concepts: ALM/DLM, team work, differences between code and databases.
We’ve demonstrated the usage of…

Read more

0 comments, 0 reads

Posted in Alessandro Alpi on 26 November 2014

PASS SQL Saturday in Parma

This year, 22 November, PASS SQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.
Our community, dotnethell.it, will be there and you can meet some of us

As you can see in the homepage, the venue will be the…

Read more

0 comments, 659 reads

Posted in Alessandro Alpi on 30 July 2014

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… Read more

0 comments, 978 reads

Posted in Alessandro Alpi on 11 June 2014

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… Read more

0 comments, 399 reads

Posted in Alessandro Alpi on 3 March 2014

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!… Read more

0 comments, 236 reads

Posted in Alessandro Alpi on 16 December 2013

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

Read more

0 comments, 374 reads

Posted in Alessandro Alpi on 18 November 2013

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…

Read more

0 comments, 256 reads

Posted in Alessandro Alpi on 28 October 2013

How to share redgate database tools settings with Team Foundation Service

In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing and powershell to copy files between the default directory and the new place (changing also the related registry keys). In this post we’ll focus on how to… Read more

0 comments, 718 reads

Posted in Alessandro Alpi on 16 July 2013

Share t-sql snippets to the team with SQL Prompt

Red-Gate SQL Prompt is a plugin for SQL Server Management Studio that makes the developers life easier when writing t-sql. It provides improved intellisense, indent and coding styles, and also a snippet manager feature that allows the developer to create a set of useful shortcuts. Those autocomplete items can be… Read more

2 comments, 1,569 reads

Posted in Alessandro Alpi on 25 June 2013

SQL Server under source control with Team Foundation Services and Red-Gate Source Control

During the last few years I’ve been involved in database source control management and release plans tasks. These are important and (mostly) underestimated topics.

You can implement source control management in many different ways

  • Visual Studio and TFS/SVN/GIT/..
  • Direct integration with source control tools and filesystem
  • Sql Server Management Studio…

Read more

5 comments, 534 reads

Posted in Alessandro Alpi on 14 March 2013