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...
How to Create Paginated Report in Power BI: Definitive Tutorial
In this article, you will see how to create paginated reports using the Power BI Report Builder tool from Microsoft. You will also see how...
How to Use SQL Server T-SQL Function SUM: 5 Use Cases
The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
SQL Server Resumable Index: Is it good for you?
SQL 2017 introduced the ability to pause and resume index rebuild operations during database...
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...
SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
Azure SQL Elastic Pool – Understanding and Creating
Microsoft Azure offers many PAAS services for addressing the database requirements based on the...
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 a production database between 22nd...
Getting Started with SQL Server
This documentation section presents the topics on SQL Server
