15,348,882 members
Sign in
Email
Password
Forgot your password?
Sign in with
Search within:
Articles
Quick Answers
Messages
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Python questions
View Javascript questions
View Java questions
discussions
forums
CodeProject SenseAI
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
stuff
Competitions
Conferences
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Artificial Intelligence
Artificial Intelligence
Neural Networks
Machine Learning
Deep Learning
ML.Net
Big Data
Data Science
Tensorflow
Internet of Things
Internet of Things
Arduino
Edge Device
Raspberry-Pi
Wearables
IoT Edge
Industrial IoT
DevOps
DevOps
Agile
Automation
Continuous Build
Continuous Delivery
Continuous Deployment
Continuous Integration
Deployment
Git
Installation
Integration Testing
Load Testing
Quality Assurance
TFS
Unit Testing
Testing
Containers
Containers
Docker
Kubernetes
Virtual Machine
High Performance Computing
High Performance Computing
GPU
Parallel Processing
Parallelization
Vectorization
Hosted Services
Hosted Services
Alibaba
AWS
Cordova
ExtJS
Google Cloud
Microservices
PhoneGap
Serverless
Storage
Web Hosting
WordPress
Azure
Security
Security
Blockchain
Cryptography
Encryption
Identity
Identity Server
Web Development
Web Development
Blazor
CSS3
Flask
HTML5
Kestrel
LESS
Nginx
Node.js
React
SCSS
Spring
Vue.js
ASP.NET
CSS
Apache
HTML
IIS
XHTML
Mobile Apps
Mobile Apps
Flutter
Ionic
iOS
Nativescript
React Native
Xamarin
Windows Mobile
Android
Desktop Programming
Desktop Programming
Cocoa
Electron
QT
Universal Windows Platform
X11
Windows Forms
ATL
MFC
Swing
Win32
WTL
WPF
XAML
System
Database Development
Database Development
Data Visualization
Elasticsearch
Lucene
MariaDB
MongoDB
NoSQL
PostgreSQL
Redis
MySQL
SQL Server
Productivity Apps and Services
Productivity Apps and Services
LibreOffice
OpenOffice
Sharepoint
Team Communication Tools
Biztalk
Microsoft Office
SAP
Game Development
Game Development
Doom
Kinect
Playstation 4
Playstation 5
Unity
Unreal
XBox
Multimedia
Multimedia
Audio
Image Processing
Video
Audio Video
DirectX
GDI
GDI+
OpenGL
General Programming
General Programming
Algorithms
Compression
Computational Geometry
Emulation
Exceptions
File
Internet
Localization
Memory Management
Optimization
Parser
Performance
Regular Expressions
Sorting
State Machines
Architecture
Design / Graphics
Printing
String
Threads
Usability
Programming Languages
Programming Languages
ASM
Bash
Basic
COBOL
Dart
Go
Haskell
Kotlin
Lua
Pascal
R
Razor
Rust
Scala
Swift
Typescript
Objective C
Visual Basic
VBScript
C++
C#
F#
FORTRAN
Java
Javascript
Perl
Python
Ruby
SQL
PHP
PowerShell
XML
Articles by Vivek Johari (Articles: 5, Technical Blogs: 10, Tip/Tricks: 2)
Articles: 5, Technical Blogs: 10, Tip/Tricks: 2
Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects
Average article rating: 4.31
Database Development
SQL Server
SQL Joins
20 Aug 2010 Updated:
20 Aug 2010
Rating: 4.40/5 Votes: 33 Popularity: 6.57
Licence: CPOL Views: 182,662
Bookmarked: 67
Downloaded: 0
Please
Sign up or sign in
to vote.
This article is written to describe all the different types of Sql Joins
Hosted Services
Azure
How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import
19 Nov 2018 Updated:
19 Nov 2018
Rating: 5.00/5 Votes: 4 Popularity: 3.01
Licence: CPOL Views: 6,613
Bookmarked: 5
Downloaded: 0
Please
Sign up or sign in
to vote.
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
How to Migrate SQL Database to Azure SQL Database using SSMS Deploy
25 Nov 2018 Updated:
25 Nov 2018
Rating: 5.00/5 Votes: 2 Popularity: 1.51
Licence: CPOL Views: 5,630
Bookmarked: 2
Downloaded: 0
Please
Sign up or sign in
to vote.
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
SQL Triggers – An Introduction
8 Dec 2018 Updated:
10 Dec 2018
Rating: 4.78/5 Votes: 17 Popularity: 5.88
Licence: CPOL Views: 14,629
Bookmarked: 31
Downloaded: 0
Please
Sign up or sign in
to vote.
This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.
Point In Time Restore for Azure SQL Database
8 Jan 2019 Updated:
8 Jan 2019
Rating: 2.38/5 Votes: 4 Popularity: 1.44
Licence: CPOL Views: 10,892
Bookmarked: 3
Downloaded: 0
Please
Sign up or sign in
to vote.
This article discusses the step by step process of point in time restore for Azure SQL database, Azure automatic backups as well as database backups retention period.
Average blogs rating: 4.10
How to Make Database Offline or Online [Technical Blog]
20 Aug 2010 Updated:
20 Aug 2010
Rating: 5.00/5 Votes: 11 Popularity: 5.00
Licence: CPOL Views: 137,419
Bookmarked: 5
Downloaded: 0
Please
Sign up or sign in
to vote.
This post will show you how to make database offline or online.
All Topics
Azure Pricing Models and Service Tiers [Technical Blog]
23 Apr 2018 Updated:
23 Apr 2018
Rating: 1.80/5 Votes: 2 Popularity: 0.54
Licence: CPOL Views: 6,082
Bookmarked: 2
Downloaded: 0
Please
Sign up or sign in
to vote.
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU?
Database Development
SQL Server
IDENTITY Property in SQL Server [Technical Blog]
20 Aug 2010 Updated:
29 Aug 2010
Rating: 4.17/5 Votes: 11 Popularity: 4.17
Licence: CPOL Views: 59,380
Bookmarked: 8
Downloaded: 0
Please
Sign up or sign in
to vote.
Identity property in SQL Server
Sql Server - How To Write a Stored Procedure in SQL Server [Technical Blog]
12 Nov 2010 Updated:
12 Nov 2010
Rating: 4.80/5 Votes: 114 Popularity: 9.78
Licence: CPOL Views: 1,959,071
Bookmarked: 82
Downloaded: 0
Please
Sign up or sign in
to vote.
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. This article will describe the Stored Procedure in SQL Server and their benefits.
Introduction to SQL Server Views [Technical Blog]
16 Nov 2010 Updated:
16 Nov 2010
Rating: 4.29/5 Votes: 12 Popularity: 4.63
Licence: CPOL Views: 48,111
Bookmarked: 10
Downloaded: 0
Please
Sign up or sign in
to vote.
Introduction to SQL Server Views
How to Find Duplicate Values in a Table [Technical Blog]
16 Nov 2010 Updated:
16 Nov 2010
Rating: 4.43/5 Votes: 6 Popularity: 3.45
Licence: CPOL Views: 36,560
Bookmarked: 8
Downloaded: 0
Please
Sign up or sign in
to vote.
This article will try to show how to find duplicate values in a table.
Different Ways to Create a Table and Insert Data into the Table [Technical Blog]
17 Nov 2010 Updated:
17 Nov 2010
Rating: 4.54/5 Votes: 6 Popularity: 3.53
Licence: CPOL Views: 80,813
Bookmarked: 5
Downloaded: 0
Please
Sign up or sign in
to vote.
Basic information about the different ways of creating a table
Hosted Services
Azure
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool [Technical Blog]
24 Nov 2018 Updated:
24 Nov 2018
Rating: 4.86/5 Votes: 4 Popularity: 2.92
Licence: CPOL Views: 8,073
Bookmarked: 2
Downloaded: 0
Please
Sign up or sign in
to vote.
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type
Azure – Creating an Azure SQL Database [Technical Blog]
27 Dec 2018 Updated:
27 Dec 2018
Rating: 3.00/5 Votes: 4 Popularity: 1.81
Licence: CPOL Views: 4,112
Bookmarked: 1
Downloaded: 0
Please
Sign up or sign in
to vote.
Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for
Programming Languages
SQL
Interview Question – Is Clustered Index on Column with Duplicate Values Possible? [Technical Blog]
23 Apr 2018 Updated:
23 Apr 2018
Rating: 4.14/5 Votes: 4 Popularity: 2.49
Licence: CPOL Views: 4,040
Bookmarked: 7
Downloaded: 0
Please
Sign up or sign in
to vote.
Through this article, we are going to discuss three important interview questions of SQL
Average tips rating: 4.11
Database Development
SQL Server
SQL Server - How to create LinkedServer using SMO [Tip/Trick]
26 Nov 2010 Updated:
26 Nov 2010
Rating: 4.71/5 Votes: 5 Popularity: 3.30
Licence: CPOL Views: 11,110
Bookmarked: 5
Downloaded: 0
Please
Sign up or sign in
to vote.
Nice tip Kanasz :) You can also create the linkedserver through SQL SERVER MANAGEMENT STUDIO by following the following pathClick on the Server ObjectsRight click on the Linked servers under the Server Objects and select the New linked Server option.
Programming Languages
SQL
COUNT of DISTINCT Rows in SQL Server [Tip/Trick]
26 Nov 2010 Updated:
26 Nov 2010
Rating: 3.50/5 Votes: 3 Popularity: 1.67
Licence: CPOL Views: 12,650
Bookmarked: 4
Downloaded: 0
Please
Sign up or sign in
to vote.
Nice tip :)But if you have any column say empid which have the unique constraint then it is better to use the following SQL queryselect count(distinct empid ) from employees
Average reference rating:
No reference articles have been posted.
Average project rating:
No projects have been posted.
Vivek Johari
Database Administrator
India
I am currently working as a Senior DBA and have around 11 years of experience in database.
Degree:-
Master Degree in Computer(MCA)
Work experience:-
Designing of the database.
Database Optimization.
Writing Complex Stored Procedures,Functions,Triggers etc.
Designing and developing SSIS & DTS packages.
Designing SQL Reports using SSRS.
Database Server Maintenance.
Certification:-
Microsoft certified Sql DBA in Sql server 2008
(MCTS).
Microsoft certified BI professional in Sql server 2008
(MCTS).
Oracle certified profession DBA in ORACLE 10g
(OCP)
certified profession DBA in ORACLE 9i
(OCP)
My other publication
Technical Blog:-
Technologies with Vivek Johari
Moderator and Blogger at
BeyondRelational.com
Guest Author and Blogger at
sqlservercentral.com