How to Get SQL Percentage Calculation as Easy as Pie
Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a...
SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets
Is SQL Server PARTITION BY clause giving you a brain freeze? Beginners feel like entering a complex maze at first glance of code...
T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time
Is it a big deal to choose between CHAR and VARCHAR? What if your choice between CHAR vs. VARCHAR results in a nightmare of query...
How to Download, Install and Restore AdventureWorks Database in SQL Server
Sometimes, we need a sample database that has all the required objects along with a large set of...
What is SQL Server? (Definition, Versions, Editions)
Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You...
SSDT (SQL Server Data Tools) for Visual Studio: Main Features
SQL Server provides SQL Server developers and administrators with dedicated client tools for day-to-day usage. Namely, they are SQL Server...
Get Your SQL Server Database Size with Ease: Stored Procedures in Action
As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
The Importance of SQL Server Data Tools (SSDT)
Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we...
Machine Learning {.NET} Image Classification
One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build...
How to Read and Interpret SQL Errors
Error codes in SQL are generated by the server to provide information about what has gone wrong....
