IG

Featured

How to Downgrade SQL Database from Enterprise to Standard Edition

If you want to Restore a SQL Server 2014/2016 backup from a higher version of SQL to a lower version, i.e. from Enterprise to Standard Edition, you can do so, but before you do...

Featured
SQL Server Express Interview Questions

SQL Server Express Interview Questions

SQL Server Express Interview Questions SQL Server Express is a free redistributable database from Microsoft to take advantage of the same powerful database engine in its bigger...

Featured
SQL Server Replication Interview Questions

SQL Server Replication Interview Questions

With the introduction of SQL Server High Availability options like Availability Groups, Database Mirroring, Clustering etc. the role and the magnitude of SQL Server replication...

Featured
SQL Server High Availability Interview Questions

SQL Server High Availability Interview Questions

In this post, we are going to talk about SQL Server High Availability Interview Questions. It will cover topics like Clustering, Shared Storage, Log Shipping, Database Mirroring,...

Featured

List of SQL Server Versions Build Numbers and Service Packs

List of SQL Server Versions Build Numbers and Service Packs: In this post, we have an Unofficial complied list of all known SQL Server Releases with additional metadata like file...

Featured
SQL Server DBA Backup Interview Questions

SQL Server DBA Backup Interview Questions

SQL Server DBA Backup Interview Questions focuses on one of the most common tasks that a DBA does on a day to week schedule. We are covering one of the most common interview...

Featured
SQL Server DBA Setup Interview Questions

SQL Server DBA Setup Interview Questions

In this post, we are covering SQL Server DBA Setup Interview Questions. If you are for both Aspiring and Experienced professionals. These questions are generally targeted at DBAs...

Featured
SQL Server T-SQL Fundamental Interview Questions

SQL Server T-SQL Fundamental Interview Questions

In this post we will focus on SQL Server T-SQL Fundamental Interview Questions which can form the base for getting started with a SQL Server Developer Interview.

Featured
SQL Server Database Fundamentals Interview Questions

SQL Server Database Fundamentals Interview Questions

SQL Server Database Fundamentals Interview Questions cover the basics of a relational database engine independent of a vendor. This is just to get you started with the interview...

Featured
How to find SQL Server Product Key

How to Find SQL Server Product Key

When you install SQL Server, you would be prompted to enter a product key to install the correct Edition of SQL Server (2016, Enterprise, Standard, etc.). You will not find the...