SQLSaturday #152 - Bulgaria 2012
Event Date: 09/29/2012 00:00:00
Event Location:
- Office Floor II, 1700 Sofia, Bulgaria
- 110 B, Simeonovsko Shosse Bul.
- Sofia, , Bulgaria
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: Dare to build vertical design with relational data
Abstract: Entity-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.
Speaker(s):
- Ivelin Andreev
Track and Room: Developer - N/A
Title: Business Intelligence in Azure: SSIS SSRS 2012
Abstract: What 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.
Speaker(s):
- Jen Stirrup
Track and Room: BI - N/A
Title: Using SQL Local Database in Mobile Applications
Abstract: Microsoft 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.
Speaker(s):
- Mihail Mateev
Track and Room: Developer - N/A
Title: TSQL Performance Tips
Abstract: SQL 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.
Speaker(s):
- Miloš Radivojević
Track and Room: Developer - N/A
Title: High Availability of SQL in the context of SLA
Abstract: If 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).
Speaker(s):
- Tobiasz Koprowski
Track and Room: SQL Azure Personal Development - N/A
Title: Spatial Data with SQL Server Reporting Services
Abstract: Spatial 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.
Speaker(s):
- Mihail Mateev
Track and Room: BI - N/A
Title: Welcome to the Licensing Nightmare
Abstract: Are 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 View
Speaker(s):
- Tobiasz Koprowski
Track and Room: DBA - N/A
Title: Practical methods for OLAP Data Visualization
Abstract: OLAP (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.
Speaker(s):
- Mihail Mateev
Track and Room: BI - N/A
Title: Top 10 Myths and Mistakes for the DBA
Abstract: 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.
Speaker(s):
- Nikolay Chorbanov
Track and Room: DBA - N/A
Title: Practical SQL query monitoring and optimization
Abstract: Today 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.
Speaker(s):
- Ivelin Andreev
Track and Room: Developer - N/A
Title: SQL Server 2012 SSIS Change Data Capture
Abstract:
We 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.
Speaker(s):
- Allan Mitchell
Track and Room: BI - N/A
Title: Intro to SQL Azure Federations
Abstract: Let’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.
Speaker(s):
- Anton Staykov
Track and Room: SQL Azure Personal Development - N/A
Title: Mobile Business Intelligence for Everyone, Now!
Abstract: 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!
Speaker(s):
- Jen Stirrup
Track and Room: BI - N/A
Title: The good, the bad and the ugly of SQL Server param
Abstract: What 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 performance
Speaker(s):
- Margarita Naumova
Track and Room: Developer - N/A
Title: NoSQL and Windows Azure platform
Abstract: 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;
Speaker(s):
- Miroslav Lessev
Track and Room: SQL Azure Personal Development - N/A
Title: SQL Server 2012 Analysis Services - practical over
Abstract: SQL 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.
Speaker(s):
- Margarita Naumova
Track and Room: BI - N/A
Title: Is “the bigger the better” valid in the DB world?
Abstract: 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.
Speaker(s):
- Ivan Donev
Track and Room: DBA - N/A
Title: Database corrupt! What’s next?
Abstract: 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 skills
Speaker(s):
- Margarita Naumova
Track and Room: DBA - N/A
Title: Let’s talk real-world private cloud implementation
Abstract: Session 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.
Speaker(s):
- Boris Hristov
Track and Room: SQL Azure Personal Development - N/A
Title: SQL for Developers with SQL Server Data Tools
- Abstract:
- 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.
Speaker(s):
- Ventsy Popov
Track and Room: Developer - 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.
Anton Staykov
Contact: http://blogs.staykov.net
Anton Staykov is a Microsoft MVP for the Windows Azure and founder of the Windows Azure User Group Bulgaria. Anton has more than 11 years of solid experience in developing applications for different domains – corporate sites, media portals, e-commerce, intranet LoB applications. As a Windows Azure consultant he helps ISVs migrate their applications to the cloud. A bachelor in Telecommunications and Master is Sciences in Internet Software Technologies.
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.
Ivelin Andreev
LinkedIn: Ivelin Andreev
Contact: https://www.slideshare.net/ivoandreev
Ivelin is a Microsoft Azure MVP and software architect in one of the leading and highly innovative Bulgarian IT brands - Interconsult Bulgaria Ltd. He is an external ICT expert in the European Commission, Eurostars-Eureka programme and Innovation Fund Denmark, Microsoft professional developer, senior project manager and Data Platform specialist. With 17+ years of strong experience in design and development of web systems, SOA, enterprise integration, machine learning, web security and data management, he is a practical man who always tries to balance between risk and flexibility. Never scared of work he has turned the weighing of pros and cons into own marked style that urges to make conscious decisions.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Ivan Donev
Contact: http://www.mssqlinsider.com/
Ivan 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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Ivelin Andreev
LinkedIn: Ivelin Andreev
Contact: https://www.slideshare.net/ivoandreev
Ivelin is a Microsoft Azure MVP and software architect in one of the leading and highly innovative Bulgarian IT brands - Interconsult Bulgaria Ltd. He is an external ICT expert in the European Commission, Eurostars-Eureka programme and Innovation Fund Denmark, Microsoft professional developer, senior project manager and Data Platform specialist. With 17+ years of strong experience in design and development of web systems, SOA, enterprise integration, machine learning, web security and data management, he is a practical man who always tries to balance between risk and flexibility. Never scared of work he has turned the weighing of pros and cons into own marked style that urges to make conscious decisions.
Allan Mitchell
Twitter: - @allanSQLIS
Contact: https://onlysearch.wordpress.com/
Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Tobiasz Koprowski
Contact: http://koprowskit.eu/geek/
Community 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.
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.
Ventsy Popov
Contact: http://ventsypopov.com
Ventsy 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.
Miroslav Lessev
LinkedIn: Miroslav Lessev
I am a PhD candidate at Faculty of Economics and Business Administration, University of Sofia quot;St. Kliment Ohridskiquot; 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 20 years of experience in designing, developing, implementing and supporting databases. At the moment I#39;m a Big Data Developer in DataCore Software.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Tobiasz Koprowski
Contact: http://koprowskit.eu/geek/
Community 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.
Boris Hristov
Contact: http://borishristov.com/blog/
Boris 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.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Nikolay Chorbanov
I 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.
Sponsors
The following is a list of sponsors that helped fund the event: