sqlsathistory

Nr: 180

SQLSaturday #180 - Nepal 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	Data Platform and Business Intelligence	SQL Server TDE
00:00:00	Margarita Naumova	Data Platform and Business Intelligence	Smart Monitoring with SQL Server 2012 Extended Eve
00:00:00	Shree Khanal	Data Platform and Business Intelligence	SQL Server 2008 Database Internals
00:00:00	Victor Isakov	Data Platform and Business Intelligence	What DBAs Should Know About Windows Server 2012
00:00:00	Gogula Aryalingam	Data Platform and Business Intelligence	BI For (Almost) Everyone
00:00:00	Gogula Aryalingam	Data Platform and Business Intelligence	Integration 101

SessionID: 10233

SQL Server TDE

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Ben Miller

Title: SQL Server TDE

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE.

SessionID: 19361

Smart Monitoring with SQL Server 2012 Extended Eve

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Margarita Naumova

Title: Smart Monitoring with SQL Server 2012 Extended Eve

Abstract:

Smart Monitoring with SQL Server 2012 Extended Events

Extended Events is a really powerful monitoring system in SQL Server which was introduced in SQL Server 2008. The SQL Server 2012 provides a diagnostic tracing facility, built on xEvents. Learn the xEvents changes in SQL Server 2012 and find how the diagnostic system will not only replace the SQL Profiler traces but will exceed it. Works smart using the whole power of xEvents in SQL Server 2012.

SessionID: 24423

SQL Server 2008 Database Internals

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Shree Khanal

Title: SQL Server 2008 Database Internals

Abstract:

Do you already wanted to know how SQL Server 2008/2012 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008/2012 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyse the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution.

SessionID: 27444

What DBAs Should Know About Windows Server 2012

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Victor Isakov

Title: What DBAs Should Know About Windows Server 2012

Abstract:

Windows Server 2012 is coming! As a DBA, you should understand Microsoft's new operating system and its important set of features that will change the way you deploy SQL Server and design high availability solutions in your environment. In this session, you'll learn about the benefits that Windows Server 2012 brings to SQL Server, see how to install and configure Windows 8 for a SQL Server deployment, and explore new features that will affect your virtualization and high availability architectures

SessionID: 34641

BI For (Almost) Everyone

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Gogula Aryalingam

Title: BI For (Almost) Everyone

Abstract:

Business Intelligence was for a long time considered something only the "big" companies could do or afford. However in the recent past with shifts in technology paradigms, BI has become a commodity affordable by many. You too can do BI if you have the right edition (and version) of SQL Server.

This session will showcase how data in an OLTP database can be converted into BI-worthy data: using the SQL Server 2012 Database Engine, Analysis Services and finally visualizing with Excel; along with references to SSIS, SSRS, PowerPivot and PowerView on the way.

SessionID: 34642

Integration 101

Back to calendar

Event Date: 15-12-2012 - Session time: 00:00:00 - Track: Data Platform and Business Intelligence

Speaker: Gogula Aryalingam

Title: Integration 101

Abstract:

Data exists in different forms and in different places. There is always a need to bring them together; for your data warehouse or into that new CRM application or any other reason that you can think up of. This session discusses and shows how data integration can be developed, scheduled and deployed using SQL Server 2012 and Integration Services.

This site is open source. Improve this page.