-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

One of my Code Project article on SQL Trigger has been selected as entry in this contest.
I have explain the concept of SQL triggers on it. Please have a look on my article and if you like…

Read more

0 comments, 182 reads

Posted in Vivek's SQL Notes on 9 January 2019

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database

This article try to explain
  • Automatic backups services provided by Azure 
  • Backup retention periods
  • How to take the point in time database restoration
This database restoration process help in protecting the database from corruption and more importantly from accidental deletion of data.

Read more

0 comments, 125 reads

Posted in Vivek's SQL Notes on 8 January 2019

Merry Christmas

Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!


From 

Read more

0 comments, 128 reads

Posted in Vivek's SQL Notes on 24 December 2018

SQL Triggers – An Introduction

This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work. It will gives information about triggers & its various types, Magic tables, difference b/w trigger &  stored Procedure, finding, enabling & disabling triggers, advantages & disadvantages of triggers with the…

Read more

0 comments, 222 reads

Posted in Vivek's SQL Notes on 8 December 2018

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In this article, I have explained this as a step by step process 

Read more 
SQL Tutorial

Read more

0 comments, 318 reads

Posted in Vivek's SQL Notes on 25 November 2018


How to migrate SQL Database to Azure SQL Database using SSMS Export/Import

Migrating SQL Database to Azure SQL Database using SSMS Export/Import

Contents

  • Introduction
  • Creating the .bacpac file using SSMS Export
  • Importing the .bacpac file using SSMS Import
  • Summary

Introduction

There are many ways of migrating the On premise SQL…

Read more

0 comments, 0 reads

Posted in Vivek's SQL Notes on 19 November 2018

Know How to Import SQL Server database From One to Another

Looking to import SQL Server database from one server to another ? Confused how to copy from one to another or which process method to use?

Here we will learn how to import data from one SQL Server database to another.

First let us understand what options you have to… Read more

0 comments, 409 reads

Posted in Vivek's SQL Notes on 5 October 2018

Blog trasfering to new hosting server

Hi Friends,

This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry for the inconvenience  caused


Read more

0 comments, 247 reads

Posted in Vivek's SQL Notes on 10 April 2018

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

Sometimes we need a SQL Script which can gives 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

1 comments, 862 reads

Posted in Vivek's SQL Notes on 30 March 2018

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

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 can be a possibility that it is restored recently?
2) Which backup file (with location information) is used for database…

Read more

0 comments, 1,771 reads

Posted in Vivek's SQL Notes on 30 March 2018

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

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 out the databases…

Read more

1 comments, 1,222 reads

Posted in Vivek's SQL Notes on 29 March 2018

Understanding Azure SQL Database- Introduction

Introduction:- 

In this first article of the series Understanding Azure SQL Database in which I am going to publish in the coming weeks to understand Azure SQL Database concepts. After this series, you will have the good understanding of the following Azure SQL concepts

  • What is Azure and Azure SQL…

Read more

0 comments, 566 reads

Posted in Vivek's SQL Notes on 18 March 2018

Learn How to Recover Deleted Records from SQL Server 2014

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… Read more

0 comments, 3,931 reads

Posted in Vivek's SQL Notes on 8 August 2017

Two Ways to Restore Database from MDF File in SQL Server

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 talk about… Read more

4 comments, 21,796 reads

Posted in Vivek's SQL Notes on 27 July 2017

How to Resume Suspended Database Mirroring in SQL Server ?

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 should… Read more

2 comments, 10,212 reads

Posted in Vivek's SQL Notes on 3 September 2016

Happy New Year Friends

Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.


Read more

0 comments, 444 reads

Posted in Vivek's SQL Notes on 1 January 2016

SQL Recovery Software: An Ultimate Tool For SQL Database Recovery

SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server, etc. the data in the database may go damaged or corrupted. The recovery of the data can be made possible with…

Read more

2 comments, 1,261 reads

Posted in Vivek's SQL Notes on 31 December 2015

Happy Independence Day - Jai Hind

Wishing you a very

Happy Independence Day


" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.



     Some facts about India 
  1. Indus Valley Civilization is the world’s oldest civilization.So, India is…

Read more

0 comments, 641 reads

Posted in Vivek's SQL Notes on 15 August 2015

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

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…

Read more

0 comments, 1,524 reads

Posted in Vivek's SQL Notes on 14 August 2015

Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-


 1) Can we create clustered index on a column containing duplicate values?

 2) Can we create a Primary Key on a table on which a clustered index is already defined?

3) If a clustered index…

Read more

0 comments, 6,651 reads

Posted in Vivek's SQL Notes on 13 August 2015

Older posts