SQL Server Update Statistics using database maintenance plans
April 13, 2020This article explores SQL Server Update Statistics using the database maintenance plan.
Search Results for: performance
Fuzzy Lookup Transformations in SSIS
April 10, 2020This article helps you to understand the usage of the Fuzzy Lookup Transformation in SQL Server Integration Services (SSIS).
An overview of Chart Types in Power BI
April 9, 2020In this article, I am going to give an overview of the most widely used chart types in Power BI. Power BI, as everyone might be aware, is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and […]
Start your journey with Azure Cosmos DB
April 6, 2020In this article, we will discuss why we need to use Azure Cosmos DB and how to configure it to store and query our data.
Table-Valued Parameters in SQL Server
April 6, 2020Table-Valued Parameters aka TVPs are commonly used to pass a table as a parameter into stored procedures or functions. They are helpful in a way, we can use a table as an input to these routines and we can get rid of dealing more complex steps to achieve this process.
Warnings in SSAS Cubes
April 3, 2020In this article, I’m going to list out some of the most common warnings we encounter while developing SSAS Cubes and the reason for those warnings. As you are aware, SSAS cubes are developed using the SQL Server Data Tools (SSDT) for Analysis Services (Visual Studio), all the examples will be taken from Visual Studio […]
Accessing Azure Blob Storage from Azure Databricks
April 2, 2020We introduced Azure Databricks, how it is created and some of its important components in my previous article here. We will look at how we can work with Azure Blob Storage in Azure Databricks in this article.
CREATE VIEW SQL: Working with indexed views in SQL Server
March 24, 2020This 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.
An overview of the sp_WhoIsActive stored procedure
March 23, 2020This article gives a comprehensive overview of custom stored procedure sp_whoisactive.
SQL Server TOP clause overview and examples
March 19, 2020This 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, 2020This 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.
Monitoring activities using sp_WhoIsActive in SQL Server
March 16, 2020In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.
Learn SQL: SQL Views
March 11, 2020SQL views are another powerful database object we have at our disposal. In the previous two articles of this series, we’ve talked about user-defined functions and user-defined procedures and showed simple examples of how to use them. Today, we’ll do the same for the SQL views.
A comprehensive guide to the SQL Format function
March 11, 2020This article explains the usage of SQL Format function and performance comparison with SQL CONVERT.
Database Design and Logical Asseveration for SQL Query Optimization
March 11, 2020Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate.
Execution Plans in SQL Server
March 10, 2020Introduction In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the details of an execution plan by reading the various metrics available once we hover over the components in the plan.
How to determine free space and file size for SQL Server databases
March 9, 2020In this article, we will discuss the actual database file size and free space in the database file size with the help of monitoring script and shrink solutions. While creating a database initial size of the database files (Data File and Log File) can be defined by us, with the Autogrowth and MAXSIZE parameter. The […]
Learn SQL: User-Defined Stored Procedures
March 5, 2020Stored procedures (SPs) are one more powerful database object we have at our disposal. They can help us handle many tasks and improve performance and security. Today, we’ll take a look at simple SPs and show, on examples, how to use them.
SQL Server Auto Shrink database property
March 5, 2020In this article, we will discuss the SQL Server Auto Shrink database property, which allows SQL Server to automatically shrink the database files when the value is configured as True in the database option. Automatic shrink operation is done by the server auto shrink database feature, which is the main course of this article.
Implementing Star Schemas in Power BI Desktop
March 4, 2020In this article, you will see how to implement a star schema in Power BI. Microsoft Power BI is a business analytics tool used to manipulate and analyze data from a variety of sources.
SQL Server Query Store options in SSMS 18.4
March 4, 2020In this article, we will run through the new options added in the Query Store with SSMS v18.4.
Overview of the T-SQL If Exists statement in a SQL Server database
March 3, 2020This article walks through different versions of the T-SQL IF EXISTS statement for the SQL database using various examples.
Azure Data Explorer for beginners
February 27, 2020This article discusses what exactly an Azure Data Explorer is and its important features. We will also walk through the Kusto query language and explore a sample data in the Data Explorer in Azure.
SQL CROSS JOIN with examples
February 24, 2020In this article, we will learn the SQL CROSS JOIN concept and support our learnings with straightforward examples, which are explained with illustrations.
Microsoft Clustering in SQL Server
February 20, 2020Microsoft Clustering is the next data mining topic we will be discussing in our SQL Server Data mining techniques series. Until now, we have discussed a few data mining techniques like: Naïve Bayes, Decision Trees, Time Series, and Association Rules.