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 unit testing on database)
.Net Campus a Roma, May 30,¬†I’ll speak about continuous integration with SQL Server (source control, unit testing, deploy).
There’s a lot of work to do. But I’m thinking now about two or three new sessions. I hope to finish them in the last months of the year, and I hope to meet you in one of ¬†these events, at least online.
Stay tuned!

 

Interview with Kris Wenzel on EssentialSQL.com

EssentialSQL.com is a very useful resource for learning SQL Server.

As in the website¬†homepage:¬†“Now it is time to learn SQL in simple English.”
Kris would like to reach the following goals:
  • Get started in an easy to follow step-by-step manner.
  • Use reader’s¬†time wisely (focusing on what is important to learn to get the most value from your time).
  • Answer the¬†questions.
It’s an important contribute to the SQL Server community. Kris explains¬†here¬†why he’s started to write EssentialSQL.com.
I’ve found this interview very interesting. We’ve spoken about my favourite topics, like Source control on database and database unit testing. This is my job, everyday.
We’ve spoken¬†also about worst practices I saw in my past experiences and then he asked me to give some suggestion¬†to people who start¬†to explore SQL Server.
Thus, if you have a couple of minutes, you can read my interview here.
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!