Clustered and Non-Clustered Index in SQL Server
What is a clustered index? What is a non-clustered index? And how are they different?
They are two types of indexes in SQL Server.
Learn what they are and see some examples in this guide.
How to Convert DATETIME to DATE in SQL Server
Do you have a DATETIME value in SQL Server that you want to convert to a DATE, or only get the DATE component?
You can do that in SQL Server. There are several ways to do it. I’ll show you how in this article.
How to Resolve Column count doesn’t match value count at row 1
Are you getting the error “Column count doesn’t match value count at row 1” in MySQL?
In this article, I’ll show you how to resolve this error, as well as what it means, and some examples.
Let’s take a look.
How to Start MySQL Server on Mac, Windows, and Linux
Do you want to know how to start, stop, and restart the MySQL server? Learn how you can do that on each operating system in this article.
How to Fix The “Every derived table must have its own alias” Error in MySQL
Are you writing a query in MySQL and getting an error of “1248: Every derived table must have its own alias”? If so, it’s a simple error to fix.
SQL vs MySQL vs SQL Server: What’s the Difference?
If you’re learning software development you might have heard of the terms SQL and MySQL. And you might be wondering, what’s the difference? Also, what does SQL Server mean and is it the same thing?
Introduction to SQL Server
Do you want to learn SQL?
You’ve come to the right place.
On this page, you’ll find videos, links, and information for the Introduction to SQL Server course. It covers the beginner level topics in my SQL Roadmap.
So, keep reading to see what you’ll learn and watch the videos in this course. (more…)
How to Install Oracle on a Mac (2020)
In this post, you’re going to learn the exact steps to take to install Oracle on your Mac computer.
This guide includes:
- step-by-step instructions on downloading and setting up the required software
- screenshots at each stage
- explanations of the configurations you need to set (such as connecting to the database)
So if you want to set up Oracle on your Mac computer, you’ll love this guide.
Let’s get right into it.
The Ultimate Guide to Database Version Control, CI/CD, and Deployment
Using a source code repository for your application code is common practice.
Automated testing and build, commonly known as Continuous Integration and Deployment, is something a lot of organisations are working towards.
Version control and deployments often only focus on application code, with database changes following a separate process.
In this guide, I'll explain that there's a better way to handle changes to your database and how to get it under version control, tested, and deployed along with application code.
70 Software Development Companies Share Advice for Client and Project Success
Companies that develop custom software for other companies have a lot of experience working with their clients. In this article, I’ve asked a range of them to provide their advice for working with clients.
