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:
- SQL Test (addon for SQL Server Management Studio, unit testing utility)
“Expand/Collapse all” for avoiding clicks when you have lots of test procedures
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
- Extended menu options
- Grid commands
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.
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:
- how to create a Azure SQL Database copy
- how to save a logical file backup on the cloud storage
- how to restore the logical file on a new Azure SQL Database
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.