19.-20. Oktober 2010, Rosenheim
SQLdays ist die Konferenz für die deutschsprachige SQL Server Community vom 19.-20. Oktober 2010 in Rosenheim. Freuen Sie sich auf drei parallele Tracks mit über 20 Sessions zu SQL Server Administration, Entwicklung und Business Intelligence. Treffen Sie Datenbank- und BI-Experten wie Klaus Aschenbrenner, Markus Raatz, Steffen Krause, Thomas Grohser oder Willfried Färber persönlich und erfahren Sie News aus erster Hand und wertvolle Tipps und Tricks aus der Praxis. In ganztägigen Workshops vor und nach der Konferenz haben Sie zudem die Gelegenheit spezielle Themen nochmal bis ins Detail zu vertiefen.
Sichern Sie sich jetzt Ihre Teilnahme unter
http://www.sqldays.net
SQL PASS has installed a new SQL Server/Oracle Virtual Chapter! The goal of the Chapter is "... to provide a conducive environment where through the use of online webinars( from both the SQL Server and Oracle Camps), web based articles and cross product/ cross pollination of concepts and ideas, our members are able to prosper and to pass the knowledge on to others."
SQL Server/Oracle Virtual Chapter looks like a promising place to connect SQL and Oracle DBAs!
Check out http://oracle.sqlpass.org/ for information and links to live meetings!
Dear all, Klaus Aschenbrenner will hold his presentation about SQL Server 2008 Database Internals on 10th June 2010 (17:00, Microsoft Österreich)!
Date: 10.06.2010
Start: 17:00
Location: Rooms Lava A, Microsoft Österreich GmbH, Am Euro Platz 3, 1120 Wien
Registration: sqlserverug@live.at
Title: SQL Server 2008 Database Internals
Sesstion Level: 300
Session length: About 60 Minutes with open end Q&A and discussion at the end
Speaker: Klaus Aschenbrenner, HP
Language: German
Abstract: Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyze the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution.
Target Audience: Anyone interested in how SQL Server internally works
Prerequisites: None
Sorry we had to move our next sql server user group meeting to 8th July due to BI conference in New Orleans and Solid Quality Summit!
Date: 08.07.2010
Start: 17:00
Location: Rooms Magma A, Microsoft Österreich GmbH, Am Euro Platz 3, 1120 Wien
Registration: sqlserverug@live.at
Title: Building BI Out of Scratch
Sesstion Level: 100 - 300
Session length: About 60 Minutes with open end Q&A and discussion at the end
Speaker: Petra Korica-Pehserl & Martin Fenyö, Microsoft Österreich
Language: German
Abstract: The goal of this presentation is to show how easy it is to build enterprise BI solutions from scratch using MS SQL Server 2008 R2 (SSIS, SSAS, SSRS) and Microsoft Office 2010 products.
We will show each step hands on starting from relational database, design and set up an ETL layer. Then we will discuss the basics of data warehouse modeling (data staging, data cleaning, data quality). Afterwards we will discuss basics of OLAP modeling and build an OLAP cube using Microsoft Business Intelligence Development Studio. Finally we will show how Excel 2010 can be used as a BI client for data analysis. Additionally we will also show how SQL Server Reporting Services can be used for reporting based on developed cube by using ReportBuilder.
Target Audience: Anyone interested in data analysis and pivots, business intelligence and multidimensional databases
Prerequisites: None
Yesterday we had a great talk from Kimberly L. Tripp in our usergroup. We discussed indexes and Kimberly revealed us interessting information about the internals and tuning tipps.
Here you can find the materials from the talk: http://www.sqlskills.com/resources/conferences/201004ViennaUserGroup.zip
Here you can find the companion content to Kimberly's chapter in SQL Server 2008 Internals book:
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Companion-content-for-Chapter-6-(Index-Internals)-of-SQL-Server-2008-Internals.aspx
Check it out here:
www.sqlserverlaunch.com
Versäumen Sie nicht den Solid Quality Summit 2010 , das Pflichtevent für die österreichischen SQL Server Community! Erleben Sie 4 EinTages-Seminare, 28 Sessions sowie eine Keynote präsentiert von namhaften Experten aus dem In- und Ausland. Die Konferenz gliedert sich in die Bereiche Business Intelligence, Database Administration und Development, dargeboten in 2 Tracks.
Weitere Informationen finden Sie auf der Summit Website:
http://summit.solidq.com/vienna
Zu den Speakern gehören unter anderen Itzik Ben-Gan , T-SQL Guru und Autor der einschlägigen Standardwerke; Rushabh Mehta , PASS Präsident und weltweit bekannter BI-Fachmann; Dejan Sarka , internationaler Experte für BI und insbesondere Data Mining; Thomas Grohser von bwin, der aus der Praxis einer der weltweit am meisten herausfordernden SQL Server Landschaften berichtet. Dazu kommen noch die Lokalmatadore Klaus Aschenbrenner , Herbert Albert , Petra Korica-Pehserl und weitere international tätige Experten wie Francisco Gonzalez , Gianluca Hotz oder Matija Lah .
21. Juni 2010 (Pre-Con Seminare)
Itzik Ben-Gan: T-SQL Solutions using Window Calculations
Dejan Sarka/Gianluca Hotz: Master Data Management with SQL Server 2008 R2
22.-24. Juni 2010
28 Sessions aus den Bereichen BI, DBA und DEV, dargeboten in 2 Tracks
23. Juni 2010
SQL Server 2008 R2 Launch Party
25. Juni 2010 (Post-Con Seminare)
Klaus Aschenbrenner: Performance Tuning / Indexing with SQL Server 2008
Rushabh Mehta: Advanced Business Intelligence Practices
Preis:
Preis für 5 Tage Full Solid Quality Summit: 1.590,00 EUR (exkl. Ust.)
Early Bird (bis 20.5.2010): 1.390,00 EUR (exkl. USt.)
SPEZIALPREIS für SQL SERVER UserGroup Mitglieder: 1.190,00 (exkl. Ust.)
Anmeldung für UG-Mitglieder per E-Mail unter: ceinfo@solidq.com
Gruppenpreis (ab 5 Teilnehmern) je Teilnehmer: 990,00 EUR (exkl. Ust.)
Slim Summit (3 Tage Konferenz 22.-24.6): 990,00 EUR (exkl. Ust.)
Seminarpreis (1 Tag): 450,00 EUR (exkl. Ust.)
Ort:
Microsoft Innovation Center
Am Euro Platz 2
1120 Wien
Partner:
Premium Sponsor: Microsoft www.microsoft.at
Gold Sponsor: it-versity www.itversity.com
Date: 29.04.2010
Start: 17:00
Location: bwin Event Zone, City Point, Marxergasse 1b, 1030 Vienna (U-Bahn (U3, U4)/Schnellbahnstation Landstraße)
Registration: sqlserverug@live.at
Title: SQL Server 2005/2008: Index Internals
Session length: 60 Minutes with Q&A at the end
Speaker: Kimberly Tripp
Language: English
Abstract: Understanding SQL Server indexes is an integral part of performance tuning. From initial base table strategies to long term workload performance tuning – indexes are at the heart of both the analysis and the solution. The real question is why? Why are indexes so critical and what do you need to know as either a developer or a DBA which will help you to build better indexes and move toward better indexing strategies overall. And, what are the most common pitfalls and problems? Where do most applications go wrong? And, what can you do to solve this in existing systems as well as build better solutions moving forward. Come to this fast-paced, demo-packed session to find out.
About the speaker: Kimberly L. Tripp (http://www.sqlskills.com/blogs/Kimberly) is a SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her own company SQLskills.com. Working for SQLskills, Kimberly enjoys the ability to work on different types of projects – from consulting to speaking to writing to presenting. In terms of some of these projects, Kimberly is a writer/editor for SQL Server Magazine; authored multiple whitepapers on SQL Server 2005; authored the Index Internals chapter of the new MSPress release SQL Server 2008 Internals and acted as an editor for the new SQL Server MVP Deep Dives title. In presenting, Kimberly has presented lectures and seminars at Microsoft Tech*Ed, SQLConnections, SQLPass, and other SQL Server-related events since 1996 and is consistently top-rated both on quality of technical content and presentation style. In consulting, Kimberly helps customers tackle their availability and performance problems as well as design and architect appropriate solutions. Currently, Kimberly is focused on SQL Server 2008 content for conferences and workshops around the world. For a more detailed bio, please see http://www.sqlskills.com/AboutKimberlyLTripp.asp.
Am kommenden Donnerstag um 17:00 findet das nächste Treffen der SQL Server User Group statt und Thomas Grohser, der SQL Server Guru von bwin, haltet einen Vortrag zum Thema
„How to scale out a database in a 24x7 environment for the world wide web and a worldwide audience“!
Kurzfassung Deutsch:
Das Problem von weltweit operierenden Internet Seiten ist das es praktisch keine Möglichkeit gibt die Systeme zu warten da Benutzer rund um die Uhr auf die Seite zugreifen.
Die Auswertungen der Zugriffstatistiken einiger der weltgrößten Sites haben aber gezeigt das es eine Möglichkeit gibt die Benutzer und ihre Daten so zu partitionieren das es immer möglich ist eine Partition zu warten weil es jeden Tag mehrere Stunden gibt in denen sie nicht benutzt wird.
Diese Session Zeigt wie das Prinzip funktioniert, was man beachten muss, wie man seine Kundendaten analysieren muss und worauf man bei der Applikation aufpassen muss.
Abstract English:
100% Uptime while doing 24h of Maintenance every day
The problem of globally operating internet sites or any other real 24x7 operation is, that there is no time for maintenance. This session will show you a way to partition your user data in a way that you can maintain each partition at least once a day. If you place the partitions on different servers you can even maintain the servers on a daily basis without interrupting your users.
You will hear how it works in theory, see a proof of concept demo and learn how to analyze your data to make the same partitioning for your application.
http://www.sqlserver-hwguide.com/Conferences/SQLUserGroupAT/SQLServerIO.pdf
Wie gestern im Meeting besprochen, haben wir folgende Themen zur Auswahl für unser nächstes Vortragsmeeting am 4.3.2010 (wieder ab 17:00 bei Microsoft Österreich):
- StreamInsight (DWH-Beladung über SSIS)
- 100% Availability without 100% Uptime
- How to scale out a database in a 24x7
environment for the world wide web and a world wide audience
- Avoiding Lawsuits: How to establish an SLA
- Zero Data Loss: What does this mean and how to implement it with SQL Server
- Zero Impact DWH Load in a 24x7 environment
- Operating very large SQL Servers: Tales from the “real” world
Bitte um Abstimmung per Mail: sqlserverug@live.at!
Hi there,
on 21st January 2010 there we will present a very interesting talk from Thomas Grohser called "SQL Server IO demystified". In this talk Thomas will discuss all I/O operations and all currently available types of storage systems and their applications!
We will start at 5pm in Rooms Magma A + B, Microsoft Österreich GmbH, Am Euro Platz 3, 1120 Wien
Please registration via sqlserverug@live.at
See you there!
SQLCAT (SQL Server Customer Advisory Team) ist ein Team innerhalb der SQL Server Gruppe bei Microsoft die sich Weltweit mit den grössten und interessantesten SQL Server Installationen befassen und mit diesen Kunden an besseren Lósungen arbeiten und die Ergebnisse dann auf www.SQLCAT.com veröffentlichen und in die nächsten SQL Server Versionen einfließen lassen.
http://www.sqlcat.com
Hi all!
Next SQL Server User Group Meeting will be:
Microsoft SQL Server 2008 Security
Petra Korica-Pehserl, Microsoft Austria
Date: 10.12.2009
Start: 17:00
Location: Rooms Magma A + B, Microsoft Österreich GmbH, Am Euro Platz 3, 1120 Wien
Looking forward to seeing you again!
Petra Korica-Pehserl
Unfortunately we need to cancel our user group meeting with talk about FILESTREAM/Table Valued Parameters from Klaus Aschenbrenner this Thursday because of illness. We will make sure to repeat this talk another time.
Sorry for the inconvience!