KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

19
托比 ● 科普罗夫斯基 Tobiasz Janusz Koprowski SQL Server MVP, FORG+ 第三届国际新兴信息及通讯技术产业大会将于 2014619-21日在大连国际博览广场举行。

description

In the World of Outsourcing and in the World of Cloud our data are not living only in our data center room anymore. Many of us decided to moving their data partially or in all size to oursourcers or to the cloud. Both 'providers' promised: "Your data are secure. We provide Security, High Availability and Best Practices as a standard" Ouch! Really? How we can trust You? Should we trust You? What we should do from our side to be sure that High Availability of our data are secured? I would to discuss and find few good answers and examples for those questions.

Transcript of KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

Page 1: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

托比●科普罗夫斯基Tobiasz Janusz Koprowski

SQL Server MVP, FORG+

第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 2: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

Leader of Polish SQL Server User Group

Microsoft Certified Trainer (MCP, MCSA, MLSS, MLSBS, MCTS, MCITP)

SQL Server MVP (for last four years)

active blogger, influencer, technical writer

last 9 years living in Data Processing Center

last 14 years banking and ICT

frequently speaker at several conferences: SQL Server Community

Launch, Time for SharePoint, CodeCamps, InfoMEET, SharePoint

Community Launch, CISSP Day, SQL in the City, InfoTRAMS, SQL Bits, IT

Camp, SQL Saturday, CareerCon, Sharepoint & SQL Connection, Kariera

IT, SQL Rally, SQL Relay…

Microsoft Terminology Community / translations for Wndows 7/8 and

Visual Studio 2010/2012

co-author of SQL Server MVP Deep Dives:

High availability of SQL Server in the context

of Service Level Agreements (Chapter 18th)

technical reviewer:

Exploring MDX for SQL Server 2012

@KoprowskiT InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 3: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

WHAT IS HIGH AVAILABILITY?

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 4: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

WHAT IS HIGH SERVICE LEVEL AGREEMENT?

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 5: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

WHAT IS HIGH SECURITY (for data)?

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 6: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

COMPLIANCE

(HIPPSA, SOX, PCI DSS)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 7: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

STANDARDS

(ITIL, ISO 27001)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 8: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

PROCESS

(ITIL, PRINCE, SCRUM, AGILE, KANBAN)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 9: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

WHERE ARE OUR DATA?

(on premise <> in the cloud)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 10: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

WHERE WE HAVE BORDERS?

(inside country<> outside country)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 11: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

HOW WE CAN TRUST OUR PROVIDERS?

(ranking, stories, white papers, cases)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 12: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

PEOPLE, ALWAYS PEOPLE

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 13: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

PROCEDURES

(which procedures we implemented)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 14: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

TESTS

(how we tested – if we tested – our procedures )

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 15: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

CLOUD SERVICES

(local small provider vs worldwide provider)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 16: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

ENCRYPTION

(local data encryption,

cloud encryption, conection encryption)

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 17: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

QUESTIONS?

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 18: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

CONTACT:

MAIL: [email protected]

MSG: [email protected]

TWITTER/FACEBOOK/LINKEDIN: KoprowskiT

SLIDES FROM SESSION:

SlideShare Profile: http://www.slideshare.net/Anorak

BLOGS:

ITPRO Anorak’s Vision:

http://itblogs.pl/notbeautifulanymore/

Volume Licensing Specialites:

http://koprowskit.eu/licensing/

My MVP Blog: http://koprowskit.eu/geek/

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。

Page 19: KoprowskiT_SecureHighAvailabilityOfYourData_Infotech2014_Dalian_China

谢谢!

InfoTech 2014 | Dalian, China 21st June 2014 第三届国际新兴信息及通讯技术产业大会将于2014年6月19-21日在大连国际博览广场举行。