Dear DesNorton

I was testing the JOINS but your query didn't give the correct numbers or the employee IDs.

Here is the new query with some adjustments as im looking for the...

@Phil my original post doesn't include but I did in the next post.

@desnorton - yes it works now but if the employee ID is there and he or...

Hi Des

thanks for the answer it works well except for values which are zero then it doesn’t list them.

how to list the zero values?

For example if I include this line...

• This reply was modified 3 years, 11 months ago by  hurricaneDBA.

Sorry for the delay

I implemented TDE and I’m waiting to see if they want to implement Always encrypted and encrypted sessions.

question about DW.

what’s the best practice followed in securing data...

Just outside the office.

I’ll reply on Sunday with the details Anthony

have a good weekend

Kal

Yes you can disable it later.  But what are you actually protecting against with trying to implement TDE?

Good question I’ll confirm with our CISO but my understanding is protecting...

Hi Anthony

thanks for the reply

were actually using powebi service to access the data warehouse via the data gateway accessing the SSAS cube

Since we’re talking TDE if I enable it now...

??

let me get the audit scope from the CISO and business and then I’ll come back.

thank you

have a good weekend

Kal

Forgot to mention I need to audit DDLs and DMLs so which solution is the best practice?

I read the following are used:

the Change Data Capture, Change Tracking or System-versioned Temporal...

Ok Grant

so I’ll drop the SQL audit and use EE to audit my instances.

I’m a novice with EE so I’ll need to dig deep into them for auditing.

Thank you for...

So if I understand all the notes here.

SQLADUIT doesn’t audit properly

EE isn’t documented properly

so how do we audit sql server in addition to the error log file?

id like to know...

Hi Grant

To audit from sys.dm_exec_connections don’t I need to create a table and insert all the logins there then I can see the IP for a later date?

as I need...

Hi Jeff

So you can do this across different sql versions because we are migrating / upgrading from sql  server 2012 (production) to sql server 2016 (new server)?

you can apply the...

Grant

does log shipping and PITR work across different DB versions?

my current production is 2012 (windows 2008) and my upgraded will be sql server 2016 (windows 2012).

I checked with the systems team and they mentioned that since they use networker for backups they use incremental backups so we cant use differential 🙁

So the only option is...