SQL Server

How to Monitor a Database in Microsoft Azure

Find out how the Basic Monitoring via Web Console operates, and get an overview of deadlocks, failed connections, successful connections, and blocking by firewall. Review three categories of views: Database-Related, Execution-Related, and Transaction-Related.

Monitoring tools and techniques that you might be accustomed to using on an on-premises server, such as auditing logins, running traces, and using performance counters, are not available for SQL Database. On Azure, you use Data Management Views (DMVs) to monitor data capacity, query problems, and current connections.

How to Create Database in Microsoft SQL Azure

Microsoft Azure SQL Database is a relational database-as-a-service that delivers predictable performance, scalability, business continuity, data protection, and near-zero administration to cloud developers and solution architects.

Microsoft Azure offers several choices for data storage. These include Azure storage and SQL Azure. You may choose to use one or both in your particular project. Azure storage currently contains three types of storage structures: tables, queues and blobs.

Batching Techniques for SQL Database Applications in Azure

Batching operations can be very helpful in improving your performance and scalability for your in house application as well as cloud applications.

Here are some of the batching techniques available for you to consider:


Client side code based transactions can be simple and useful. Here is an example:

SQL Server 2008 Management Studio Error: Invalid prefix or suffix characters


Invalid prefix or suffix characters. (MS Visual Database Tools)

When you try to right-click on a table and Select Edit Top 200 rows in SQL Server 2008 R2 Management Studio you might get the above error and not allow you to edit the rows.


How to Edit a Row in SQL Server 2008, 2012 using Management Studio?

I see that there is an option to Edit the Top 200 rows in a Table, but how can I edit a particular row that I need.


This is a common requirement to be able to edit any particular row and not just the top 200 rows which is provided by default in SQL Server 2008, 2012 and forward.

What you need to do is.


How to Enable SQL Command Mode in SQL Server?


Incorrect syntax near ':'.

SQLCMD mode must be enabled to successfully execute this script.



At times some of the SQL Scripts that you run might need the SQL Command Mode enabled to be able to execute successfully.

Its in such scenarios do you get the above Error which wants you to enable the SQLCMD mode.

Here is how you can enable the SQL CMD mode. In your SQL Server Management Studio


SQL Script to Verify the Database backup file

Here is the SQL Script to be able to Verify the Database Backup file before you want to Restore it. This will let you know if your Backup is fine and usable or Corrupt and not usable.

FROM DISK='C:\YourDatabase.bak'


IF @@ERROR = 0
PRINT 'Your Backup is in a Usable State'
PRINT 'Sorry, Your Backup is corrupt and is not in a Usable State'

What is the difference between drop table and delete table in SQL Server

Difference between drop table and delete table in SQL Server

You will notice that there are two ways to get rid of data you don’t require in SQL Server. One is by the Delete Table command and the other one is by the Drop table command. So what is the difference between the two?