I’ve just replied to a question in dotnethell italian forum about the topic in the title. Actually it’s not the first time I got this kind of question:
“How can I repeat a row using a value that is stored in another column of the same table?”
Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 and 2012:
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 really useful for a team, let’s see how we can share them in a team.
Continue reading “Share t-sql snippets to the team with SQL Prompt”
Directly from SQL release service blog, here is the list of latest updates for SQL Server 2008 SP3 and 2012 SP1
I’ve just received a question about features comparison between SQL Server and SQL Azure Database. This is one of the most frequently asked questions I receive in my blog PMs and forums.. Thus, I’m sharing the links in order to gather some information about this topic.
I have recently found a strange behavior related to a comfortable DDL command, the ALTER SCHEMA statement. That happened while I was trying to move a stored procedure from a schema to another one. Both stored procedure and function definitions are stored on a catalog object which is accessible by the sys.sql_modules catalog view (column “definition”). After executing the ALTER SCHEMA statement the definition field is not updated.
We’re speaking about both SQL Server 2012 on premise and SQL Azure databases. My current SQL Server 2012 version/edition is:
Directly from the Service Release Blog, here is the list of latest Cumulative Updates for SQL Server 2012 RTM and SQL Server 2008 R2:
Directly from Aaron Bertrand’s blog, here is the list of latest updates for SQL Server 2008 SP3 and 2012 SP1
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
IMHO, putting databases under source control management should be mandatory for every team.
In this post, I will try to explain how SQL Server Management Studio can cooperate with one of the third party tools that I’m currently using. This is the scenario:
Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 and 2012:
Alessandro Alpi's Blog 