50% Rabatt für SQL & SharePoint Connections!

Super 50% Rabatt für SQL Server UG Austria Mitglieder und Follower für das SQL & SharePoint Connections event am 8. und 9. Mai in Berchtesgaden! Internationale Top-Referenten der Branche präsentieren und behandeln am Beispiel konkreter Produktionsumgebungen die Themen Migration, Sicherheit, Reporting, Leistungsoptimierung und vieles mehr (u.a. Klaus Aschenbrenner, Chris Webb, Margarita Naumova, Gianluca Hotz, Constantin Klein…). Hier ist das Angebot:

—————————————————————————————————————————-

Exclusive offer to  UG members.
join the   SQL & SharePoint Connections event to be held in Berchtesgaden at the Kongress Haus  May 8th and 9th  and save a massive 50% off the delegate rate.

Steve Fox  Microsoft Director USA SharePoint  keynote, on  day one, will talk about  Big Data, Cloud, and SharePoint.  Aaron Bertrand SQL Server keynote day two   will discuss SQL Server Right Here Right Now!
Joining Steve and Aaron  will be well known  SQL Server, and SharePoint  industry international and local  experts, and authors, who will explain all you need to know  about the new features and benefits of SQL 2012, how it works with the cloud, best practices, and business intelligence capabilities, also  Learn  about what tools and features  will allow you to build better solutions on top of SharePoint.

Sessions will be delivered in German,  and English – you will receive all speaker slides  for both SQL and SharePoint for attending the event.  Complimentary breakfast and lunch and refreshments  will be provided  both days.
There will be a free drinks  networking evening,  where speakers will join you for drinks and questions. There is accommodation nearby to suit all, via the Tourist office, or event organisers.
Places are limited,  if you want to attend we are inviting you to join us and save a massive 50% off the price on the website. Just enter this code to receive your discount   CM74250PC

Register here http://nccomms-events.com/sql-sp-connections/

SQL Server Parallel Datawarehouse Update #3 (AU3)

Gemeinsam mit dem Launch des SQL Server 2012 wurde auch ein Update für die SQL Server Parallel Datawarehouse Appliance (kurz: PDW) angekündigt. Das Appliance Update (kurz: AU) bringt neben Soft- und Firmware immer auch Hardwareupdates – einer der Vorteile von Appliances! Verbessert werden diesmal die Performance (und zwar massiv!), die Verwaltung, die Programmiermöglichkeiten und nicht zuletzt die Unterstützung von 3rd Party Werkzeugen (z.B. für ETL, BI).

Die Erweiterungen im Detail:

