I do not have a ready example to send. You can find many examples online of how to call a web service from within C#, and many examples of how...

The nice features in the Query Designer that allow you to drag and drop tables into the query, drag columns around to complete joins, etc. means the UI takes control...

L' Eomot Inversé (10/24/2013)

---

opc.three (10/23/2013)

---

No, it does't. A member of the sysadmin Role can simply enable it.

You're conflating multiple issues. There is a difference between trusting someone to do...

No, it does't. A member of the sysadmin Role can simply enable it.

You're conflating multiple issues. There is a difference between trusting someone to do all operations within the...

It means xp_cmdshell is disabled within this instance, the default.

I am not sure if it was this thread, or some other related thread, but I have the same comment about the CLR as well as some other features of...

Entitlement

Thanks for posting this code Matthias. Very helpful!

Aggregate

You are passing in a VARCHAR(MAX) and treating it like a numeric type in your function. This results in an implicit data type conversion and also leaves you open to...

SSIS does have data type suggestions but only in design mode iirc. Once you setup your metadata it's set.

You could do some of the checks yourself using the new TRY_CAST...

SELECT FORMAT(GETDATE(), 'MM/dd/yyyy HH:mm:ss')

AS [try the FORMAT function available in SQL 2012 and above];

If you are not leveraging Kerberos for authentication then you do not need to worry about updating SPNs because you would not have any that were registered that needed to...

Specifically this is the piece I am looking for guidance on:

I mentioned three product solutions that I have explored or...

Oops, try again?