SQLU Summit 2012 in BRATISLAVA

I know that finding time to attend business events is becoming more and more difficult, but there is a great SQL Server Conference in Bratislava.

Enjoy the lovely capital of Slovakia in the heart of Europe! From September 19th to 21st a selected group of top-speakers from the SQL Server Community is heading in to give you deep insight into SQL Server 2012 in many different aspects . Exchange with experts and colleagues about the possible deployments of these new technologies in practice!

Intensive three-day workshops, keynote by Lubor Kollar with insights into what is currently the SQL Server kitchen simmers and 27 exciting three-day sessions result in a sustained learning experience.

Who's who SQL Speakers:
    • Lubor Kollar - Principal Program Manager in SQL Server Engine Development Team
    • Itzik Ben-Gan – globally renown T-SQL guru, author and trainer (T-SQL Champion)
    • Thomas Kejser - Principal Program Manager at Microsoft. Performing fast loading of warehousing! (removing every bottleneck)
    • Dejan Sarka – Data Mining guru
    • Davide Mauri – BI expert, awards for best-rated session
    • Alexei Khalyako - SQL Regional Program Manager at SQL Server International Customer Advisory Team
    • Karol Papaj - SQL Server MVP and local hero
    • Microsoft SQL Server Development Team from Belgrade

Early Bird until 15. August: € 834.00 (excl. VAT) 
AS a member of PASS Germany until 15. August: € 750.60 (excl. VAT)

Remember as a member of PASS Deutschland e.V you get a very special discount - so become a member of the great German Microsoft SQL Server Community - http://www.sqlpass.de

I wish you a nice day,
tosc

Service Pack 2 (SP2) is available for SQL Server 2008 R2

SQL Server R2 Service Pack 2 (SP2 Build 10.50.4000.0) is available:

http://www.microsoft.com/en-us/download/details.aspx?id=30437

 

List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2
http://support.microsoft.com/kb/2630458

I wish you a nice day,
tosc

 

Torsten Schuessler

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 3 (CTP3) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 3 (CTP3)
 
The SQL Server 2012 builds that were released after SQL Server 2012 was released:
 

Ganze Geschichte »

Database Engine Service Startup Options in SQL Server 2012

Before SQL Server 2012, it was a difficult work to add a trace flag or a startup parameter other than the default startup parameters that SQL Server uses. And, by the way, how the paramater is added from SSCM - the registry keys may not be created correctly - resulting in SQL Server startup code skipping these parameters!!!
In those days, I copy my defaults to Notepad++, than I add paramaters in this way:
  1. Add any new parameters after the first 3 default parameters –d, -e, -l. IMPORTANT never change sorting of these parameters!
  2. Specify the ";" delimiter between each parameter! SSCM uses ";" as the delimiter between parameters.
  3. Do NOT use a space after the delimiter and the parameter identifier (which is the "-" character).
    Copy it back to startup paramaters - save - RESTART the service!
  4. Check the current SQL Server error log and verify that each parameter shows up in a new line and starts at the same indentation.

But now in SQL Server 2012 we have a "Startup Parameters" Tab!

  1. Add any new parameters in the Textfield (NEVER REMOVE the first 3 default pramaters!!!)



  2. After restarting check the current SQL Server error log and verify that each parameter shows up in a new line and starts at the same indentation.

Where to find out about trace flags

Checking the status of trace flags

You can check the status of your trace flags by using the following command:
DBCC TRACESTATUS

 

If you want to know something about Trace Flag 3226, please read Christoph Muthmann's (aka cmu) post:
Trace Flag 3226

 
I wish you a nice day,
tosc

 

Torsten Schuessler

#CU package 2 for SQL Server 2012

The Cumulative update package 2 for SQL Server 2012 (Build 11.0.2325.0) is available:

Cumulative update package 2 for SQL Server 2012 is available

And here you can get the whole information of builds that were released after SQL Server 2012 was released:

http://support.microsoft.com/kb/2692828/

 

I wish you a nice day,
tosc

 

Torsten Schuessler

CUs available for SQL Server 2008 R2

The Cumulative update package 14 for SQL Server 2008 R2 (Build 10.50.1817.0) is available:

Cumulative update package 14 for SQL Server 2008 R2

And here you can get the whole information of builds that were released after SQL Server 2008 R2 was released:

http://support.microsoft.com/kb/981356/

 
 

The Cumulative update package 7 for SQL Server 2008 R2 Service Pack 1(Build 10.50.2817.0) is available:

Cumulative update package 7 for SQL Server 2008 R2 Service Pack 1

And here you can get the whole information of builds that were released after SQL Server 2008 R2 Service Pac k 1 was released:

http://support.microsoft.com/kb/981356/

I wish you a nice day,
tosc

 

Torsten Schuessler

PASS Deutschland e.V. Franken - Mittwoch, 20.06.2012 18:30 Uhr - Das SQL Administrator Einmaleins für SharePoint Datenbanken - Patrick Heyde (Microsoft)‏

Hallo,

recht herzlich laden wir Sie und Ihre Mitarbeiter ein zum kostenlosen Pass-Vortrag "Das SQL Administrator Einmaleins für SharePoint Datenbanken“ am Mittwoch, 20.06.2012 in Nürnberg mit Patrick Heyde von Microsoft.
Agenda und Anmeldung unter www.it-schulungen.com

Ganze Geschichte »

SQL Server 2012 Upgrade Technical Guide - in depth

Microsoft has recently released the SQL Server 2012 Upgrade Whitepaper.

This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012.

 

SQL Server 2012 Upgrade Technical Guide 
Chapter 1 Upgrade Planning and Deployment
Chapter 2 Management Tools 
Chapter 3  Relational Databases
Chapter 4 High Availability
Chapter 5 Database Security
Chapter 6 Full-Text Search
Chapter 7 Service Broker
Chapter 8 SQL Server Express
Chapter 9  SQL Server Data Tools 
Chapter 10  Transact-SQL Queries 
Chapter 11 Spatial Data
Chapter 12  XML and XQuery
Chapter 13 CLR
Chapter 14 SQL Server Management Objects
Chapter 15 Business Intelligence Tools
Chapter 16 Analysis Services
Chapter 17 Integration Services 
Chapter 18 Reporting Services
Chapter 19 Data Mining
Chapter 20 Other Microsoft Applications and Platforms
Appendix 1 Version and Edition Upgrade Paths 
Appendix 2  SQL Server 2012: Upgrade Planning Checklist

It is a must read - take a closer look to the appendix :-)

I wish you a nice day,
tosc

 

Torsten Schuessler

SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available

List of bugs that are fixed in SQL Server 2008 R2 Service Pack 2 CTP (Customer Technology Preview):
http://support.microsoft.com/kb/2630455

How to obtain the latest service pack for SQL Server 2008 R2: http://support.microsoft.com/kb/2527041

Full story »

PASS Deutschland e.V. Franken - 22.05.2012 18:30 Uhr - Zugriff auf SAP-Daten mit Theobald-Konnektoren und Microsoft SQL Server

 

Hallo,

recht herzlich laden wir Sie ein zum kostenlosen PASS-Vortrag „Zugriff auf SAP-Daten mit Theobald-Konnektoren und Microsoft SQL Server“ am Dienstag, 22.05.2012 in Nürnberg. 

Ganze Geschichte »