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...
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 data inside the database for our various...
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...
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 deployments of SQL Server that still require our...
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...
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. They have different meanings depending on...
Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on...