SQLSaturday #180 - Nepal 2012
Event Date: 12/15/2012 00:00:00
Event Location:
- United World Trade Center
- Tripureshor
- Kathmandu, Bagmati, Nepal
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Ben Miller
Track and Room: Data Platform and Business Intelligence - N/A
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.
Speaker(s):
- Gogula Aryalingam
Track and Room: Data Platform and Business Intelligence - N/A
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
Speaker(s):
- Victor Isakov
Track and Room: Data Platform and Business Intelligence - N/A
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.
Speaker(s):
- Shree Khanal
Track and Room: Data Platform and Business Intelligence - N/A
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.
Speaker(s):
- Margarita Naumova
Track and Room: Data Platform and Business Intelligence - N/A
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.
Speaker(s):
- Gogula Aryalingam
Track and Room: Data Platform and Business Intelligence - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Gogula Aryalingam
Twitter: - http://www.twitter.com/gogula
LinkedIn: Gogula Aryalingam
Contact: http://datamaul.wordpress.com
Gogula is a data analytics professional from Sri Lanka, with 14+ years on the Microsoft data platform. He has worked with many aspects of data analytics and BI solutions from architecting, designing, developing and consulting across various industries and verticals. He is Regional Mentor for PASS South Asia, Data Platform MVP, MCSE, former MCT, and MSc in IT. Gogula’s passion revolves data analytics and BI; hence enjoys writing, teaching and speaking about the things he works with. He was also involved as an SME for Microsoft certification development. He currently juggles his full time job as Lead Architect while speaking at local and foreign events, along with regular stints at the Sri Lankan Data Community which he co-founded.
**Victor Isakov **
Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect and Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e
Gogula Aryalingam
Twitter: - http://www.twitter.com/gogula
LinkedIn: Gogula Aryalingam
Contact: http://datamaul.wordpress.com
Gogula is a data analytics professional from Sri Lanka, with 14+ years on the Microsoft data platform. He has worked with many aspects of data analytics and BI solutions from architecting, designing, developing and consulting across various industries and verticals. He is Regional Mentor for PASS South Asia, Data Platform MVP, MCSE, former MCT, and MSc in IT. Gogula’s passion revolves data analytics and BI; hence enjoys writing, teaching and speaking about the things he works with. He was also involved as an SME for Microsoft certification development. He currently juggles his full time job as Lead Architect while speaking at local and foreign events, along with regular stints at the Sri Lankan Data Community which he co-founded.
Shree Khanal
Twitter: - shreekhanal
LinkedIn: Shree Khanal
Contact: http://www.sqlhelps.com
Shree Khanal is a Database Architect, Speaker and Trainer having 15+ years of professional experience on database solution development and optimization. Mr. Khanal is a Data Platform MVP Microsoft Certified Database Professional since 2000 to till date. Starting with SQL Server 7, he has been working with all the version of SQL Server up to 2016 in production environment. In context of OLAP cube development, he started working on it from SQL Server 2000 to latest SSAS 2016. He has worked number of years providing SQL BI solutions to various enterprise clients most of them from BI sector. He founded and has been leading the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal since 2010.
Margarita Naumova
Contact: http://www.inspirit.bg
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field – Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valuable Professional). She has more than 15 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area. Currently she works as a Managing Partner and Chief SQL Architect of Inspirit, her own Data Platform Consulting Company with offices in Bulgaria (Inspirit) and Norway (Inspir-it AS). Margarita is a regular speaker at the largest IT events, SQLBits, SQLSaturday in Europe.
Sponsors
The following is a list of sponsors that helped fund the event: