Jayanth_Kurup (10/29/2015)

---

While certification course are great to stand out; there is no assurance they will help with all the scenarios you are going to face or explain in details those...

Maybe they are missing the connect on endpoint permission then if the endpoint is already connected

Yeah thats all I needed to know.

Firebrand would be my first choice (you will get a heavy discount on their courses with vouchers), failing that QA who also accept vouchers

I...

From BOL

Requires ALTER permission on the database and CREATE ENDPOINT permission, or membership in the sysadmin fixed server role.

https://msdn.microsoft.com/en-us/library/ms179306.aspx

Minted

Please don't cross post questions on multiple threads http://www.sqlservercentral.com/Forums/Topic1731492-364-1.aspx#bm1731775

Koen and Phil have given you the solution.

Make copies of your packages.

Open them up in your favorite text editor

Find and Replace the...

Is it an error or a warning?

You should just be able to skip past it as it should be a warning, as its there as a reminder to sort out...

Where are you based and what will you mostly be doing, admin, development, bit of both?

If you have a reversed string in a computed column and then add an index to that column

Your string then looks like nixcba for example.

You can then full text that...

You need to ensure that you set the Windows firewall to allow the sqlserver.exe process or open up the port that SQL uses.

If your installing a default instance, the port...

Ah sorry I understand what your doing now.

Your wanting a left sided prefix search which is not possible in full text, only right side eg. "xin*"

My recommendation would be...

RPO = recovery point objective

Also known as how much data can the company afford to loose before it becomes a problem for the company.

Can you survive with 24 hours of...

Should do it with a derived select

SELECT

M.[Description]

,A.*

,M.Threshold

,M.[Threshold Direction]

,dev1.[Colour]

ELSE NULL END

FROM [tbl_qd_audit] A

JOIN [tbl_qd_measures] AS M

ON A.[Measure] = M.[Measure]

LEFT JOIN (

SELECT A.Measure,

CASE

WHEN M.[Threshold Direction] = '>' AND A.Value...

So you need to restrict the case statement to 3 measures not the view?

Can you post the definitions of [tbl_qd_audit] and [tbl_qd_measures] with some sample data and an expected outcome

Log backups once a day, really? Whats your RPO, 24 hours, if so no need to do the log backup your nightly full will meet that expectation.

But in answer...