Today Steve talks about the need for a basic level of security in our software.

Optimize SQL Server Query without Changing the Query

by Additional Articles

MSSQLTips.com

Performance and Tuning

Sometimes we cannot improve query performance because we don’t have control over the code. Consider a query that is generated by Entity Framework (EF) from the application and you do not have access to the source code. The main question is how you can improve SQL Server query optimization for a poorly performing query?

The North Star for the Year

by Steve Jones

SQLServerCentral

Career Growth

Steve starts the new year with a look at dreams and goals.

The OUTPUT Clause for INSERT and DELETE Statements

by Amarendra Reddy Thummeti

SQLServerCentral.com

T-SQL

In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.

10 Key Concepts Developers Should Know About the SQL Server model Database

by Additional Articles

SimpleTalk

Model Database

This article covers the 10 key concepts developers should understand to avoid surprises and to use the model database intentionally.

Finding Motivation

by Steve Jones

SQLServerCentral

Career Growth

How do you motivate yourself? As the year ends, Steve has a few thoughts.

Fixing "Login failed for user" error in SQL Server

by DineshKarunarathna

SQLServerCentral

In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]

Preparing SQL Servers and Data for Quantum Computing

by Additional Articles

MSSQLTips.com

Encryption

Just like advances in artificial intelligence, I have heard that quantum computing is going to be a disruptive technology for our future. For instance, there’s the concern that it’s going to break/crack a lot of network encryption and potentially data encryption. What’s going to be affected, how long do we have, and what do I (and my organization) need to do to prepare for it?