Don't know if this helps, but here is the insert statement for T-sql for inserting a LOB (large object).

--Note: file path is in relation to the database server, not...

They are used for two totally different things. Server side encryption (TDE or Column-Level Encryption) is used to protect data while on the server, or protect the files if...

That was not stated as a requirement.

OOOps! More craziness:

View should be:

CREATE VIEW vSomeTable

AS

SELECT * FROM SomeTable WHERE tableUserName = USER

(This select is from the underlying table, sorry).

Of course it would be better to list out...

I don't know how crazy this is going to sound, but here goes:

Create one database, with one set of tables. In each table, put two additional columns, one for...

I hate to admit this, but if we need a bunch of scratch space on a disk and we can't do anything else, we just go buy a 500 gb...

If DRI is used, this may give you an idea. This gives the References column, which is the lookup table and its column that ties to this column.

It may...

We try to put all of the third-party app databases on a single server, mostly for cost savings on licenses and hardware. I do not give out the sa...

Use Database Mail Configuration Wizard to set up database mail.

Here is the syntax of the send statement:

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

[ , [...

Here are all the scripts from the presentation (they are long.....). They should show you start to finish how to implement CLE with a cert and symmetric key. ...

Laura:

There are several objects that have to be taken into consideration:

SMK (Service Master Key)

DMK (Database Master Key)

Certificate

Symmetric Key (a re-createable symmetric key, there is a difference)

If you use a certificate...

FYI - From my MCDBA training days, the recommendation was 1.25 * size of largest index. For Clustered indexes, that would be 1.25 * size of the table. ...

You are welcome. I wrote a program that creates all my SPROCs and vb.net code. The code created is what I gave you. I can create all...

I would definitely suggest using a Stored Procedure. You can encapsulate all the business logic within it, and you can utilize things like output parameters, which are great for...

Another way is using the SQLCMD command line utility.

Example:

sqlcmd -SBOBSRV4 -E -Q"Select * from Purchasing.Vendor" -dAdventureWorks -oC:\sqlcmdoutput.txt

-S is the server (remember to use the serveramedinstance if needed)

-E is windows authentication

-Q...