Average article rating: 4.31
Database Development
|
| SQL Server |
20 Aug 2010
Updated: 20 Aug 2010
Rating: 4.40/5
Votes: 33
Popularity: 6.57
Licence: CPOL
Views: 189,933
Bookmarked: 67
Downloaded: 0
This article is written to describe all the different types of Sql Joins
|
Hosted Services
|
| Azure |
19 Nov 2018
Updated: 19 Nov 2018
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: CPOL
Views: 7,773
Bookmarked: 6
Downloaded: 0
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
|
|
25 Nov 2018
Updated: 25 Nov 2018
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 6,920
Bookmarked: 2
Downloaded: 0
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
|
|
8 Dec 2018
Updated: 10 Dec 2018
Rating: 4.78/5
Votes: 17
Popularity: 5.88
Licence: CPOL
Views: 17,559
Bookmarked: 31
Downloaded: 0
This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.
|
|
8 Jan 2019
Updated: 8 Jan 2019
Rating: 2.38/5
Votes: 4
Popularity: 1.44
Licence: CPOL
Views: 12,523
Bookmarked: 3
Downloaded: 0
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
|
20 Aug 2010
Updated: 20 Aug 2010
Rating: 5.00/5
Votes: 11
Popularity: 5.00
Licence: CPOL
Views: 140,580
Bookmarked: 5
Downloaded: 0
This post will show you how to make database offline or online.
|
All Topics
|
|
23 Apr 2018
Updated: 23 Apr 2018
Rating: 1.80/5
Votes: 2
Popularity: 0.54
Licence: CPOL
Views: 6,862
Bookmarked: 2
Downloaded: 0
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU?
|
Database Development
|
| SQL Server |
20 Aug 2010
Updated: 29 Aug 2010
Rating: 4.17/5
Votes: 11
Popularity: 4.17
Licence: CPOL
Views: 60,750
Bookmarked: 8
Downloaded: 0
Identity property in SQL Server
|
|
12 Nov 2010
Updated: 12 Nov 2010
Rating: 4.80/5
Votes: 114
Popularity: 9.78
Licence: CPOL
Views: 1,988,142
Bookmarked: 82
Downloaded: 0
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.
|
|
16 Nov 2010
Updated: 16 Nov 2010
Rating: 4.29/5
Votes: 12
Popularity: 4.63
Licence: CPOL
Views: 50,091
Bookmarked: 10
Downloaded: 0
Introduction to SQL Server Views
|
|
16 Nov 2010
Updated: 16 Nov 2010
Rating: 4.43/5
Votes: 6
Popularity: 3.45
Licence: CPOL
Views: 37,550
Bookmarked: 8
Downloaded: 0
This article will try to show how to find duplicate values in a table.
|
|
17 Nov 2010
Updated: 17 Nov 2010
Rating: 4.54/5
Votes: 6
Popularity: 3.53
Licence: CPOL
Views: 83,224
Bookmarked: 5
Downloaded: 0
Basic information about the different ways of creating a table
|
Hosted Services
|
| Azure |
24 Nov 2018
Updated: 24 Nov 2018
Rating: 4.86/5
Votes: 4
Popularity: 2.92
Licence: CPOL
Views: 9,393
Bookmarked: 2
Downloaded: 0
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
|
|
27 Dec 2018
Updated: 27 Dec 2018
Rating: 3.00/5
Votes: 4
Popularity: 1.81
Licence: CPOL
Views: 4,982
Bookmarked: 1
Downloaded: 0
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 |
23 Apr 2018
Updated: 23 Apr 2018
Rating: 4.14/5
Votes: 4
Popularity: 2.49
Licence: CPOL
Views: 4,450
Bookmarked: 7
Downloaded: 0
Through this article, we are going to discuss three important interview questions of SQL
|
Average tips rating: 4.11
Database Development
|
| SQL Server |
26 Nov 2010
Updated: 26 Nov 2010
Rating: 4.71/5
Votes: 5
Popularity: 3.30
Licence: CPOL
Views: 11,590
Bookmarked: 5
Downloaded: 0
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 |
26 Nov 2010
Updated: 26 Nov 2010
Rating: 3.50/5
Votes: 3
Popularity: 1.67
Licence: CPOL
Views: 13,240
Bookmarked: 4
Downloaded: 0
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.
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
Submit an article or tip