Introduction to Row-Level Security in SQL Server

March 31, 2020 by Aveek Das

In this article, I’m going to discuss Row-Level Security in SQL Server. RLS or Row-Level Security as the name suggests is a security mechanism that restricts the records from a SQL Server table based on the authorization context of the current user that is logged in. This means the records from the tables are displayed based on who the user is and to which records do the user has access to. This is usually done to allow specific users to have access to their data only without permission to view other users’ data.

Overview of Solutions and Projects in SSMS

March 30, 2020 by Rajendra Gupta

DBAs and developers manage a broad set of queries, codes, applications. It is a good practice to organize code or t-SQL scripts so that we can easily access them without wasting time searching for them. You might use Visual Studio, GitHub source control for it. In this article, we look at how Solutions and Projects help to organize T-SQL scripts.

Working with SQL Server ROWCOUNT

March 30, 2020 by Ahmad Yaseen

In this article, we will discuss the SQL Server @@ROWCOUNT and ROWCOUNT system objects by going through practical examples that cover most of these system objects usage.

How to use a Web data source in Power BI Desktop reports

March 30, 2020 by Rajendra Gupta

This article explores various ways to use a Web data source in Power BI Desktop reports.

Learn to write basic SQL Queries

March 27, 2020 by Esat Erkec

Essentially, SQL language allows us to retrieve and manipulate data on the data tables. In this article, we will understand and gain the ability to write fundamental SQL queries. At first, we will take a glance at the main notions that we need to know about in order to write database queries.

INSERT INTO T-SQL Statement in SQL Server

March 27, 2020 by Ahmad Yaseen

In this article, we will go deeply through the INSERT INTO statement by showing the different syntax formats and usage scenarios for that statement.

Introduction to Many-to-Many Relationships in SSAS

March 26, 2020 by Aveek Das

In this article, I’m going to explain what many-to-many relationships in SSAS are and how to implement the same in a SQL Server Analysis Services (SSAS) project. For the sake of this article, we will only consider the Multidimensional Cube and not the Tabular. Also, this article assumes that you have some fair knowledge of building SSAS cubes from scratch.

Biml alternatives: Building SSIS packages programmatically using EzAPI

March 26, 2020 by Hadi Fadlallah

In the previously published article, Biml alternatives: Building SSIS packages programmatically using ManagedDTS, we talked about building SSIS packages using the managed object model of the SSIS engine (ManagedDTS). In this article, we will illustrate another Biml alternative, which is the EzApi class library, and we will make a comparison between both technologies.

Learn SQL: Practice SQL Queries

March 25, 2020 by Emil Drkusic

Today is the day for SQL practice #1. In this series, so far, we’ve covered most important SQL commands (CREATE DATABASE & CREATE TABLE, INSERT, SELECT) and some concepts (primary key, foreign key) and theory (stored procedures, user-defined functions, views). Now it’s time to discuss some interesting SQL queries.

Biml alternatives: Building SSIS packages programmatically using ManagedDTS

March 25, 2020 by Hadi Fadlallah

In the previously published articles in this series, we have explained how to use Biml to create and manage SQL Server Integration Services (SSIS) packages. In this article, we will talk about the first alternative of this markup language which is the Integration Services managed object model (ManagedDTS and related assemblies) provided by Microsoft.

In this article, we will first illustrate how to create, save and execute SSIS packages using ManagedDTS in C#, then we will do a small comparison with Biml.

Removing duplicates in an Excel sheet using Python scripts

March 24, 2020 by Rajendra Gupta

In the article, Python scripts to format data in Microsoft Excel, we used Python scripts for creating an excel and do various data formatting. Python is an interesting high-level programming language. You can go through various use cases of Python on SQLShack.

Microsoft Linear Regression in SQL Server

March 24, 2020 by Dinesh Asanka

In this article, we will be discussing Microsoft Linear Regression in SQL Server. This is the next data mining topic in our SQL Server Data mining techniques series. Naïve Bayes, Decision Trees, Time Series, Association Rules, and Clustering are the other techniques that we discussed until today.

CREATE VIEW SQL: Working with indexed views in SQL Server

March 24, 2020 by Bojan Petrovic

This is the fourth article in a series of learning the CREATE VIEW SQL statement. So far, we have done a great deal of creating and altering views using T-SQL. In this last part, I want to take a big look at how to work with indexed views.

Solve Time Zone, GMT, and UTC problems using the T-SQL Toolbox database

March 23, 2020 by Frank Solomon

Introduction

Soon enough, the applications and database software we build will handle date and time values. The T-SQL Toolbox database – a free download – can help solve complex calculations with those values.

How to drop temp tables in SQL Server

March 23, 2020 by Esat Erkec

Temporary tables, also known as temp tables, are widely used by the database administrators and developers. However, it may be necessary to drop the temp table before creating it. It is a common practice to check whether the temporary table exists or not exists. So, we can eliminate the “There is already an object named ‘#temptablename’ in the database” error during the temporary table creation.

An overview of the sp_WhoIsActive stored procedure

March 23, 2020 by Rajendra Gupta

This article gives a comprehensive overview of custom stored procedure sp_whoisactive.

Learn SQL: SQL Triggers

March 20, 2020 by Emil Drkusic

SQL Triggers are another powerful database object we have at our disposal. In previous articles, we’ve covered user-defined functions, user-defined procedures, and SQL Views. Today we’ll talk about SQL triggers and how to use them to achieve the desired behavior.

Visualize Coronavirus impact using a Power BI Dashboard

March 20, 2020 by Rajendra Gupta

This article demonstrates Power BI visuals for visualizing Coronavirus impact worldwide using various visuals such as a filled map, Word Cloud, Slicer, Q&A.

Setting up Power BI Data Gateway

March 19, 2020 by Aveek Das

In this article, I’m going to explain what a Power BI Data Gateway is and how to set it up. I’ll also cover the underlying architecture that the gateway uses and how to manage on-premise data using the Data Gateway.

How to install MySQL database server 8.0.19 on Windows 10

March 19, 2020 by Nisarg Upadhyay

In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.

SQL Server MAX() aggregate function

March 19, 2020 by Ahmad Yaseen

SQL Server provides us with several aggregate functions that can be used to perform different types of calculations on a set of values, and return a single value that summarized the input data set. These SQL Server aggregate functions include AVG(), COUNT(), SUM(), MIN() and MAX().

SQL Server TOP clause overview and examples

March 19, 2020 by Rajendra Gupta

This article explores the SQL Server TOP clause using various examples, along the way, we will also run through performance optimization while using the TOP clause in SQL Server.

A beginner’s guide to Azure Databricks

March 18, 2020 by Gauri Mahajan

This article serves as a complete guide to Azure Databricks for the beginners. Here, you will walk through the basics of Databricks in Azure, how to create it on the Azure portal and various components & internals related to it.

An overview of the SSIS FTP Task

March 18, 2020 by Hadi Fadlallah

In this article, we will explain the File Transfer Protocol (FTP), and we will give an overview of the FTP task in SQL Server Integration Services (SSIS) and FTP connection manager.

Conditional formatting in Power BI

March 18, 2020 by Aveek Das

In this article, I’m going to explain what conditional formatting in Power BI is. Conditional formatting, as the name suggests, is a way of visualizing data that applies special format rules based on some pre-defined conditions on the values of a selected metric. It is mostly used when the data is presented in a tabular format; however, it can also be used in any charts such as bar charts, line charts, etc.