Feature	Benefit	Description
Cost based optimizer	Better query performance via improved DSQL Plan generation Full alignment of security system and metadata	Introduces a fully cost-based MPP optimizer.
DMS (Data Movement Services)	Dramatic improvement in query speed and appliance throughput	Removes data type conversions from Data Movement Server
½ rack Appliances from Dell and HP	Lower price and entry level capacity for MPP data warehousing	Dell ½ racks available now HP to ship ½ racks by April
System Center Integration (SCOM pack)	Lower cost of PDW monitoring and administration Seamless management of PDW and standard SQL Server instances	Fully integrates PDW to Systems Center Operations Manager
Stored Procedures (subset)	Greater application compatibility Closer affinity to SQL Server dramatically reduces system conversion effort and time Provides modular programming, standardization and re-usability	Introduces the Stored Procedure object to PDW Enriches programmability for PDW by putting process control closer to data objects
TDS/MSFT (Native SQL Server drivers	Enhanced PDW support for other SQL Server Applications Common connectivity stack as SQL Server SMP	Tabular Data Stream – Native protocol for communicating with SQL Server.
More expressive query language	Ability to write and encapsulate query sophistication using ‘built-in’ T-SQL	Addition of more expressive functions to PDW T-SQL
Integration to SAS	Full integration to key 3rd party BI and ETL tools to leverage existing solutions and BI platform investments	Extends PDW integration to third-party tools to SAS
Collations	Full support for International Data	Extends PDW collation sequence beyond Latin Bin 2

SQL UG Austria Meeting 08.03.2012 – Unterlagen II (AlwaysOn)

Die Präsentation zu AlwaysOn ist unter der folgenden URL zu finden:

http://sdrv.ms/AgCAts

Wer AlwaysOn und die Konfiguration von AlwaysOn ausprobieren möchte ohne selbst eine Infrastruktur aufzubauen den seien die “SQL Server Virtal Labs” empfohlen:
http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx

AlwaysOn Ressourcen Center auf msdn:
http://msdn.microsoft.com/en-us/sqlserver/gg490638(en-us,MSDN.10)

Offizielle Produktdokumentation auf msdn (“Lösungen mit hoher Verfügbarkeit (SQL Server)”):
http://msdn.microsoft.com/de-de/library/ms190202(v=sql.110).aspx

SQL UG Austria Meeting 08.03.2012 – Unterlagen (XEvents)

Hallo,

Vielen Dank für Eure Teilnahme an unserem heutigen SQL Server UG Treffen!

Folien und Code Beispiele relevant für die Extended Events Session können stehen hier zur Verfügung.

LG,
Milos

SQL Server 2012 RTM Evaluierungsversion

SQL Server 2012 RTM  steht zur Verfügung!

Die Evaluierungsversion kann aus dem Microsoft Download Center geladen werden.

Viel Spaß beim Entdecken!

Nächstes User Group Meeting am 08.März

Liebe Community unser nächstes SQL Server User Group Austria Meeting findet am 08. März um 17:30 statt – also unmittelbar nach der offiziellen SQL Server 2012 Launch Veranstaltung (www.sqlserverlaunch.com). Wir haben uns auf die folgenden 2 spannenden Themen geeinigt:

• SQL Server 2012 AlwaysOn (die neue Hochverfügbarkeitslösung)
• Extended Events in SQL Server

Beim Thema AlwaysOn werden wir einerseits die neue HA Lösung vorstellen, uns technischen Details und Szenarien widmen und die Unterschiede zum bestehenden Clustering und Mirroring beleuchten und dann in einer Live Demo ansehen wie man so eine Lösung aufsetzt, konfiguriert und betreibt.

Agenda zum 2. Thema Extended Events in SQL Server 2008 (R2)

• Übersicht
• Extended Events vs. SQL Trace
• Extended Event Session Examples – Demo

Erweiterungen in SQL Server 2012:

• GUI
• Neue Events(300+) und Objekte
• SQL Trace – Extended Events Mapping

Bitte wieder um eine formlose Anmeldung per Mail an sqlserverug@live.at.

Zeit: 08.03.2012 ab 17:30
Ort: Microsoft Österreich, Am Euro Platz 3, 1120 Wien
Teilnahme: für jedermann/jederfrau und kostenlos

Wir freuen uns auf eine zahlreiche Teilnahme!

SQL Server 2012 Virtual Launch Event

Der SQL Server 2012 Virtual Launch am 7. März 2012 (ab 17:00) ist ein exklusives online Event, das einen Überblick über die wichtigsten Neuigkeiten von SQL Server 2012 gibt. Das Event wird ausschließlich online und live gestreamt, die Teilnahme ist kostenfrei!

Auszug aus der Agenda (3 Schwerpunkte: Breakthrough Insights, Mission Critical Confidence, Cloud on Your Terms):

Breakthrough Insights

• Unlocking the Value of Big Data with Microsoft Business Intelligence
• Why Should Oracle DBAs Consider Microsoft SQL Server
• Rapid Data Exploration: Empowering End User Insight Through Rapid Data Exploration and Visualization with Power View
• Rapid Data Exploration: Powerful Self-Service Analysis with PowerPivot
• Credible, Consistent Data: Going Under the Hood with the New BI Semantic Model
• Credible, Consistent Data: Improving Data Quality with the New Data Quality Services
• Credible, Consistent Data: Introducing New Team-based Data Integration with Integration Services
• Scalable Analytics & Data Warehousing: Fast Track for SQL Server 2012
• What’s new in Complex Event Processing using StreamInsight for SQL Server 2012

Mission Critical Confidence

• Required 9s and Data Protection: Introduction to SQL Server 2012 AlwaysOn, New High Availability Solution
• Required 9s and Data Protection: Automating SQL Server AlwaysOn Management
• Required 9s and Data Protection: Protect Data with Higher Chance of Recovery – Includes Recovery Advisor
• Blazing-Fast Performance: A Technical Best Practices Tour with ColumnStore Index
• Blazing-Fast Performance: Explore FileTables, Full-Text Search and Semantic Search for Faster, More Meaningful Results Across Unstructured Data
• Organizational Compliance: Using the New Security Features and Audit Enhancements to Increase Compliance Policies
• Peace of Mind: Scale Mission Critical Application Testing with Distributed Replay

Cloud on Your Terms

• Big Data Analytics with Apache Hadoop and SQL Server 2012
• Optimized Productivity: T-SQL Enhancements
• Synchronizing Data “From On-Prem to Cloud” or “Cloud to Cloud” Using SQL Azure Data Sync
• Fast Time to Solution: Introduction to HP Business Decision Appliance and HP Business Data Warehouse Appliance
• Fast Time to Solution: A Private Cloud – Understanding the HP Database Consolidation Appliance
• Scale on Demand: Enable On-demand Scale with SQL Azure Federation
• Scale on Demand: Optimizing SQL Server 2012 for Private Cloud

Hauptredner

Ted Kummert
Corporate Vice President, Business Platform Division, Microsoft

Join Ted Kummert as he explores the Microsoft data evolution vision. As data continues to explode, executives are facing a sea of change and exploring short and long-term solutions to handle this unprecedented more growth. The new world of data brings organizations an incredible opportunity to access, blend, and analyze traditional and non-traditional data for new business models and opportunities.

Quentin Clark
Corporate Vice President, Database Systems Group, Microsoft

Join this launch session to get a high-level look at what’s new in SQL Server 2012, the cloud-ready information platform. Through SQL Server 2012, Quentin will address some of the tough issues facing IT more organizations today; mission critical SLAs that are simply expected, the explosion of data volumes and the need to get insights from this data, and the evolution into the virtualized world—all backed by product demos from SQL Server product experts.

Hier geht’s zur Anmeldung…