The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production, these tools & utilities are a great way to g...

The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels. The graphical designers are a set of utilities, which allow one to perform basic SQL Server deve...

Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following, Alter failed for Login sa. Cannot set a credential for principal 'sa'. Also you can see the image below for the same. ...

= 2 ORDER BY --Seems to be Problem with Order By working on the same --Order By Fixed CASE WHEN @Expense_Counter = 0 THEN DurTimeAvgMin WHEN @Expense_Counter = 1 THEN CPUTimeAvgMin WHEN @Expense_Counter = 2 THEN TotalCPUTime WHEN @Expense_Counter = 3 THEN TotalDurTime W...

As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio (SSMS) and the Query Editor window. I hope t...

I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track of list of builds and version releases. Le...

Recently while working with database security, I learned database roles as how the each role used. Apart from the server level roles if we need to require to assign access/rights to particular databases level then we need to go through database level roles. Following are the fixed database leve...

Cross tab result is always required and it is bit complex in case of dynamic column. If column name has to be dynamic then this is the good idea to have the PIVOT Query, for example I have 3 Tables and data like this: First Table ------------------------------------------...

Writing where clause has been easiest thing. Most of the time we learn this as a first thing in SQL. I have often seen that many times a simple question with where one has to write about where clause they often fail or get confused

What is an IDENTITY Value? What are the different ways to get IDENTITY values and properties of IDENTITY Values? If you are going to answer that identity value is ever increasing, is it possible to have identity value ever decreasing value?