Category: SQL Terminologies

This is page is for SQL Concepts that you already know or should know. Here, I will try to add one concept per day with real life example(s) to map our knowledge with real world and work.

CAST vs. CONVERT

CAST vs. CONVERT

Datatype conversion is a common scenario that we face while writing SQL queries. Cast and Convert are two functions provided by SQL for this purpose. But what is the difference ...

READ MORE +
0
System Databases : Restrictions Matrix

System Databases : Restrictions Matrix

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you "can not" perform ...

READ MORE +
0
Question : Who is a DBA?

Question : Who is a DBA?

This post is targeted for those who are keen or new to DBA profession. Based on my experience I tried to write about DBAs and Possible career paths related to it. Who is a ...

READ MORE +
0
March towards SQL Server : Day 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

March towards SQL Server : Day 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

Hello Readers, Today I am posting the last post for my series 'March Towards SQL Server'. At this point, I would like to say thank you for boosting me up by commenting or ...

READ MORE +
1
March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used ...

READ MORE +
0
March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4

March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4

Here I am posting final post on SQL Server Performance Tuning concepts. I hope you must have read our previous posts on Performance Tuning. If not, have a quick look Part1 , ...

READ MORE +
0