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 will go through various Client Tools offered by SQL Server itself and learn about SQL Server Data Tools and its hidden potentials to make the lives of DBAs and Developers easier.Read More
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 you can create parameterized paginated reports that display filtered data based on some parameter values.Read More
Amazon Web Service environment is a fully digital experience of a typical brick-and-mortar data center. All components, such as firewalls or load balancers, are fully digitalized. Likewise, all of the services that AWS offers, such as Elastic Compute servers, databases, or Lambda functions live within that ecosystem.
When running any type of service within Amazon Web Services, it is important to understand the concept of the Virtual Private Cloud (VPC). It tightens security around your services and helps with communication between multiple services.Read More
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 – note that it applies to numeric columns only.
Below is the syntax of SQL SUM.Read More
SQL 2017 introduced the ability to pause and resume index rebuild operations during database maintenance. This feature offers more flexibility to database administrators as it allows them to choose between offline and online reindexing along with pausing and resuming the index rebuild whenever needed.Read More
One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build our own “Hotdog, not hotdog” solution using ML.NET. After all, who would not want to determine if that dish is, or is not a hot dog? Just take a picture, upload it to the web or desktop application, and get results with almost 90% certainty in a second.
Although some may say this is not a very useful application, it is a fun way to explore another machine learning concept through ML.NET. I covered installing and getting started with ML.NET in Visual Studio in my previous article, so refer to it if you missed it.Read More
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results?
Some say it’s good and add DISTINCT when duplicates appear. Some say it’s bad and suggest using GROUP BY without an aggregate function. Others say DISTINCT and GROUP BY are the same when you need to remove duplicates.
This post will dive into the details to get correct answers. So, eventually, you will use the best keyword based on the need. Let’s begin.Read More
Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload. Azure SQL Database is one of the popular PAAS services for RDBMS, always based on the latest stable version of the SQL Server database engine release.Read More
Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on the SQL version you’re using, but they usually indicate the inability to perform a requested operation.Read More
The current article is the first part of the series about designing a simple data warehouse business intelligence solution in Azure from scratch. Here we are going to get the basic knowledge and prerequisites along with the initial setup of the data warehouse.Read More