Dear Sue
Thank you that worked great
Just another question shall i use SSL certificates or enable the new Always Encrypt for 2016?
Which is the better route?...

I was able to reproduce the error on my test machine which is running SQL Server 2012 on Windows 2008 R2
You change the default port to another number...

Hi Sue
I downloaded version 13.1 and tried to install it but it says on my system that there is a higher version

So i fixed the issue
I enabled the Shared Memory protocol and it worked
But does the SQL Server Agent require this protocol?
Any ideas?

Kal

Dear Gail
I was also asked by the CISO of the company to do the same. His request was:

The security administrator should set resource limit for the amount...

Wow what a wonderful post
I dont know if this is applicable to my case or not. My company CISO has asked me to do the following:

1....

Dear Chris
Here are my answers:

There is no general practice for how much memory a server needs, it will need to be determined by factors as others...

Those are good questions but My answers are how do I know how much memory I need? I’m trying to follow the best practice and now the server is having...

Dear Kevin

Thanks for the information and yes I’m aware of extended support being chargeable. I’m preparing a recommendation document to send to all vendors to push them to use...

Dear Gail
We have a number of applications which dont support 2016 so i cant upgrade to 2017.
So which version would be better to go to? 2012 or...

Hi Everyone
An update i got the ReportServer upgraded but the TempDB RS didnt and was saying

PK_SnapShotData isnt a constraint

So i deleted this...

Just an update i have been able to go forward due to insufficient privs but now i am stuck on the issue below:

This may be due to a...

Thanks everyone for the help
It turns out that i moved the Reporting Services Database to another server and the services was still running so it was calling for...

Thanks Phil
That solved my NULL issue and for Thom my sample data is below:

12354      20171114     07:37:53      ENTRY

Thanks again

Kal

Thom
Which tool do you use to write SQL?
Just out of curiousity for myself 🙂

Kal