Sibeesh Passion

Keyboard Query Shortcuts In SQL Server Management Studio

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see some shortcuts that may be useful to you when you work with SQL Server Management Studio. You can always uses some custom queries too as query shortcuts in SSMS. Here I am going to show some most used the queries shortcuts. I hope you will like this. […]

Read More

Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will are going to see how we can fix the error Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed. You may get this error when you try to install SQL Server. I wast trying to install SQL Server 2016 Release Candidate 1, and I got […]

Read More

Stored Procedure With Common Table Expression Or CTE

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how to use common table expression or CTE in our SQL Server. There are so many situations that you may need to use a common table expression. I had a situation of returning ROW_NUMBER variable value for my paging query in SQL, for this I used CTE. A common […]

Read More

TagIt Control With Data From Database Using Angular JS In MVC Web API

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will learn how to load the tags from database in MVC Web API using Angular JS. Here we are going to use a pretty control called tagIt which does the tag part easier with a lot of configuration options. This article use a normal MVC application which includes the Web API […]

Read More

Generate Database Scripts With Data In SQL Server

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script, the result will give you all the insert query with other queries so that the data also will get inserted in your new database. We are going to use the […]

Read More

Export MDX Result As Excel

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can export mdx query result. Here we are going to use MVC with the help of jQuery Ajax. We will run the MDX query and get the cell set and then we will convert this cell set to html table so that we can render this html […]

Read More

SQL Interview Questions And Answers

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will discuss about the most asked SQL interview questions and answers. If you need to know other interview questions and answers, I strongly recommend to follow this link: Interview Questions. Now in this post we are going to share the interview questions or the information which you must know as a […]

Read More

SqlDateTime Overflow, Must be between Error

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Introduction Hi All, I hope you are fine. We all are using SQL parameter in our application right?Yeah it is a good way to restrict the Injections are hijacks. But still if you pass those parameters in the right way, you will face lots of problems. In this article I am going to share you […]

Read More

Find Out the Missing Indexes in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         This code helps you to find out the missing Indexes in SQL

Read More

Find the Relationship Difference Between Two DB

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Find the relationship difference between two DB.

Read More
Footer With Address And Phones