Featured Article

Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins

By | January 2, 2010

I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types of Joins in SQL Server are and how they can be best used then they really enjoy using them. By using the joins we can get data from many tables based on some logical conditions.… Read More »

Featured Article

Sql Server – How to write a Stored procedure in Sql server

By | December 5, 2009

Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of  using a stored procedure. The main benefit of  using a stored procedure is that it increases the performance of the database.The other benefits… Read More »

Azure Pricing Models and Service Tiers

By | April 24, 2018

  Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU? Example Different Service Tiers in DTUs base pricing model Standard Service Tier Levels Premium Service Tier Levels DTU Calculator How DTU Calculator work Conclusion Introduction When we start migrating our database from SQL Server to Azure Database, we want to know what are… Read More »

SQL Script to find the database & their files details on a SQL Server

By | March 30, 2018

SQL Script to find database details Sometimes we need a SQL Script which can give the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name 2) Database ID 3) Database Files name with their physical location 4) Database Creation Time 5) Users access type for Database 6)… Read More »

SQL Script: – How to find the database restoring history of SQL Server databases

By | March 30, 2018

SQL Script to find database restoring history Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there is a possibility that it is restored recently? 2) Which backup file (with location information) is used for database restoration?… Read More »

SQL Script: – How to find the last access date of a database

By | March 29, 2018

SQL Script to find database last access date Sometime we create databases on Test/ Development database servers for temporary uses for short duration and  forgot to delete them after the work got completed. As a part of house keeping activity, we need to find out when a database is last accessed in order to find… Read More »

Learn How to Recover Deleted Records from SQL Server 2014

By | August 8, 2017

Problem Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a lot of issues. To maintain the workflow they need to recover deleted records from SQL Server 2014. This could be possible only with successful SQL… Read More »

Two Ways to Restore Database from MDF File in SQL Server

By | July 27, 2017

Ways to Restore Database from MDF File Introduction In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best and successful RDBMS which provides highly integrated services to manipulate the SQL database over the Server. As we… Read More »

How to Resume Suspended Database Mirroring in SQL Server ?

By | September 3, 2016

Resuming Suspended Database Mirroring in SQL Overview Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and minimizes the loss of the data. Redundancy ensures that there is always a one backup copy of the database… Read More »

SQL Script to find all the triggers defined on a database or on a single table

By | August 14, 2015

SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] , trig.name as [Trigger Name] , trig.is_disabled FROM [sys].[triggers] as trig INNER JOIN sys.tables as tbl ON trig.parent_id = tbl.object_idIn… Read More »