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

Improve Productivity with Collaboration Tools

In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members.

Assigning Result Set Column Names

AdventureWorks2016CTP3 - JSON Sample scripts

Geting the JSON Sample Scripts to run

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.

Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.