Ohh you are right, using @@servername alone helps....thnx.. hard to remember everything together.

Thnx much!!!!!

Thnx.. I will review n modify

I dont think that I have endless dupply. I keep writing the scripts(taking help from internet n experts) and apply them in my day to day to avoid doing any...

Any update by anyone please?

Hi Experts,

I have written a custom automated script to implement TDE. Attached the one./

I have few concerns on the results part:=

1. After the task is over when I look at...

Thanks Sean....I really needed a holiday. Last week visited Chicago Botanic Garden...Anyways!! 🙂

I changed the logic of passing the password now, as using two single quotes too did not help...

Fairly simple. Scored 1 mark.

The options provided were little confusing, I mean those were framed in such a manner that one fail to respond. However, I did it properly. Scored 2 marks!

Hi Steve: Can you pl post couple of QoDs on SQL Server 2014/2016 Internals in the coming days?

I was confused whether I should choose SELECT (5+20*20-70+65)/16*12-275 = 25 or,

SELECT (1024*16-1024/15)/599 = 27.

Finally I intent to choose 25, as its nearby to 24th.

Scored 7 solid points.

Easily scored 1. Good Question..

Nice Easy Question. Thnx Steve

Problem is , if someone likes to password (for e.g.2peUj2Rj'jjS7'h) which has multiple single quotes, then only.....

Thnx..

I m now recreating certs with proper start n expiry dates.

I m.planning to automate this now

One more help/suggestion.

I found that some1 accidentally did nt mention d expiry date against each certificate so by default it took 1 yr of expiry.

Is there anyway I can alter...