Index Column Order – Be Happy!

Ever wonder about index column order; this piece should give some insight.

Cyber Insecurity in Pakistan

Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.

Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.

Have Availability Groups Gotten Easier Lately?

2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.

User access management on DB & object level

It will help to find and manage the users access on DB level

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.

Page considered Suspect in SQL Server 2017

Artificially Intelligent - Text Sentiment Analysis

One of the truisms of the modern data-driven world is that the velocity and volume of data keeps increasing. We’re seeing more data generated each day than ever before in human history. And nowhere is this rapid growth more evident than in the world of social media, where users generate content at a scale previously unimaginable.

Manage the suspect_pages Table on SQL Sever 2017