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.
Read more »
Dynamic SQL in SQL Server
August 15, 2019In this article, we will review how to construct and execute dynamic SQL statements in SQL Server with different examples.
Read more »
Overview of the Shrink TempDB database in SQL Server
August 15, 2019This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server
Read more »
Calculate SQL Percentile using the PERCENT_RANK function in SQL Server
August 15, 2019This article explores the SQL Server PERCENT_RANK analytical function to calculate SQL Percentile and its usage with various examples.
Read more »
SQL Server Installation & Troubleshooting on Ubuntu
August 15, 2019A 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.
Read more »
An efficient approach to process a SSAS multidimensional OLAP cube
August 15, 2019Introduction
While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation:
Read more »
SQL Server Statistics and how to perform Update Statistics in SQL
August 13, 2019This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.
Read more »
Monitoring SQL Server deadlocks using the system_health extended event
August 12, 2019Performance 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.
Read more »
Windows Failover Cluster Quorum Modes in SQL Server Always On Availability Groups
August 8, 2019This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups.
Read more »
Snapshot Isolation in SQL Server
August 5, 2019Introduction
In this article, I’ll explore the use of snapshot isolation using row versioning as an alternative to the classic ANSI SQL transaction levels.
Read more »
Naive Bayes Prediction in SQL Server
August 2, 2019In this article, we will walk through Microsoft Naive Bayes algorithm in SQL Server.
Read more »
How to create geographic maps in Power BI using R
August 1, 2019Introduction
This is the fifth article of a series dedicated to discovering geographic map tools in Power BI.
Read more »
SQL STUFF function overview
July 31, 2019This article gives an overview of the SQL STUFF function with various examples.
Read more »
How to configure SAN less SQL Server clusters in AWS EC2 using SIOS DataKeeper
July 30, 2019In this article, we will review how to configure SAN less SQL Server cluster in AWS EC2 instances using SIOS DataKeeper.
Read more »
Implementing Dynamic Data Masking in Azure SQL database
July 30, 2019In 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.
Read more »
FOR XML PATH clause in SQL Server
July 30, 2019As 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.
Read more »
Protecting Azure SQL databases from accidental deletion
July 30, 2019In 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.
Read more »
A complete guide to T-SQL Metadata Functions in SQL Server
July 30, 2019In this article, we will demonstrate T-SQL metadata functions available in the SQL Server.
Read more »
SQL Server stored procedures for beginners
July 29, 2019In this article, we will learn how to create stored procedures in SQL Server with different examples.
Read more »
Max Worker Threads for SQL Server Always on Availability Group databases
July 26, 2019This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases.
Read more »
Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server
July 26, 2019I have seen that SQL developers use varchar(max) data while designing the tables or temporary tables. We might not be sure about the data length, or we want to eliminate the string or binary truncation error.
Read more »
Configuring email notifications in Azure SQL database
July 24, 2019In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
Read more »
Overview of SQL Server Startup Parameters for the SQL Database Engine Service
July 24, 2019In the SQL world, it is an important activity to perform SQL Server installation for a database administrator. Have you ever noticed ‘SQL Server Startup Parameters’ for the SQL Service? You might not have noticed them, but these parameters are beneficial for DBAs.
Read more »
DBCC FREEPROCCACHE command introduction and overview
July 23, 2019This article gives an overview of the SQL Server DBCC FREEPROCCACHE command and its usage with different examples.
Read more »
Overview of the CREATE DATABASE statement in Azure SQL Server
July 23, 2019In this article, we will review CREATE DATABASE statement in the Azure SQL database with various examples.
Read more »