Hi Grant

Thank you for the reply.

What we are planning to do is take our existing SharePoint database (5TBs in size) and migrate it to the latest version so management wants...

• This reply was modified 5 years, 1 month ago by  hurricaneDBA.

Hi Sue

I opened a call with stackexhange with the full details if you would like know what happened:

https://dba.stackexchange.com/questions/244635/lost-the-dmk-password

thanks again for the heads up

Kal

Hi Sue

Hope you’re doing great

Yeah I tried to add a second password to the DMK but you need to know the first password to open it first like you said.

What...

• This reply was modified 5 years, 4 months ago by  hurricaneDBA.

Thank you everyone for the help

Have a great week

KY

Microsoft came back and recommended I backup the database master key from production and encrypt those with a new password then restore them using them same password on the simulation...

Hi Joe / Phil

I modified the query and here are the DDLs and insert statements and output

CREATE TABLE SAMPLE

(

ID_NUMERIC VARCHAR(10),

SAMPLED_DATE DATE,

SAMPLING_POINT VARCHAR(15),

)

CREATE TABLE TEST

(

TEST_NUMBER VARCHAR(10),

SAMPLE VARCHAR(10)

)

CREATE TABLE...

• This reply was modified 5 years, 4 months ago by  hurricaneDBA.
• This reply was modified 5 years, 4 months ago by  Steve Jones - SSC Editor. Reason: format code

Hi Joe

when I get back to the office I’ll post the sample data

Kal

Hello J

Since I don’t know your first name do you mind if I call you J?

yes it was my mistake for not posting the DDLs but per security at my...

Phil

i have 3 tables in the query and I’m doing an inner join on column from each table.

How will the partition help my query?

Kal

Dear Phil

i don’t have access to SSRS. I need to build this as a quick report using TSQL

Heres the query:

SELECT Identity,

RESULT.NAME,

MIN(VALUE),

MAX(VALUE)

FROM SAMPLE_POINT

INNER JOIN SAMPLE ON (IDENTITY = SAMPLING_POINT)

INNER JOIN TEST...

Hi Steve

When i try to add an extra password to the DMK i get the error below:

Msg 15581, Level 16, State 7, Line 23

Please create a master key in the...

Hi Jeff
The source is the data sources and the destination is SSIS which will then transform the data and store it into data marts in the DW....

Thank you for the replies let me be more specific.

Were building the infrastructure for a solution which will utilize the power Bi service but keep the data on premises.

So we...

Dear Thom

thanks for the reply.

So to connect between SSIS package and a separate linked server I would create an OLEDB connection using the connection managers. Is that the procedure?

Kal

Sorry Thom

i didn’t meant the source data I meant the data source which SSIS will use to connect to the data.

How do we secure the data source connection?

Correct me if...