Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
2020-09-11
In this article we look at two methods of using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets.
2020-09-08
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
2020-09-03
21,851 reads
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
2020-09-03
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
7,782 reads
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
2020-08-26
In this article we look at different examples of creating SQL Server stored procedures.
2020-08-20
In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.
2020-08-18
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers