T-SQL scripts to identify unused database files
October 30, 2020In this article, I am going to show how we can automate the report of unused database files using T-SQL.
Search Results for: INSERT
Explore secrets of the SQL Server tempdb database
October 29, 2020In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases. When we take into account all of these features of the tempdb, there is […]
Copy data between Azure data stores using Azure Data Factory
October 27, 2020In the previous article, Starting your journey with Microsoft Azure Data Factory, we discussed the main concept of the Azure Data Factory, described the Data Factory components and showed how to create a new Data Factory step by step.
T-SQL scripts to generate database health reports
October 21, 2020In this article, I am going to show how we can automate a database daily health report using T-SQL scripts. For a senior database administrator, it is always important to review the health of the database server. When a DBA manages many database servers, it becomes difficult to visit every server and review the status […]
SQL Server Clustered Indexes internals with examples
October 14, 2020In this article, we will learn the SQL Server clustered index concept and some internal details. Indexes are the database objects that accelerate the performance of data accessing when are designed properly. A clustered index is one of the main index types in SQL Server and the working principle is a bit complicated but in […]
Building databases using Biml
October 14, 2020In the previously published articles in this series, we talked about the Business Intelligence Markup Language (BIML) and how to use the technology to build and manage SQL Server Integration Services (SSIS) packages. Besides managing SSIS packages, we can also manage SSAS models and build databases using BIML.
An overview of the db_datareader role
October 12, 2020In this article, we are going to learn about the db_datareader role. It is a fixed, database-level role. The database-level roles are a group of security principals that are used to manage the permissions within the databases more efficiently. There are two types of database-level roles. One is a predefined database-level role, and another is […]
Column-level SQL Server encryption with SQL Server Always On Availability Groups
October 12, 2020It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups.
Performing a Load Test on SQL Server using Apache JMeter
October 7, 2020In this article, we will learn how to use Apache JMeter to perform a load test on SQL Server. This test type enables us to measure the application behaviors under specific conditions so that it enables us to observe a variety of resource consumptions (CPU, memory, latency, response times, etc) and it also helps to […]
![user database [LinuxAGSQL]](https://s33046.pcdn.co/wp-content/uploads/2020/10/user-database-linuxagsql-624x475.png)
Restore a SQL database from Windows SQL Server to SQL Server Linux instance
October 5, 2020Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.
Learn SQL: Non-Equi Joins in SQL Server
September 29, 2020Non-Equi join in SQL Server sounds like something abstract (and fancy), but it’s not so abstract (and fancy) at all. The same stands for equi joins. After reading this article, I hope you’ll agree on that with me. Today’ I’ll try to explain what they are and when you should use them. So, let’s start.
Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups
September 29, 2020In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.
Improve SQL Server transaction log performance with Delayed Durability
September 29, 2020In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server.
Identify unused tables of SQL databases
September 24, 2020In this article, I am going to demonstrate how we can identify the unused tables of a given SQL Database. As a database administrator, we must maintain the tables and objects of the SQL Database. In my organization, when we add a new column or change the data type of a column, we export the […]
Learn MySQL: Delete and Update Statements
September 18, 2020In this article, we are going to learn how we can update and delete data using Delete and Update statements. In my previous articles, we have learned how we can insert data using INSERT statement, and sort and filter data using WHERE and ORDER BY statements.
How to prepare for the Exam DP-200: Implementing an Azure Data Solution
September 16, 2020In this article, we will show how to prepare yourself for one of the important Microsoft Azure exams, DP-200: Implementing an Azure Data Solution certificate exam.
Deploy MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 7, 2020In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group.
Explore Cross-database MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 4, 2020In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group.
Understanding Data Lineage in ETL
September 3, 2020In this article, I am going to explain what Data Lineage in ETL is and how to implement the same. In this modern world, where companies are dealing with a humongous amount of data every day, there also lies a challenge to efficiently manage and monitor this data. There are systems that generate data every […]
Learn SQL: SQL-Related Jobs
September 1, 2020In today’s article, we’ll take a look at 4 common SQL-related jobs and roles and explain what kind of tasks you could expect at each of these roles and what types of queries you’ll possibly use to solve these tasks. If you’re already in any of these roles, you’re probably familiar with this, but if […]
Configure SQL Server replication for a database in SQL Server Always On Availability Groups
August 31, 2020This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs.
Enhancing Customer Experiences with Subscriptions in SSRS
August 28, 2020Introduction We are going to discuss a very important option in SQL Server Reporting Services (SSRS), which is Subscriptions in SSRS. Typically, Reporting service is used to view reports. However, most users would prefer to receive the report to their inbox in the preferred report format, such as Word, Excel, or PDF in a preferred […]
Test-driven database hotfix development (TDHD) with SQL unit test based framework (tSQLt)
August 24, 2020This article talks about test-driven database hotfix development using a very productive database testing framework called tSQLt applying the same SQL unit test based approach.
Exploring databases in Python using Pandas
August 24, 2020In this article, I am going to cover in detail working with databases in Python using Pandas and SQLAlchemy. This is a part of the series Learn Pandas in Python where I talk about the various techniques to work with the Pandas module in Python.
Introduction to SQLAlchemy in Pandas Dataframe
August 20, 2020In this article, I am going to demonstrate how to connect to databases using a pandas dataframe object. Pandas in Python uses a module known as SQLAlchemy to connect to various databases and perform database operations. In the previous article in this series “Learn Pandas in Python”, I have explained how to get up and […]