This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.

The Age of Multiple Databases

by Steve Jones

SQLServerCentral.com

Editorial

There are lots of databases to choose from. Steve discusses using more of them in your work.

T-SQL Window Functions and Performance

by Additional Articles

SimpleTalk

T-SQL

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.

Explicit Transactions

by Steve Hall

SQLServerCentral.com

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.

The MVP Award Looks Backward

by Steve Jones

SQLServerCentral.com

Editorial

Steve has a few thoughts on the Microsoft MVP award.

What to Do When SQL Server is Slow

by Additional Articles

Brent Ozar Blog

SQL Server

Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.

AI Regulators

by Steve Jones

SQLServerCentral.com

Editorial

AI may help enforce the GDPR.

Generating Completely Random Sample Output from a Dataset

by Adam Aspin

SQLServerCentral.com

T-SQL

This short article shows a simple example of how to generate completely random sample output from a Dataset

Principles of Data Protection

by Additional Articles

SimpleTalk

Data Privacy and Protection

Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege.