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 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:
Recently I had to create a backup procedure on my Windows Azure SQL Database. SQL Server Management Studio allows us to access to our SQL Databases and provides the user interfaces for creating backup files.
In this post we will understand:
Since the database copy can be considered as a full backup, we want to create also a file in order to place it on another place, that could be a local or a cloud storage.
Continue reading “Backup Windows Azure SQL Database with Sql Server Management Studio”
Sometimes, in the forums I’m following, I face some questions about different execution times between Sql Server Management Studio and ado.net executions.
Questions like “Why my SSMS queries run so fast and my ado.net queries are so slow?”. This is a scaring behavior that you can verify lots of times. Some application’s logs tell to us a too large timing. When you copy/paste the SQLCommand into a new query window using SSMS (also on the incriminated server) the execution time is very short.
Continue reading “Differences between SSMS and ado.net: query execution time”
Usually I found some questions on the forums about that topic. For instance:
Just before the end of the 2012 the Microsoft SQL Server Sustained Engineering team released the following updates:
Cumulative Update #10 for SQL Server 2008 R2 Service Pack 1
Cumulative Update #4 for SQL Server 2008 R2 Service Pack 2
Cumulative update #5 for SQL Server 2012
Source: SQL Release Services Blog
This is a very short post and maybe not the right one to start with.. however, welcome to my new english blog!
If you want to watch my italian version, feel free to browse it 😉
I use to say..
Stay Tuned! 🙂
If you are no[t able], Create Table 🙂
Alessandro Alpi's Blog 