SQLSaturday #225 - Kosovo 2013
Event Date: 05/18/2013 00:00:00
Event Location:
- Innovation Centre Kosovo
- Rexhep Mala strt. 28A
- Prishtina, , Albania
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: FILETABLEs: What They Are and How to Use Them
Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker(s):
- Matija Lah
Track and Room: Ligjerimet - N/A
Title: A Deep Dive in SQL Server 2012 Data Warehousing
Abstract: SQL Server 2012 brings strong support for data warehousing (DW). However, even in the previous versions there has been a lot of effort put in DW enhancements: star join optimization through bitmap filters, known from SQL Server 2008, table partitioning and basic window functions known from SQL Server 2005, indexed views, known from SQL Server 2000, and more. In SQL Server 2012, the Transact-SQL language is enhanced with advanced window functions. Columnstore indexes are a new way of storing data for efficient DW queries. This session explains the theoretical background for the enhancements and how they can be useful in a data warehousing scenario.
Speaker(s):
- Dejan Sarka
Track and Room: Ligjerimet - N/A
Title: 10 Things to survive as DBA
Abstract:
Speaker(s):
- Dukagjin Maloku
Track and Room: Ligjerimet - N/A
Title: SQL Injection: From Website to SQL Server
Abstract: SQL Injection is still one of the biggest reasons various websites and applications get hacked. The solution, as everyone tells us, is simple: Use SQL parameters. But is that enough? In this session, we’ll look at how an attacker would go about using SQL Injection to gain access to your database, see its schema and data, and do nasty stuff to both. Then we’ll see how to battle such attacks at the UI front, the middle tier, and the SQL Server back end. Prerequisites: .Net, C#, T-SQL
Speaker(s):
- Mladen Prajdić
Track and Room: Ligjerimet - N/A
Title: HA DR with SQL Server 2012 AlwaysOn Availability Group
Abstract: The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. In this session we will talk about what’s coming with Always On, and how does it help to improve high availability and disaster recovery solutions.
Speaker(s):
- Turgay Sahtiyan
Track and Room: Ligjerimet - N/A
Title: Inheriting a database for Developers, version 2
Abstract: There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations.
Speaker(s):
- Niko Neugebauer
Track and Room: Ligjerimet - 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.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
Turgay Sahtiyan
Twitter: - https://twitter.com/turgaysahtiyan
LinkedIn: Turgay Sahtiyan
Contact: http://www.turgaysahtiyan.com/
Turgay Sahtiyan has been working in IT industry over a decade and he currently works as a PMC (Premier Mission Critical) Solution Engineer at Microsoft.He is based in Turkey and primarily giving proactive and reactive services with solution based approach to top enterprise customer in the MEA region.Before joined to Microsoft, he was one of the SQL Server MVP in Turkey,in addition he is founder and former president of SQLPass Turkey Chapter.(Detailed BIO http://www.turgaysahtiyan.com/about.aspx)
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
Dukagjin Maloku
Twitter: - https://twitter.com/DugiDBA
LinkedIn: Dukagjin Maloku
Contact: http://dukagjinmaloku.wordpress.com/
DBA
Sponsors
The following is a list of sponsors that helped fund the event: