Blog Posts - SQLServerCentral

A storage failover issue with SQL Server on Kubernetes (Mon, 26 Jul 2021)
I’ve been running a proof of concept for SQL Server on Kubernetes over the last year or so (ok, probably longer than that…hey, I’m a busy guy ?? )... The post A storage failover issue with SQL Server on Kubernetes appeared first on SQLServerCentral.
>> Read more

Complete Guide for Virtual Machine in Google Cloud Platform with Demo (Mon, 26 Jul 2021)
Complete Guide for Virtual Machine in Google Cloud. 1) Understanding of Compute Instances in GCP 2) Preemptible & Shielded VM Instances 3) Live Migration of VM instances in GCP 4) Compute Engine Dashboard... The post Complete Guide for Virtual Machine in Google Cloud Platform with Demo appeared first on SQLServerCentral.
>> Read more

News and Notes on the Structured Query Language

SQL learning and practice resource (Mon, 26 Jul 2021)
>> Read more

Help for Install SQL in my Chromebook, plss! (Tue, 27 Jul 2021)
>> Read more

blog – Essential SQL

Duplicate Rows in SQL – Find using Window Functions (Sun, 06 Jun 2021)
If you want to find duplicate rows in SQL, you can go two routes. The first is to use the GROUP BY and HAVING to identify “duplicate” groups of data, or you can use a easy to understand window function to not only identify the duplicates but also its primary key. In this video I’ll […] The post Duplicate Rows in SQL – Find using Window Functions appeared first on Essential SQL.
>> Read more

Database Normalization – in Easy to Understand English (Sat, 08 May 2021)
Database normalization is a process used to organize a database into tables and columns. There are three main forms: first normal form , second normal form, and third normal form. The main idea is each table should be about a specific topic and only supporting topics included. Take a spreadsheet containing the information as an […] The post Database Normalization – in Easy to Understand English appeared first on Essential SQL.
>> Read more

Database Tutorials

How To Connect Azure Database From SQL Management Studio and from Azure Portal (Sat, 26 Jun 2021)
We will learn how to connect azure database from sql management studio and from azure portal in this article. How to connect to azure sql database from azure portal How to connect azure database from sql management studio How To Connect to Azure SQL Database from Azure Portal Step1: Select Query Editor(preview) from the dmcdbpshell … The post How To Connect Azure Database From SQL Management Studio and from Azure Portal appeared first on Database Tutorials.
>> Read more

SQL Server Configuration Manager Not Found (Mon, 03 May 2021)
SQL Server Configuration Manager may not found on your server event if you installed SQL Server on that server. If you have installed any version of SQL Server, and you need to change the service account or port or anything, you searched SQL SERVER Configuration Manager in the search section. Or you can find different … The post SQL Server Configuration Manager Not Found appeared first on Database Tutorials.
>> Read more