Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.

Back to Basics

by Steve Jones

SQLServerCentral

Career Growth

The basics are important for all of us as we expand our knowledge.

Should You Learn R or Python?

by Steve Jones

SQLServerCentral

Both Python and R have become very popular languages in the last few years, especially among data professionals. Which should you learn or use? Steve has a few thoughts.

SQL Server 2016 - Always Encrypted

by Anil

SQLServerCentral

Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows clients to encrypt sensitive data, such as credit card numbers and national identification numbers, inside the […]

Creating Idempotent DDL Scripts for Database Migrations

by Additional Articles

Redgate

Vendors/3rd-party Products

How to write idempotent DDL scripts that Flyway can run several times on a database, such as after a hotfix has already been applied directly to the production database, without causing errors.

SQL Server plan cache mining – Plan attributes

by Additional Articles

SimpleTalk

Performance

Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues.

Hidden Pitfalls with INNER JOIN and NOT IN Operators

by MMartin1

SQLServerCentral

I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. There are a couple of hidden dangers here […]