Follow Us
Categories
- Azure (8)
- DBA (17)
- Festive Greetings (1)
- Interview Questions (29)
- Miscellaneous (10)
- SQL Server (99)
- Imp SQL Difference (6)
- Most Imp SQL Concepts (13)
- SQL ACID Rule (1)
- SQL Advanced (17)
- SQL Basic (10)
- SQL Basic Concepts (17)
- SQL Best Practices (2)
- SQL CTE (2)
- SQL Cursor (1)
- SQL Data Types (1)
- SQL Database Backup (1)
- SQL Database Mirroring (1)
- SQL Database Restoration (3)
- SQL DDL, DML, DCL, TCL (1)
- SQL Derived Table (1)
- SQL Functions (17)
- SQL Group By Having (1)
- SQL Indexes (7)
- SQL Isolation Level (1)
- SQL Joins (1)
- SQL Log Shipping (1)
- SQL Merge Command (1)
- SQL Normalization (5)
- SQL Output Clause (1)
- SQL Pivot and Unpivot table (1)
- SQL Primary Key Constraint (2)
- SQL Queries Sub-queries (1)
- SQL Ranking Function (1)
- SQL Replication (1)
- SQL Server Exception handling (1)
- SQL Stored Procedure (4)
- SQL Temporary Tables (3)
- SQL Triggers (3)
- SQL Union Function (1)
- SQL View (1)
- SQL While loop (1)
- SQL Tips (5)
-
Recent Posts
- SQL Joins Tricky Interview Questions April 17, 2019
- Point In Time Restore for Azure SQL Database January 8, 2019
- Azure – Creating an Azure SQL Database December 27, 2018
- Merry Christmas December 24, 2018
- SQL Triggers – An Introduction December 8, 2018
- Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool November 25, 2018
- How to migrate SQL Database to Azure SQL Database using SSMS Export/Import November 19, 2018
Archives
- April 2019 (1)
- January 2019 (1)
- December 2018 (3)
- November 2018 (6)
- October 2018 (1)
- April 2018 (1)
- March 2018 (4)
- August 2017 (1)
- July 2017 (1)
- September 2016 (1)
- December 2015 (1)
- August 2015 (3)
- July 2015 (3)
- February 2015 (1)
- January 2015 (16)
- November 2014 (1)
- October 2014 (2)
- August 2014 (22)
- April 2014 (2)
- March 2014 (1)
- January 2014 (8)
- December 2013 (6)
- November 2013 (2)
- December 2012 (5)
- November 2012 (1)
- August 2012 (2)
- April 2012 (4)
- January 2012 (7)
- August 2011 (1)
- July 2011 (1)
- May 2011 (2)
- September 2010 (2)
- January 2010 (14)
- December 2009 (3)
- November 2009 (2)
- October 2009 (3)
- September 2009 (1)
- August 2009 (1)
Monthly Archives: August 2014
SQLTea – New SQL tutorial app in Google play store
SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial app SQLTea ( Native android app) for SQL learning which includes articles from this blog. This application includes 1) Articles … Continue reading
How to restore database backup in SQL SERVER
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little … Continue reading
Posted in SQL Advanced, SQL Database Restoration, SQL Server
Tagged DBA Scripts, SQL Database
30 Comments
How to take Database backup in SQL SERVER
Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable by the database programmer having little knowledge of DBA. For taking the database backup, we need to follow the given … Continue reading
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) … Continue reading
Database Creation using Create Database command
In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS). In this article, I am going to explain the database creation using the command CREATE DATABASE. Syntax for creating a … Continue reading
IN clause in SQL Server
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can use the subquery to get the multiple values in the IN clause or we can have predefined values. In this … Continue reading
AVG() function in SQL Server
Avg():- This function is used to get the average value of a numeric column Syntax:- SELECT AVG(column_name) FROM table_name In this article, we are going to use the following table for some examples:- CREATE TABLE [dbo]. [Employee]( [Empid] [Int] … Continue reading
UPPER() function in SQL Server
UPPER():- This function is used to convert the value of a column to upper case. Syntax: SELECT UPPER(string) OR Select UPPER(Column name) from tablename For example, SELECT UPPER(‘Vivek’) Result: VIVEK
LEN() function in SQL Server
LEN():- This function is used to get the length of the given string value. Syntax:- Select len (stringvalue) For example, Select len(‘Vivek Johari’) Result:- 12
LOWER() function in SQL Server
LOWER():- This function is used to convert the value of a column to lower case Syntax:- Select LOWER (string) or SELECT LOWER(column_name) FROM table_name For example, SELECT LOWER(‘Vivek Johari’) Result:- vivek johari