In 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.
Read more »
Explore failover types in SQL Server Always On Availability Groups
September 29, 2020In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.
Read more »
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.
Read more »
Suppress successful login and backups messages from the error log for SQL databases
September 28, 2020In this article, we will explore the method to suppress successful login and backups messages in the error log for SQL databases.
Read more »
Scalar UDF Inlining in SQL Server 2019
September 28, 2020In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.
Read more »
Explore branches in Git Source Control
September 28, 2020In this 5th article of the Source Control series, we will explore the concept of branches in a Git source control and GitHub repositories.
Read more »
How to prepare for the Exam AZ-104: Microsoft Azure Administrator
September 28, 2020In this article, we will discuss how to prepare yourself for the Microsoft Azure Administrator certification exam.
Read more »
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 data of the existing table in the backup table. Often, we forgot to review and maintain those backup tables. So as a solution, we decided to create a SQL Job that populates the list of unused tables and email the list to the DBA Team for review.
Read more »
Explore Manual Snapshots in AWS RDS SQL Server
September 23, 2020In this article, we explore the use of manual snapshots in AWS RDS SQL Server.
Read more »
Suspend and Resume Data Movement in SQL Server Always On Availability Groups
September 23, 2020In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.
Read more »
Configure SQL Server Reporting Services databases in SQL Server Always On Availability Groups
September 22, 2020This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases.
Read more »
Data Disaster Recovery with Log Shipping
September 22, 2020Introduction
In SQL Server, Log Shipping can be used to implement a Data disaster recovery mechanism. Typically, log shipping is used as a disaster recovery option which is implemented at many organizations due to its simplicity among many other factors.
Read more »
Refresh SQL Server Always On Availability Group databases using DBATools PowerShell
September 21, 2020In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose.
Read more »
How to prepare for the Exam DP-201: Designing an Azure Data Solution
September 21, 2020In this article, we will discuss how to prepare yourself for an important Microsoft Azure exam: Designing an Azure Data Solution (DP-201).
Read more »
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.
Read more »
Impact of dropping a login in the active directory tied to SQL Server Always On Availability Groups
September 17, 2020This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group.
Read more »
Backup SQL databases on the AWS S3 bucket using Windows PowerShell
September 16, 2020In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.
Read more »
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.
Read more »
Backup compression in TDE enabled databases in SQL Server Always On Availability Groups
September 16, 2020In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database.
Read more »
Configuring ODBC drivers for Azure Database for MySQL
September 15, 2020In this article, I am going to show how we can configure the ODBC driver to connect the Azure Database for MySQL Server. Also, I am going to demonstrate the configuration using the SQL Server Integration Services (SSIS) package.
Read more »
How to parse JSON in SQL Server
September 15, 2020In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function.
Read more »
Manticore search: a continuation of the Sphinx search engine
September 14, 2020In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will provide a step-by-step guide on how to build full-text indexes from SQL Server databases. Finally, we will show how to connect to the Manticore engine from the SQL Server management studio using a linked server object. In our previously published articles in this series, we talked briefly about the Sphinx search engine and how to create full-text indexes from SQL Server databases.
Read more »
How to prepare for the Exam DP-300: Administering Relational Databases on Microsoft Azure
September 14, 2020In this article, we will show how to prepare yourself for the DP-300 exam: Administering Relational Databases on the Microsoft Azure certificate exam.
Read more »
Exporting SSRS reports to multiple worksheets in Excel
September 11, 2020Introduction
SQL Server Reporting Services (SSRS) has multiple options of exporting data into a variety of formats and we will be discussing the options of exporting SSRS Reports to multiple sheets of excel. In SSRS, there are multiple formats available to export reports depending on the user’s needs. Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Tiff file, MHTML (Web Archive), CSV (comma delimited) and XML file with report data are the popular formats that can be exported from SSRS as shown in the below screenshot.
Read more »
Exploring AG dashboards for monitoring SQL Server Always On Availability Groups
September 11, 2020In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes.
Read more »