SQLSaturday #152 - Bulgaria 20129/29/2012 12:00:00 AM(GMT+02:00) Athens, Beirut, Istanbul, MinskSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat152110 B, Simeonovsko Shosse Bul.Office Floor II, 1700 Sofia, BulgariaSofia , Bulgaria17002416ICB-InterConsult Bulgaria Ltd.http://www.icb.bghttp://media.infragistics.com/community/SQLSaturday/ICB_new_logo_V.jpg601702524HP Global Delivery Center Bulgariahttp://www.hp.comhttp://media.infragistics.com/community/SQLSaturday/hp_logo_sql.jpg601702625Inspirit EOODhttp://www.sqlmasteracademy.comhttp://www.sqlmasteracademy.com/files/image/sqlmalogo170x60pxv_2.jpg601702626Infragistics Bulgariahttp://www.infragistics.comhttp://media.infragistics.com/community/SQLSaturday/Ig-logo170.png601702644Microsoft Bulgariahttp://www.microsoft.comhttp://media.infragistics.com/community/SQLSaturday/MSFT_logo_170x60.png601702695JobTiger http://www.jobtiger.bg/http://media.infragistics.com/community/SQLSaturday/Logo_JobTiger.png601702628CozyRochttp://www.cozyroc.comhttp://media.infragistics.com/community/SQLSaturday/cozyroc-logo3.png601702616International Data Group (IDG)http://idg.bg/http://www.idg.com/lib/graphics/logo_idg.png4010011088Allan MitchellAllan is the joint owner of Copper Blue Consulting Ltd. Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format. We are passionate about data integrity and suitability. We have worked all over the world in a variety of industries.and on projects both large and small. We specialise in Extract, Transform and Load Complex Event Processing Master Data Management Data Visualisation Operational and Predictive Analytics.@allanSQLIShttp://uk.linkedin.com/pub/allan-mitchell/1/b4/5a9https://api.twitter.com/1/users/profile_image?screen_name=@allanSQLIS48489390Anton StaykovAnton Staykov was just rewarded for second year as a Microsoft MVP for Windows Azure. He is also founder of the Windows Azure User Group Bulgaria http://www.azure.bg/.
A Windows Azure consultant and highly experienced developer. @astaykovhttp://bg.linkedin.com/in/astaykovhttp://blogs.staykov.nethttps://api.twitter.com/1/users/profile_image?screen_name=@astaykov484810588Boris HristovBoris is SQL Server DBA at Hewlett - Packard Enterprise Services who's obsessed with the thought of designing solutions. He also teaches SQL Server at New Bulgarian University and is constantly exploring new technologies and trends. Last and definitely not at least he loves spending time with his closest people.@http://twitter.com/BorisHristovhttp://bg.linkedin.com/in/borishristov/http://borishristov.com/blog/https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/BorisHristov484810302David Peter HansenDavid Peter Hansen is a Principal Consultant, Practice Manager at Platon, a Scandinavian Information Management consultancy. He has worked with database development and administration for 11 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He works mostly on projects in the financial sector, and specializes in developer coaching as well as scalable architecture and performance tuning on large scale data warehouses and BI solutions.@dphansenhttp://www.linkedin.com/in/davidpeterhansenhttp://dave.dk/https://api.twitter.com/1/users/profile_image?screen_name=@dphansen484810590Ivan DonevIvan Donev is a certified Microsoft IT Professional in Business intelligence, Database development and database administration since 2010 and dealing with different SQL Server projects and environments since 2007. I am also and certified trainer, active blogger and leader of www.mssqlinsider.com. I am also active participant in the Bulgarian SQL Server User group as well as speaker, participated in large BI, upgrade, consolidation and migration with SQL Server.@ikdonevhttp://www.linkedin.com/in/ikdonevhttp://www.mssqlinsider.com/https://api.twitter.com/1/users/profile_image?screen_name=@ikdonev484811139Ivelin AndreevIvelin is a PM at Interconsult Bulgaria with 10 years of strong experience in web development, SOA, integration and data management. He is Microsoft certified ASP.NET and data access specialist but also experienced in Oracle DBMS, GIS, mapping and network security. As a practical man Ivelin tries to balance between risk and flexibility which always urges him to make conscious decisions. Never scared of work he turned the pursuit for knowledge and weighing pros and cons into own marked style.
http://bg.linkedin.com/in/ivelin484811276Jason BeresVP of Product Management, Community Evangelism - Infragistics
Jason Beres spearheads customer-driven, innovative features and functionality throughout all of Infragistics' products. Jason is a Microsoft .NET MVP, INETA Speakers Bureau member, and past chairman of INETA’s Academic Committee. @jasonbereshttp://www.linkedin.com/in/jasonbereshttp://www.infragistics.com/jasonhttps://api.twitter.com/1/users/profile_image?screen_name=@jasonberes48489128Jen StirrupJen Stirrup is a newly-awarded SQL Server MVP. She is an independent consultant who specialises in Business Intelligence, with a focus on Data Visualisation. Jen has conducted projects in the UK and mainland Europe. Jen has previously spoken at SQLBits, SQLPASS and other community events on the topic of Business Intelligence and Data Visualisation. She blogs regularly on these topics at www.jenstirrup.com and can be found tweeting at twitter.com/jenstirrup @ @mihailmateev.http://www.linkedin.com/in/jenstirruphttp://www.jenstirrup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ @mihailmateev.484811305Margarita NaumovaMargarita Naumova is Microsoft Certified Master – a certification of the best SQL Server Experts Worldwide. She has more than 15 years of SQL Server and BI consulting and training experience. Margarita is a leader and founder of Bulgarian SQL BI User Group 'Let's SQL Together' and is a regular presenter of the largest IT events in Bulgaria. She is an MVP and the Top Presenter of Microsoft Days 2010 Conference. Magi is the author of SQL Master Academy Training Program http://www.linkedin.com/profile/view?id=29246694trk=tab_prohttp://www.sqlmasteracademy.com484810957Mihail MateevMihail Mateev is a Senior Technical Evangelist, Team Lead at Infragistics Inc. He worked as a Software developer and team lead on WPF
and Silverlight Line of Business production lines of the company. Now he works like a Technical evangelist in the Infragistics. Mihail worked
in various areas related to technology Microsoft: Silverlight, WPF, Windows Phone 7, Visual Studio LightSwitch, WCF RIA Services,
ASP.Net MVC, Windows Metro Applications, MS SQL Server and Windows Azure.@ @mihailmateev.http://www.linkedin.com/profile/view?id=4712965locale=en_UStrk=tab_prohttp://blogs.infragistics.com/blogs/mihail_mateev/https://api.twitter.com/1/users/profile_image?screen_name=@ @mihailmateev.484810401Milos RadivojevicMilos Radivojevic works for SolidQ as Mentor and is located in Vienna, Austria. He is MCT and MCITP for SQL Server 2008 and specializes in SQL Server for application developers and performance and query tuning.@MilosSQLhttp://www.solidq.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MilosSQL484811134Miroslav LessevI am a PhD candidate at Faculty of Economics and Business Administration, University of Sofia 'St. Kliment Ohridski' in Implementation of modern computer engineering in economic studies at. I have study on cloud computing and its effect on economics and people.
I have more than 12 years of experience in designing, developing, implementing and supporting databases. At the moment I'm a Expert DBA in CSC Bulgaria. @mlessevhttp://www.slideshare.net/lessevhttps://api.twitter.com/1/users/profile_image?screen_name=@mlessev484810589Nikolay ChorbanovI am manager of the SQL server team in HP Sofia Global Delivery Center. My team consists of around 25 DBAs and serves 1300 SQL servers. Prior to my management career I have 5 years of experience as SQL DBA. I still keep my passion for SQL Server and I try to be up to speed with the technology. I am Microsoft Certified Trainer and for the last 2 years I lead a SQL Server course in Sofia University. I have also done several presentations for the BG SQL user group community.http://www.linkedin.com/pub/nikolay-chorbanov/18/50a/448484811470Organizing CommitteeSQLSaturday Bulgaria Organizing Committee@ @mihailmateev.http://www.linkedin.com/profile/view?id=4712965locale=en_UStrk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=@ @mihailmateev.484811587SQL SaturdaySQL Saturday Bulgaria@ @mihailmateev.http://www.linkedin.com/profile/view?id=4712965locale=en_UStrk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=@ @mihailmateev.48489468Tobiasz KoprowskiCommunity leader focused on SQL Server, SharePoint, security, collaboration, and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, Freelancer, consultant. Conducts audit projects, consulting and implementation in Poland and across Europe. Technical Team Leader in GITCA. Member of such Microsoft Terminology Community, Friends of RedGate, PASS, ISSA, ACM and several communities in the world. MVP for SQL Server. President of the Polish SQL Server USer Group. Creator of SQLDAY Conference.@KoprowskiThttp://pl.linkedin.com/in/koprowskithttp://koprowskit.eu/geek/https://api.twitter.com/1/users/profile_image?screen_name=@KoprowskiT48489783Ventsy PopovVentsy Popov is a Developer Evangelist in Microsoft Bulgaria. He focuses on the newest trends round Microsoft Development Platform and positioning its values amongst developers and software companies. Before that, he worked for years on the development field, dealing with technologies like ASP.NET, Windows Forms, .NET Compact Framework, MS SQL Server, Oracle DB. Ventsy is a Microsoft Certified Trainer and since 2008 has been participating as a speaker on numerous events and university courses.@v_popovhttp://bg.linkedin.com/in/ventsypopovhttp://ventsypopov.comhttps://api.twitter.com/1/users/profile_image?screen_name=@v_popov484889678967SQLSatruday 1522nd Floor Area (XAML)Coffee Break9/29/2012 8:00:00 AM9/29/2012 8:30:00 AM89678967SQLSatruday 1523rd Floor Area (WEB)Coffee Break9/29/2012 8:00:00 AM9/29/2012 8:30:00 AM89678967SQLSatruday 1523rd Floor Conf. Room CCoffee Break9/29/2012 8:00:00 AM9/29/2012 8:30:00 AM89678967SQLSatruday 1522rd Floor Evangelism AreaCoffee Break9/29/2012 8:00:00 AM9/29/2012 8:30:00 AM89688968SQLSaturday 1522nd Floor Area (XAML)Lunch Break9/29/2012 12:00:00 PM9/29/2012 1:00:00 PM89688968SQLSaturday 1523rd Floor Area (WEB)Lunch Break9/29/2012 12:00:00 PM9/29/2012 1:00:00 PM89688968SQLSaturday 1523rd Floor Conf. Room CLunch Break9/29/2012 12:00:00 PM9/29/2012 1:00:00 PM89688968SQLSaturday 1522rd Floor Evangelism AreaLunch Break9/29/2012 12:00:00 PM9/29/2012 1:00:00 PM91289128Jen Stirrup2rd Floor Evangelism AreaBusiness Intelligence in Azure: SSIS SSRS 2012What does Azure offer to SQL Server 2012 Business Intelligence developers, and to those who use Business Intelligence every day? Come to this session to see how you can transfer your skills in SSIS and SSRS to add Azure to your existing Business Intelligence skill set. Using SQL Server Data Tools (SSDT), we will look at the differences in developing SSIS packages that use Azure as a source and as a target. We will also look at developing SSRS reports deployed to Azure, using SSDT. We will also look at Business Intelligence for mobile devices such as tablets.Come and see SQL Server Azure SQL Business Intelligence, and learn to avoid some of the 'gotcha!' pitfalls when developing Business Intelligence solutions for the cloud.9/29/2012 9:45:00 AM9/29/2012 10:45:00 AM91319131Jen Stirrup2rd Floor Evangelism AreaMobile Business Intelligence for Everyone, Now!Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap? What's available right now, and how can it be implemented at your organisation?
Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!
9/29/2012 5:00:00 PM9/29/2012 6:00:00 PM93909390Anton Staykov3rd Floor Conf. Room CIntro to SQL Azure FederationsLet's see how can we use use SQL Azure Federations to scale out our SQL Azure deployment. In this session will talk about basics, specifics, pitfalls.9/29/2012 1:00:00 PM9/29/2012 2:00:00 PM94689468Tobiasz Koprowski3rd Floor Area (WEB)Welcome to the Licensing NightmareAre You remember 'Sliders'? In my opinion Licensing World is similar to this series. How many time You tried to understand licensing? How many times You heard different opinions about same question? I'm sure, that You know what is CPU, CORE, SOCKET. Are You familiar with Processor / User / Device? And CAL / SAL/ SA too? Are You use SPLA program or just OEM or MOLP? Physical Instance, Virtual Instance, 90 Days, EULA, SPUR, LAR, Multiplexing, 5 Dollars (not 5 Cents)... It's not all the possibilities, if we are talking about licenses. Let's talk about it, from the Licensing Point of View9/29/2012 9:45:00 AM9/29/2012 10:45:00 AM94709470Tobiasz Koprowski3rd Floor Conf. Room CHigh Availability of SQL in the context of SLAIf SQL Server is heart of our environment, his health should be very important, right? If SQL Server is important, his availability for our businesses (internal and external) is important to. For our customers doesn't matter where data are stored, how are stored and what we do with those data. Especially for our managers. The data must be available on demand, on time, at he moment of request. High Availability is our responsibility. How we can prepare our environment for HA? How HA is connected for with SLA? And why Service Level Agreement are important for us? In this session I want to discuss about HA options for SQL Server (2008, 2012), about our different customers, and about Service Level Agreement (formal or not). 9/29/2012 3:45:00 PM9/29/2012 4:45:00 PM97839783Ventsy Popov2nd Floor Area (XAML)SQL for Developers with SQL Server Data Tools: It’s about time developers can use Visual Studio tools when it comes database development in a quality manner. Let’s see how we can work in a single environment when we implement our application code and DB structure and functionality, all in a complemented way with code navigation, IntelliSense, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer.9/29/2012 2:15:00 PM9/29/2012 3:15:00 PM1030210302David Peter Hansen3rd Floor Area (WEB)Layered Partitioning - (re)load your data fastLoading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it.
This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us.9/29/2012 11:00:00 AM9/29/2012 12:00:00 PM1040110401Milos Radivojevic2nd Floor Area (XAML)TSQL Performance TipsSQL Server optimizer doesn't use and index seek for execution of your query although the quer is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?
In this session we will answer these questions and show how bad designed queries lead to poor execution plans. We will offer recommendations and tips how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan. 9/29/2012 9:45:00 AM9/29/2012 10:45:00 AM1058810588Boris Hristov3rd Floor Conf. Room CLet's talk real-world private cloud implementationSession full title: Let's talk real-world private cloud implementation!
Starting from a consolidation idea to optimize our costs, moving through the concept of private cloud solution and how we implemented it using the HP Database Consolidation appliance.9/29/2012 11:00:00 AM9/29/2012 12:00:00 PM1058910589Nikolay Chorbanov3rd Floor Area (WEB)Top 10 Myths and Mistakes for the DBA Which are the most common myths and mistakes that the DBAs do in their day-to-day operations? What they can do to make their lives easier and avoid sleepless nights. We will discuss some real-world examples coming from the experience of an entire database team. 9/29/2012 2:15:00 PM9/29/2012 3:15:00 PM1059010590Ivan Donev3rd Floor Area (WEB)Is 'the bigger the better' valid in the DB world?Session Full title: Is 'the bigger the better' valid in the database world? - Best practices for VLDB environments
What are the best practices for building and managing very large database environments? How can we get an advantage from implementing HP's FastTrack Solution? We will share some real-world tips and tricks around the management of multi-terabyte databases.9/29/2012 1:00:00 PM9/29/2012 2:00:00 PM1095710957Mihail Mateev2nd Floor Area (XAML)Using SQL Local Database in Mobile ApplicationsMicrosoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. With Windows Phone Mango OS you can store relational data in a local database. In this presentation you will learn how to configure your mobile application to work with Local Database . You'll find specifics related LocalDb compared to other versions of SQL Server. In this talk we will consider the details of application deployment using LocalDb. Developer could learn more about how to maintain local database (selecting, inserting, updating, deleting data), changing database schema. We will talk also about how to import data to LocalDb , database security and which kind of ORM to use.9/29/2012 3:45:00 PM9/29/2012 4:45:00 PM1095810958Mihail Mateev2rd Floor Evangelism AreaSpatial Data with SQL Server Reporting ServicesSpatial Data Visualization is one of the key new features of SQL Server Reporting Services. This feature was introduced in SQL Server 2008
R2 and continues to evolve in the new SQL Server 2012. SQL Server provided geospatial data from SQL Server 2008 and you may have
noticed (or perhaps used) the two geospatial data types in SQL Server: geometry and geography. In this lecture we will talk about how to
visualize spatial data in the SQL Server Reporting Services, creating Map reports. We will learn how to set reporting services and how to use
spatial data with this product. Samples will demonstrate work with Reporting Services for both SQL Server 2008 R2 and SQL Server 2012.9/29/2012 1:00:00 PM9/29/2012 2:00:00 PM1108811088Allan Mitchell2rd Floor Evangelism AreaSQL Server 2012 SSIS Change Data CaptureWe are storing more and more data FACT
We have less time to move data around our environment FACT
Businesses want close to real-time analytics FACT.
We therefore need to plan our data movement strategy better. In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know.9/29/2012 3:45:00 PM9/29/2012 4:45:00 PM1113411134Miroslav Lessev3rd Floor Conf. Room CNoSQL and Windows Azure platform An introduction to NoSQL database principles, and its main subcategories; An exploration of NoSQL technologies available in the cloud using Windows Azure and SQL Azure; A comparison of NoSQL and relational database approaches, and a discussion about the role of database in clouds' era taking into account the adaptability of each application to the different businesses;9/29/2012 9:45:00 AM9/29/2012 10:45:00 AM1113911139Ivelin Andreev2nd Floor Area (XAML)Dare to build vertical design with relational dataEntity-Attribute-Value model is often called “anti-pattern” by the criticism. And probably they would be right if one misses to read the “Handle with Care” label on it. Enthusiastic inexperienced developers would easily compromise the benefits of relational DB but the coin has yet another side. Hierarchical object with thousands of properties, unknown schema, flexibility and millions of records. As always – we have to sacrifice one thing in order to win another. Then all it comes to priorities and ability for decision making.
At this lecture you will not get a step-by-step manual but instead get ideas for how to build one for you.
A challenge, a proof of concept, hard work and successful project for millions – that is the story to share.9/29/2012 11:00:00 AM9/29/2012 12:00:00 PM1119511195Ivelin Andreev2nd Floor Area (XAML)Practical SQL query monitoring and optimizationToday the project owners demand results as soon as possible and most often - for yesterday. Time to market is crucial and it is practical to deliver bit-by-bit, get feedback and grow with the number of your customers. But as the project grows, the team does too and not all have the same expertise. As well rarely in the beginning the requirements clear enough to allow performance-wise SQL interaction.
In most cases there does not exist an ORM that can solve this task for you and you will need to have hard T-SQL writer in the team. If you already know this story or are going this way then in this practical session we will share how to monitor, measure and optimize your SQL code and DB layer interaction.
9/29/2012 5:00:00 PM9/29/2012 6:00:00 PM1127611276Jason Beres2rd Floor Evangelism AreaPractical methods for OLAP Data VisualizationOLAP (online analytical processing) cube on one hand extends a 2-dimensional array (spreadsheet table or array of facts/measures and keys/pointers to dictionaries) to a multidimensional DataCube. OLAP Servers with most marketshare are: SSAS (Microsoft SQL Server Analytical Services). This talk ia about how visualize OLAP data. .NET allows developers to rapidly embed out-of-the box OLAP, data visualization and Business Intelligence features in Windows and Web applications with one convenient purchase! With the ability to connect to virtually any data source and support for several development platforms, rolling out your own ad hoc Business Intelligence application is now easier than ever.9/29/2012 2:15:00 PM9/29/2012 3:15:00 PM1130511305Margarita Naumova2rd Floor Evangelism AreaSQL Server 2012 Analysis Services - practical overSQL Server 2012 adds new capability for decision support and data analysis in the enterprise. SSAS has important performance Improvements, and the new tabular mode opens the whole new world for SSAS designers. Learn what’s new and see most of the features.9/29/2012 11:00:00 AM9/29/2012 12:00:00 PM1130611306Margarita Naumova2nd Floor Area (XAML)The good, the bad and the ugly of SQL Server paramWhat is happening behind the scenes when you think you send a query to SQL Server? What is the surprise when you find out that the same query is performing differently every time? You think you parameterize well, or your query is using the already compiled execution plan. Let’s think again and let’s talk more about SQL Server query caches, parameterization and query plan problems in order to understand what’s going on behind the scenes and how to avoid the ugly things happening with your query performance9/29/2012 1:00:00 PM9/29/2012 2:00:00 PM1130811308Margarita Naumova3rd Floor Area (WEB)Database corrupt! What’s next?Corruption happens! Realize that! Do not just cross your fingers, you have choices to save your data. When corruption occurs pressing the panic button is not an option, but knowing what exactly to do in order to minimize a data loss and down time. Backups are sometimes the best way to minimize the data loss, but not necessarily the down-time. The session explains what to do when corruption occurs in order to reduce data loss and downtime, how to act proactively minimizing corruption. Having this knowledge can make DBAs more confident to dealing these problems themselves and improve their skills9/29/2012 3:45:00 PM9/29/2012 4:45:00 PM1146911469Jen Stirrup3rd Floor Conf. Room CWomen In TechnologyWomen In Technology Session9/29/2012 2:15:00 PM9/29/2012 3:15:00 PM1147011470Organizing Committee2nd Floor Area (XAML)SQLSaturday #152 KeynoteSQLSaturday #152 Keynote9/29/2012 8:30:00 AM9/29/2012 9:30:00 AM1147011470Organizing Committee3rd Floor Area (WEB)SQLSaturday #152 KeynoteSQLSaturday #152 Keynote9/29/2012 8:30:00 AM9/29/2012 9:30:00 AM1147011470Organizing Committee3rd Floor Conf. Room CSQLSaturday #152 KeynoteSQLSaturday #152 Keynote9/29/2012 8:30:00 AM9/29/2012 9:30:00 AM1147011470Organizing Committee2rd Floor Evangelism AreaSQLSaturday #152 KeynoteSQLSaturday #152 Keynote9/29/2012 8:30:00 AM9/29/2012 9:30:00 AM1158711587SQL Saturday2nd Floor Area (XAML)BreakBreak between sessions9/29/2012 3:15:00 PM9/29/2012 3:45:00 PM1158711587SQL Saturday3rd Floor Area (WEB)BreakBreak between sessions9/29/2012 3:15:00 PM9/29/2012 3:45:00 PM1158711587SQL Saturday3rd Floor Conf. Room CBreakBreak between sessions9/29/2012 3:15:00 PM9/29/2012 3:45:00 PM1158711587SQL Saturday2rd Floor Evangelism AreaBreakBreak between sessions9/29/2012 3:15:00 PM9/29/2012 3:45:00 PM