SQLSaturday #335 - Athens 2014
Event Date: 10/04/2014 00:00:00
Event Location:
- Microsoft Hellas
- 221 Kifisias Ave
- Marousi, Attica, Greece
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 Data platform upgrade Techniques, best practices notes from the field
Abstract: Why Upgrade?This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices.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 end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources. 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 is offered.
Speaker(s):
- Satya Jayanty
Track and Room: Track 1 - N/A
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over FIFTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Track 1 - N/A
Title: Node.js and Open Source Software Development on Microsoft Azure
Abstract: Node.js is an exciting platform that has been increasing in popularity for the past few years. It offers a server side JavaScript programming model ideal for building highly scalable and performant network applications whether on premise or in the cloud. In this talk we will take a look at various options for building and deploying Node applications on Microsoft Azure. This session is how to useAzure SQL Databse and Azure Storage with Node.js
Speaker(s):
- Mihail Mateev
Track and Room: Track 1 - N/A
Title: AlwaysOn Availability Groups: Offloading reporting workloads to secondary replicas
Abstract: SQL Server AlwaysOn Availability Groups is a HADR feature introduced in SQL 2012. In this presentation we’ll talk about setting up readable secondary replicas, the impact of running reporting workloads on a secondary replica, and finally about monitoring data latency.
Speaker(s):
- Stelios Tzavaras
Track and Room: Track 1 - N/A
Title: Configuring SQL Server
Abstract: SQL Server has a plethora of configuration settings that are spread at server, database and connection level. The purpose of this session is to notify and clarify the most important configuration settings
Speaker(s):
- Antonios Chatzipavlis
Track and Room: Track 1 - N/A
Title: File IO Stalls and Wait Stats: Tune Like a Guru!
Abstract: When you know how to find out WHAT your queries are waiting on you get a very good how to fix then - or help the server as a whole in myany cases. Lots of stuff here you will want to put in your bag of tuning tricks
Speaker(s):
- Kevin Boles
Track and Room: Track 1 - 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.
Antonios Chatzipavlis
Twitter: - antoniosch
LinkedIn: Antonios Chatzipavlis
Contact: http://www.sqlschool.gr
I have been working in IT for over 25 years (since 1988). In my career, I have worked as junior and senior developer, ΙΤ Manager, Software Architect and IT Consultant.
The past 20 years I have been devoted on new technologies and software development tools, mainly by Microsoft Corp, either by training company staff and colleagues or assisting them in the design, development and implementation (as a consultant or chief developer).
Stelios Tzavaras
Stelios has started his professional IT carrier in 1988. He has worked at several software houses in Greece as a Junior and Senior Software Developer, Database administrator and Technical consultant. His experience in RDBS lies mostly in MS SQL Server but he is no stranger to Oracle, Sybase and DB2. In 2011 he joined Microsoft as a Senior Premier Engineer in SQL Server, and since then he is supporting and training premier customers in Greece and abroad. He thinks data is cool!
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
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.
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.
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: