SQL Server has many features that support creating secure database applications. In this blogpost I’ll guide you through the latest security features in SQL Server 2017: Common Language
ASP.NET session state enables you to store and retrieve values for a user as the user navigates the different ASP.NET pages that make up a Web application. Currently,
Use SET NOCOUNT ON inside ALL your Stored Procedures By default, every time a stored procedure is executed, a message is sent from the server to the client
Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the SQL Server Database Engine. Then
This article introduces four ways for SQL Server users to enable Mixed Mode Authentication from installation to use. Way 1: Enable Mixed Mode Authentication during SQL Server Installation Way 2:
In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server. Detect the Current Cumulative Update / Service
You can quickly and securely encrypt data in SQL Server 2005+ by using the native Symmetric Keys functionality. The most common encryption algorithms symmetric key encryption supports are
Get Basic Information The first step is get basic information, judgment branch does not support stack query: [crayon-647b25e111747641540994/] To determine whether the station library separation: [crayon-647b25e11174d172019720/] See if
SQL Server 2008 introduced DATENAME function that return name of datepart of the specified date. Syntax DATENAME ( datepart , date ) Example [crayon-647b25e111d8d907960768/] Output In this