Nr: 152
SQLSaturday #152 - Bulgaria 2012
SessionID: 10613
Let's talk real-world private cloud implementation
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SQL Azure Personal Development
Speaker: Boris Hristov
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.
SessionID: 15449
Is "the bigger the better" valid in the DB world?
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Ivan Donev
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.
SessionID: 15457
Dare to build vertical design with relational data
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Ivelin Andreev
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.
SessionID: 15458
Practical SQL query monitoring and optimization
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Ivelin Andreev
Title: Practical SQL query monitoring and optimization
Abstract:
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.
SessionID: 16570
Business Intelligence in Azure: SSIS SSRS 2012
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Jen Stirrup
Title: Business Intelligence in Azure: SSIS SSRS 2012
Abstract:
SessionID: 16572
Mobile Business Intelligence for Everyone, Now!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Jen Stirrup
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!
SessionID: 19357
SQL Server 2012 Analysis Services - practical over
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Margarita Naumova
Title: SQL Server 2012 Analysis Services - practical over
Abstract:
SessionID: 19358
The good, the bad and the ugly of SQL Server param
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Margarita Naumova
Title: The good, the bad and the ugly of SQL Server param
Abstract:
SessionID: 19360
Database corrupt! What’s next?
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Margarita Naumova
Title: Database corrupt! What’s next?
Abstract:
SessionID: 20256
Practical methods for OLAP Data Visualization
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mihail Mateev
Title: Practical methods for OLAP Data Visualization
Abstract:
SessionID: 20259
Using SQL Local Database in Mobile Applications
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Mihail Mateev
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.
SessionID: 20260
Spatial Data with SQL Server Reporting Services
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mihail Mateev
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.
SessionID: 20742
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Miloš Radivojević
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.
SessionID: 20950
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SQL Azure Personal Development
Speaker: Miroslav Lessev
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;
SessionID: 21447
Top 10 Myths and Mistakes for the DBA
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Nikolay Chorbanov
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.
SessionID: 26947
Welcome to the Licensing Nightmare
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Tobiasz Koprowski
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
SessionID: 26949
High Availability of SQL in the context of SLA
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SQL Azure Personal Development
Speaker: Tobiasz Koprowski
Title: High Availability of SQL in the context of SLA
Abstract:
SessionID: 27369
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Ventsy Popov
Abstract:
SessionID: 9308
SQL Server 2012 SSIS Change Data Capture
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Allan Mitchell
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.
SessionID: 9688
Intro to SQL Azure Federations
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SQL Azure Personal Development
Speaker: Anton Staykov
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.