Anyone to Help me out with this confusion, if there's some missing info please let me know

Hi jack this time, we have two data sources, both exchange data, so i need to implement SSL on both database server , if both are on separate domain.

Hi Jack,

Does it support Express Edition ?

And does a single certificate ,which is being used for web server earlier i.e. https,

can be used sql server even?

Another thing i would like to ask is ,how to connect from ssis to sqlserver instance, after ssl is implemented.

Will Simple Connection establishment in package is sufficient or need to...

Will TDE(Transparent Data Encryption) in sqlserver Help this ?

Sean,

If i am using ssis package to copy database from one server to another public server..

how securely i can achieve this...

- Like data will first should be imported into flat...

Yes Sean,

I need to execute nightly SSIS Package to copy the data from database on one server which will be local to me.

to the database server which will be public...

Pushing Data from Database on local Server to database on public Server.

Need precautions to send secure data or how to process this to and fro movement of data.

Any suggestions.

Appreciated for your reply and letting me know .

Below Are Business Rules...

Target- To Show available slots for Doctor/provider for a clinic location

1) Lets Says today is 27 May 2014 and...

declare @dteTo Date

set @dteTo = CAST(GETDATE() AS DATE)

TA DA

DONE!! :w00t: 🙂

USE [Scratch]

GO

/*THIS TABLE WILL CONTAIN ALL BOOK APPOINTMENTS FOR A DOCTOR/PROVIDER WITH PARTICULAR CLINIC OF A LOCATION */

/* RELEVANT COLUMNS ARE Clinic_id,location_id,provider_id,appt_date_time,app_duration*/

/****** Object: Table [dbo].[AppointmentForNextTwentyDays_InProcess] ...

So, it should be define at any one stage.

Thanks koen,appreciate your feedback

I have a store procedure that is source for creation of my CSV, it take one minute to execute to 100000 records

and this result set is used to preparing csv...

Not Able to get Assistant days now by open xml

DECLARE @Payrollhandle int

DECLARE @Payrolldoc VARCHAR(MAX)=

('<Payroll StartDate="2013-10-30" EndDate="2013-10-31">

<Doctor ID="74962">

<WorkDays>

<Office ID="60101" Days="23"/>

<Office ID="60102" Days="23"/>

</WorkDays>

<AsstDays>

<Office ID="60101" Days="23"/>

<Office ID="60102" Days="23"/>

</AsstDays>

</Doctor>

</Payroll>')

EXEC SP_xml_preparedocument @Payrollhandle OUTPUT,@Payrolldoc

SELECT

* FROM...