Change in SQL SERVER 2019 - Encryption.

-
With the new SQL SERVER 2019 . The behavior of the encryption has changed. If we encrypt the same value in 2012 and 2019 the Data length differs between the two engines. This is due to the change in the SQL Server Encryption from AS128 To AS256. This will lead to change in some of the field which has less capacity in User driven tables or locking tables.
 
 
Below is tested sample code.
 

 Change in SQL SERVER 2019  - Encryption.

 
 
SQL SERVER -  2016 – Data Length - 28

SQL SERVER – 2019 – data length - 36


Comments

Post a Comment

Popular posts from this blog

Xamarin Forms : PopUp Page with RG.Plugins.Popup

-
Image
How to Show PopUp Page In Xamarin Forms Step 1 First, we need to add the Third Page Plugin to achieve the same. [ Rg.Plugins.Popup ] Go to Manage Nuget Packages - > Search for Rg.Plugins.Popup Once the plugin is installed in the Project We need to configure same in Android and IOS Projects In Android   - Go to MainActivity.cs Code:     Rg.Plugins.Popup. Popup .Init( this , savedInstanceState); In IOS –   Go to   - AppDelegate.cs Code : Rg.Plugins.Popup. Popup .Init(); Now Back to Main Project (PCL) Step – 1 :   Add Page in Project Once Added Page Change the Tag of Page Default Page has Content page as Tag which needs to be replaced with PopUpPage Class  :  Default Page:- Class < ContentPage  xmlns ="http://xamarin.com/schemas/2014/forms" Change To < pages : PopupPage  xmlns ="http://xamarin.com/schemas/2014/forms" This is how it should Lo...
Read more

Shared / Static Class in vb.net/C#

-
Image
Shared / Static Class in vb.net/C# VB.net     : Shared C#            : Static You can’t create object of Shared Class Below Image show Properties and Method are not visible for Shared/Static Class Public Class Form1     Private Sub Button1_Click(sender As Object , e As EventArgs ) Handles Button1.Click         'Module is VB.net are Shared Type Class.         'Shared Class Example is ARC.Tools.GRIDManager         'When Class s Defined as Shared There no need to create object of Class.         'If you just want to create a class that you can't inherit, in C# you can use         ' Sealed, and in VB.Net use NotInheritable.         'The VB.Net equivalent of s...
Read more

OUTPUT Clause with Insert in Stored Procedure in SQL Server.

-
Image
When you need Newly added Records ID from SP. Normally we tend to use @@Identity. Now this has Scope related issues.  To get Perfect Value for Inserted Record. We Can use OUTPUT INSERTED   SQL     GO /****** Object:  Table [dbo].[Table_1]    Script Date: 01/02/16 16:48:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo] . [Table_1] (        [ID] [int] IDENTITY ( 1 , 1 ) NOT NULL,        [Name] [varchar] ( 50 ) NOT NULL,   CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED (        [ID] ASC ) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO     Create Proc spInsertReco...
Read more