Author: Haroon Ashraf

Haroon's deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He began his professional life as a computer programmer more than 10 years ago working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data. His work and interest revolves around Database-Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration along with Database Life Cycle Management (DLM).

Learn to Perform Product Analysis with SQL Server Full-Text Search. Part 2

Database administration, Search

This article is dedicated to a slightly more complex product analysis with Full-Text Search as...
Read More

Perform Product Analysis using SQL Server Full-Text Search. Part 1

Database administration, Search

This article considers how to perform basic product analysis using Full-Text Search. Additionally, the readers are going to learn some...
Read More

Implementing Full-Text Search in SQL Server 2016 for Advanced Users

Database administration, Search

This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their...
Read More

Implementing Full-Text Search in SQL Server 2016 for beginners

Database administration, Search • One Comment

This article talks about the full-text search and its implementation for the beginners to get...
Read More

Dynamic Data Masking in SQL Server for Advanced Users

Database administration, Work with data

This article gives a high-level understanding of dynamic data masking in SQL Server along with its use cases, best practices and security...
Read More

Dynamic Data Masking in SQL Server for beginners

Database administration, Work with data

The article introduces the basics of dynamic data masking (DDM)  in SQL Server along with its overview supported by a simple example...
Read More

Automating the Tabular Model Processing of Analysis Services (SSAS) Databases in SQL Server

Automation, Database administration

This article talks about automating the processing of the Analysis Services database in SQL Server....
Read More

Automate Database Test Restore in SQL Server

Automation, Database administration, Testing

This article talks about automating the database restoration process which is often done manually by the DBA or the infrastructure team...
Read More

Basics of SQL Server Task Automation

Automation, Database administration

This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard...
Read More

Report Builder Basics for Power Users and IT Professionals

Tools & technologies

This is an introductory article about the Microsoft Report Builder tool which is used to build and...
Read More
Close