SQLSaturday #565 - Bucuresti 2016
Event Date: 09/24/2016 00:00:00
Event Location:
- Microsoft Romania
- Piața Presei Libere nr. 3-5 Clădirea City Gate Turnul de Sud, Etaj 2
- București, Bucureşti, Romania
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: How to monitor efficiently your SQL Server instances
Abstract: Do you plan to start monitoring your SQL Server instances soon and asking yourself what should you measure? Are you questioning if your existing monitoring data can detect and alert if a performance problem occurs? Is the data you collected from monitoring enough to pinpoint the cause of your next performance problem?
I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I’ve investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.
Speaker(s):
- Remus Rusanu
Track and Room: Enterprise Database Administration Deployment - Downtown2
Title: 2,4,8 16 - Upgrade your journey with SQL Server
Abstract: 2,4,8 16 - these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number of years!
Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.
What to-do and what not-to-do?
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
Speaker(s):
- Satya Jayanty
Track and Room: Enterprise Database Administration Deployment - Downtown1
Title: AlwaysOn Availability Groups for Developers
Abstract: It’s often difficult to choose a high-availability solution and to build your applications around it, Come join me in a session focused on AlwaysOn Availability Groups - how they actually work, how to get the most of them, learn the benefits they provide and the limitations they have. Or at least put a DB Administrator on the interrogation table.
Speaker(s):
- Kaloyan Kosev
Track and Room: Application Database Development - Downtown1
Title: Troubleshooting Performance in SQL Server 2016
Abstract: The SQL Server Query Store is one of the most known features of SQL Server 2016 that provides insight on query plan choice and performance. It simplifies performance troubleshooting by enabling you to quickly find performance differences caused by changes in query plans. However in this session we will explore not just Query Store but also additional features that allow performance troubleshooting in SQL Server 2016.
Speaker(s):
- Cristian Lefter
Track and Room: Application Database Development - Downtown2
Title: Think work like a Data Scientist with SQL 2016 R
Abstract: What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: BI Information Delivery - Cinema
Title: New Security Features in SQL Server 2016
Abstract: New Security Features and Best Practices with SQL Server 2016 The session will cover Dynamic Data Masking, Row Level Security, Always Encrypted, Cell Level Security
Speaker(s):
- Alexandra Ciortea
Track and Room: Strategy and Architecture - Cinema
Title: SQL Server 2016 - Execution Plan Analysis
Abstract: How to capture execution plans and how to read an execution plan. Quick overview of the most encountered operators. What kind of informations you can find in an execution plan and what conclusions can you draw by looking at this information. How to takle a bad plan - patterns to look out for.
Speaker(s):
- Liviu Ieran
Track and Room: Application Database Development - Downtown2
Title: SQL Server Azure VMs - your databases in the cloud
Abstract: While Microsoft Azure SQL Database can be an option for moving our databases to the cloud, as DBAs we still want to have full control on the SQL Server instances and on the resources we have available, so moving our databases to a SQL Server Azure VM is the way to go.
Let’s have a look at what the Azure IaaS has to offer when it comes to migrating the SQL Server to the cloud and what are some of the best practices when you decide to do so, while touching both on the pros and cons of such a decision. We will be covering the details of setting up a SQL Server Azure VM, emphasizing what are the requirements for a highly available and high performance system.
Speaker(s):
- Cezar Ionescu
Track and Room: Enterprise Database Administration Deployment - Downtown1
Title: Power BI Desktop – Leveraging the magic of Power BI - ON-PREM
Abstract: It won’t be long before we host the majority of our data, compute power, reporting, and BI visualizations in the cloud, but we’re not all there quite yet. In this presentation, we will discuss ONLY those options that are available on-premises, covering functionality differences between Power BI and Power BI Desktop as well as the critical integration of .pbix dashboards and visualizations with other enterprise reporting and collaboration tools, such as SharePoint, PowerPoint, Excel, and SQL Server Reporting Services. We’ll also highlight the Microsoft BI roadmap for SQL Server 2016, SSRS, Power BI, Mobile Reports, and what it means specifically for on-premise customers.
Speaker(s):
- Sam Lester
Track and Room: BI Information Delivery - Cinema
Title: Query Plan Deep Drive
Abstract: Another in TheSQLGuru’s Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - Downtown2
Title: IoT Duel - Cloud vs. on Premises Solutions
Abstract: This talk is a parallel, between IoT solutions, based on premise and systems, build with Microsoft Azure components. The presentation will cover the architecture, technology stack, implementation and best practices. We will consider plusses and deltas in different cases, using both approaches. You will see also many demos, which will help you to build own cloud based or on premises Internet of Things systems.
Speaker(s):
- Catalin Gheorghiu
Track and Room: Professional Development - Cinema
Title: Productivity tips for Sql Server Management Studio
Abstract: Have you ever wondered how you can improve your productivity while using Sql Serve Management Studio? I would like to share with you some tips tricks I discovered along my ride with Sql Server and also present you a few free 3rd party tools from Sql Server ecosystem that will help you increase your speed and improve your development experience.
Speaker(s):
- Bogdan Curca
Track and Room: Application Database Development - Downtown2
Title: SQL Server Consolidation
Abstract: Roadmaps for SQL Server consolidation and version upgrade. Consolidation options covered include: multi-database single-instance servers, multi-instance on one or more physical servers, and finally reduction of physical servers through virtualization (Hyper-V) or cloud based technologies.
Speaker(s):
- Andrada Nastasie
Track and Room: Enterprise Database Administration Deployment - Downtown1
Title: A time travel with temporal tables
Abstract: Temporal Tables is a new feature in SQL Server 2016, that allows to see the data (in one or more tables) exactly as they were in a point of time ago.
In this session will be shown the most useful scenarios: 1) Recovering from an undesired data change 2) Auditing efects 3) Trending Analytics
Speaker(s):
- LEONEL ABREU
Track and Room: Enterprise Database Administration Deployment - Cinema
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Cristian Lefter
LinkedIn: Cristian Lefter
Cristian Lefter is Principal of Esential Training and one of the SQL Server MVPs. His primary competence is training. He is also a consultant, author, speaker and community leader. As his main expertise is Microsoft SQL Server, which resulted in founding an official PASS chapter, writing books and articles, contributing at the development of Microsoft Official Courseware, authoring certification exams, speaking at technical events and working as a Subject Matter Expert in various projects.
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Kaloyan Kosev
Twitter: - https://twitter.com/nosqltillcoffee
LinkedIn: Kaloyan Kosev
Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.
Cezar Ionescu
My journey in the database world started back in high school, when I first got my hands on a FoxPro book. Since then, I worked with different RDBMS systems and finally settled for SQL Server back in 2008, when I also joined Microsoft as an intern in the SQL Server Support team. In the years that followed, I#39;ve improved my skills and managed to develop into a Technical Lead for SQL Server, which allowed me to explore SQL Server from different angles. Apart from the support work, I had the opportunity to have onsite engagements and also do consultancy work on different topics ranging from performance to high availability solutions. Since 2015 I am a MCSA, currently working my way to the MCSE certification.
Catalin Gheorghiu
Twitter: - MrSmersh
LinkedIn: Catalin Gheorghiu
Contact: http://ronua.ro/author/catalin/
Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.
Alexandra Ciortea
2005-2009 Computer Science - Polytechnic University of Bucharest 2009-2011 - Master -IT Management - Polytechnic University of Bucharest
I started working for Microsoft in 2009 as a Support Engineer for Project Server and SQL Server for EMEA. In 2012 I changed to a Premier Field Engineer position working onsite for SQL Server and Project Server
LEONEL ABREU
Twitter: - leonel_abreu
LinkedIn: LEONEL ABREU
An IT Pro who likes to play chess and baseball.
System Engineer degree since 2007, formerly Data Warehousing teacher at university levels from 2008 to 2009. Microsoft Student Partner during the years 2006 - 2007, Second Place in Microsoft Andean Imagine Cup (2006), MCTS, MCITP and MCP with over a decade of experience with SQL Server, working in BI, DBA, Database Development, .net Development, SharePoint and other several areas.
Since 2014 based in Barcelona, Spain. Learning enthusiast and always with passion for new technologies and new challenges.
Remus Rusanu
Twitter: - rusanu
LinkedIn: Remus Rusanu
Contact: http://rusanu.com
Remus Rusanu is a former SQL Server team member. For 12 years he worked on such features as Service Broker, Columnstore Indexes, Query Store and many more. In April 2016 he left Microsoft to found DBHistory.com, a simplified SQL Server monitoring and auditing product.
Sam Lester
Contact: http://blogs.msdn.com/b/samlester
Sam Lester has spent the past 14 years working for Microsoft in various SQL Server related roles. After nearly 12 years working in the SQL Server development team in Redmond, WA, he has recently made the switch to a consulting role to work hands-on with European customers. While in the product group, Sam worked on numerous features including setup, migration, SSMS/manageability, Utility Control Point, Data-Tier Application Component, SSDT, Intellisense, amp; TSQL Debugger.
Bogdan Curca
LinkedIn: Bogdan Curca
Bogdan Curcă graduated the Faculty of Cybernetics, Statistics and Economic Informatics and a Master program oriented on ERPs (SIMPRE). He is a techno - functional IT professional with experience on ERP and Business Intelligence systems. On the last 8 years, he has been implementing Business Intelligence solutions using all range of BI functionalities from Microsoft Sql Server, having a strong focus on understanding the business needs and trying to deliver systems that are actually used as a decisional support. He is passionate about technology and while he’s not in front of a computer, he likes travelling, listening to good music and playing ping pong. You can write him at bcurca (at) gmail (dot) com
Liviu Ieran
Twitter: - @Liviu_Ieran
LinkedIn: Liviu Ieran
More than 9 years of SQL Server experience working for Microsoft currently as a Support Escalation Engineer. My main area of expertise is SQL Server Performance where I helped optimize numerous query’s and environments.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Andrada Nastasie
I am working for Microsoft Romania as a Premier Field Engineer since September 2015. My areas of interest are SQL Server High Availability solutions, Security and Configuration. Before Microsoft, I worked as a Database Administrator for 2 years in the banking environment. I studied Computer Science at the Polytechnic University of Bucharest.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Sponsors
The following is a list of sponsors that helped fund the event: