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.

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,457 reads

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

1 reads

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

531 reads

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

17 reads

Blogs

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Read the latest Blogs

Forums

Azure SQL Managed Instance Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Managed Instance Features

Backing up SQL Express with batch file and SQL procedure.

By mulefeathers

I have a procedure to back up a SQL Express database.  It works when...

Missing cmdlet in powershell module sqlserver

By Burnheart

I have succesfully installed the module sqlserver version 21.1.18235 on my server which hosts...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers