sp_updatestats overview and usage

August 20, 2019 by Esat Erkec

In this article, we will learn usage details of the sp_updatestats built-in store procedure which helps to update all statistics in a SQL Server database. First of all, we will take a glance at the statistics concept in SQL Server.

Performance Monitoring via SQL Server Query Store

August 19, 2019 by Ben Richardson

SQL Server Query Store is a performance monitoring tool that helps us evaluate the performance of a SQL query in terms of several different performance metrics such as CPU and Memory Consumption, execution time and the I/O cycles consumed by the query. Query store is similar to the windows “Task Manager”. A task manager provides information about the CPU, Memory, Network and Disc consumption of a process. Similarly, the Query Store provides insight to similar information.

Using Logistic Regression in Azure ML for Predicting Customer’s Loan Eligibility

August 19, 2019 by Ben Richardson

This article aims to provide the basics of creating Logistic Regression in Azure ML by designing a simple model step-by-step.

Understanding Graph Databases in SQL Server

August 16, 2019 by Ben Richardson

A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example.

SSIS Conditional Split Transformation overview

August 16, 2019 by Rajendra Gupta

This article explores the SSIS Conditional Split Transform task to split data into multiple destinations based on the specified conditions.

SQL Server Merge Replication on Linux

August 15, 2019 by Jignesh Raiyani

Replication is a process to manage multiple copies of the same data at a different node. Microsoft SQL Server supports Merge Replication, Transaction Replication, Peer to Peer Replication and Snapshot Replication.

Dynamic SQL in SQL Server

August 15, 2019 by Ranga Babu

In this article, we will review how to construct and execute dynamic SQL statements in SQL Server with different examples.

Overview of the Shrink TempDB database in SQL Server

August 15, 2019 by Rajendra Gupta

This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server

Calculate SQL Percentile using the PERCENT_RANK function in SQL Server

August 15, 2019 by Rajendra Gupta

This article explores the SQL Server PERCENT_RANK analytical function to calculate SQL Percentile and its usage with various examples.

SQL Server Installation & Troubleshooting on Ubuntu

August 15, 2019 by Jignesh Raiyani

A couple of years ago, Microsoft announced that SQL Server would be available on Open Source (Linux). In this article, we will go through the installation of Microsoft SQL Server on Linux (Ubuntu) and each step in detail.

An efficient approach to process a SSAS multidimensional OLAP cube

August 15, 2019 by Hadi Fadlallah

Introduction

While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation:

SQL Server Statistics and how to perform Update Statistics in SQL

August 13, 2019 by Rajendra Gupta

This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.

Monitoring SQL Server deadlocks using the system_health extended event

August 12, 2019 by Rajendra Gupta

Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases. Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, waits, and SQL Server deadlocks. You might face frequent deadlocks issues, and they have a direct impact on the application performance.

Windows Failover Cluster Quorum Modes in SQL Server Always On Availability Groups

August 8, 2019 by Rajendra Gupta

This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups.

Snapshot Isolation in SQL Server

August 5, 2019 by Gerald Britton

Introduction

In this article, I’ll explore the use of snapshot isolation using row versioning as an alternative to the classic ANSI SQL transaction levels.

Naive Bayes Prediction in SQL Server

August 2, 2019 by Dinesh Asanka

In this article, we will walk through Microsoft Naive Bayes algorithm in SQL Server.

How to create geographic maps in Power BI using R

August 1, 2019 by Andrea Martorana Tusa

Introduction

This is the fifth article of a series dedicated to discovering geographic map tools in Power BI.

SQL STUFF function overview

July 31, 2019 by Rajendra Gupta

This article gives an overview of the SQL STUFF function with various examples.

How to configure SAN less SQL Server clusters in AWS EC2 using SIOS DataKeeper

July 30, 2019 by Ranga Babu

In this article, we will review how to configure SAN less SQL Server cluster in AWS EC2 instances using SIOS DataKeeper.

Implementing Dynamic Data Masking in Azure SQL database

July 30, 2019 by Ranga Babu

In this article, we will review Dynamic Data Masking in the Azure SQL database. Dynamic Data Masking is a feature to limit the sensitive data to the non-privileged users by hiding the data of a column. Data is not masked and stored in the disk. Masking is applied to the result set returned to the user. The users with “db_owner” permission on “UNMASK” permission can still see the unmasked data when they query the table.

FOR XML PATH clause in SQL Server

July 30, 2019 by Rajendra Gupta

As SQL professionals, we often have to deal with XML data in our databases. This article will help you walk through several examples of using ‘FOR XML PATH’ clause in SQL Server.

Protecting Azure SQL databases from accidental deletion

July 30, 2019 by Ranga Babu

In this article, we will review options called LOCKS in Azure SQL database and Azure SQL Server that are used to protect databases or servers from accidental deletes or configuration changes.