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
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
There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what principal, securables, and permissions are.
According to Microsoft Documentation,
- Securables in SQL Server context are specific resources to which the SQL Server Database Engine authorization system controls access. They are divided into three categories: Server, Database and Schema. In general, any SQL Server or database objects can be securables.
- Permissions are controls using which we assign grant or deny certain level of access to a securable.
- Principal is an entity that receives permission to a securable. The most common principals are logins and database users.
Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create, they make your data better suitable for reporting purposes. To understand these query types, you must first have some knowledge of logical operators.
A logical operator allows you to combine two or more statements into one. Also, it lets you control the results based on certain conditions. It makes your queries incredibly powerful tools for creating customized reports of your data. This post will focus specifically on one type: the OR Operator.Read More