Posts

My day before getting married after engaged and have living relation with them

When will you feel that you have everything still no one there to ask you how are you , how are you feeling? It will be mentally or physically  .sometimes its really feell if I don't don't decide to get married then what will happen with me,?may be I not a home maker , think piecefully and handle everything , atleast I will independent I will work more hard , buy a second hand car then growm self that no one can break you mentally no one can physically abuse you no one can mentally feel you lonely I guess when women are depressed and there is no one to ask like hey its oky talk with me will go somewhere have have food have some music .alteat this is so called society specially THE MEN teaches them you are so imp than your partner,,,  I guess I need to build again myself Mohadev help me to get over with this help me to fulfilled my parents hope so that they will be all proud of it , please help me to destroy every emotion whatever I have in my depth let no one can break me no on

DATABRICKS -INGESTION : SAMPLE 1

Image
                                                                    

how t checkk pii column in db

 EXEC sp_msforeachDB 'USE [sn_baxter] SELECT db_name() as [DB],  object_name(o.object_id) AS [Object],  c.name AS [Column] FROM sys.columns c join sys.objects o ON c.object_id = o.object_id  WHERE o.type IN (''U'',''V'') /* tables and views */ AND (c.name like ''%mail%'' OR c.name like ''%first%name%'' OR c.name like ''%last%name%'' OR c.name like ''%birth%'' OR c.name like ''%sex%'' OR c.name like ''%address%'' OR c.name like ''%phone%'' OR c.name like ''%social%'' OR c.name like ''%ssn%'' OR c.name like ''%gender%'') AND db_name() NOT IN (''msdb'',''tempdb'',''master'')'

new stored procidure with interval and frequery code

 CREATE procedure  [dbo].[SP_Baxter_CSAT]                                                                                                             AS                                                            BEGIN            DECLARE @ExtractIdOut INT                                                                   DECLARE @EndDt DATETIME2                                 DECLARE @runDate DATETIME2                                 DECLARE @RecordCount INT = 0                                                                 DECLARE @ProcedureName SYSNAME = OBJECT_NAME(@@PROCID)                                              DECLARE @intErrorCode INT                                                                 Declare @returnCode int = 0                                                                 DECLARE @ExtractProcessControlId UniqueIdentifier                                                                 SET NOCOUNT ON;                              BEGIN TRY           --Log the

GOAL

 ####certification goal 1.DP900---COMPLETED 2.DA100 3.DP203 4.DP100

result -dp-900

 i have passed with 800 score

my note 5 fsm

 fsm>>>> insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Model Number','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Serial Number','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Item Subclassification Code','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Product Description','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Customer Primary Name','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate