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...
Stored Procedure to Get Server Storage Information in Server
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....
Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Reset the Root Password of MySQL on Windows
When we install MySQL on Windows, we usually specify the password of the root user. This helps keep the MySQL Server secured. Suppose you...
Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases
There are multiple instances when we want to check the permission on a securable for a principal....