Database administation

How to Download, Install and Restore AdventureWorks Database in SQL Server

Database administation

Sometimes, we need a sample database that has all the required objects along with a large set of...
Read More

What is SQL Server? (Definition, Versions, Editions)

Database administation, Database development

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...
Read More

SSDT (SQL Server Data Tools) for Visual Studio: Main Features

Database administation, Database Optimization & Structure

SQL Server provides SQL Server developers and administrators with dedicated client tools for day-to-day usage. Namely, they are SQL Server...
Read More

Stored Procedure to Get Server Storage Information in Server

Database administation, Memory Optimization

As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
Read More

The Importance of SQL Server Data Tools (SSDT)

Database administation, Tools & technologies, Work with data

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...
Read More

Machine Learning {.NET} Image Classification

Automation, Database administation

One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build...
Read More

How to Read and Interpret SQL Errors

Troubleshooting Issues

Error codes in SQL are generated by the server to provide information about what has gone wrong....
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administation, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Read More

Reset the Root Password of MySQL on Windows

Database administation, MySQL, Security

When we install MySQL on Windows, we usually specify the password of the root user. This helps keep the MySQL Server secured. Suppose you...
Read More

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

Database administation, Security

There are multiple instances when we want to check the permission on a securable for a principal....
Read More
Close