I am a senior software programmer who is still working hard to get a DBA hat. I am in love with SQL Server. SQL Server for me is all about passion. I am MCSA in SQL Server. Through this blog I am giving myself an opportunity to learn more about SQL, as well as sharing my knowledge and expertise with the world.

Blog Post

Interview Query – 1

Somewhere on internet i found this question. Thought to share it with you all.
We have two tables,  school_students and Class_student.
 
 ...

2018-09-17 (first published: )

2,469 reads

Blog Post

Interview Query – 1

Somewhere on internet i found this question. Thought to share it with you all. We have two tables,  school_students and Class_student.                ...

2018-09-04

15 reads

Blog Post

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...

2016-04-10

549 reads

Blog Post

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...

2016-04-10

22 reads

Blogs

Azure Cloud Chronicles with Microsoft MVPs YouTube Channel

By

In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Read the latest Blogs

Forums

Report Table/view or SP in SQL to handle various reports

By JP789

I have an Access database with a SQL backend with tables, views, SP's. I...

Each database having its own disk?

By WebTechie

Good morning, Once again, I find myself Sr. DBA for a company.  As I...

the value of the effectiveusername xml for analysis property is not valid

By Bhagat

I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers