SQLpassion BLOG

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!

08/04/2014 / By / .NET German, SQLServer, SQLServerPedia

As you might know, I’m running my “SQL Server 2012 Deep Dive Days Workshop” from May 28 – 30 in Central London. You can find out further information about the detailed agenda here: http://www.SQLpassion.at/SQL2012_UK.pdf Next week you have the amazing possibility to win a free seat in that workshop! It’s very easy: Just register as …

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London! + read more

SQL Server 2012 AlwaysOn Availability Groups – Part 1

08/04/2014 / By / .NET German, AlwaysOn, SQLServer, SQLServerPedia / 4 Comments

In the last weeks and months I have prepared tons of SQL Server 2012 content for my own SQL Server 2012 Deep Dive Days workshop that I’m currently running across Europe. Because this content shows in a very good way how you can use all the various new features of SQL Server 2012, I have …

SQL Server 2012 AlwaysOn Availability Groups – Part 1 + read more

Deprecated Features in the SQL Server 2012 Database Engine

08/04/2014 / By / .NET German, SQLServer, SQLServerPedia / 3 Comments

As you might know, Microsoft has released on March 7 the RTM version of SQL Server 2012. If you are an MSDN or TechNet Subscriber, you can already download it and play with it. As with every SQL Server release, SQL Server has also marked several features as deprecated, which means they are removed in …

Deprecated Features in the SQL Server 2012 Database Engine + read more

New upcoming events across Europe

08/04/2014 / By / .NET German, Conferences, SQLServer, SQLServerPedia

I’m very happy today to announce 4 new upcoming SQL Server workshops across Europe within the next months:   SQL Server Configuration Day Date/Location April 26 in Zurich/Switzerland May 16 in Vienna/Austria Agenda Storage Configuration IO Subsystem Tests Disk Partition Alignment RAID Configuration Data-/Log-File Configuration TempDb Configuration CPU/Memory Configuration Resource Governor CPU Affinity Settings Parallelism …

New upcoming events across Europe + read more

Statistics Enhancements in SQL Server 2012

08/04/2014 / By / .NET German, SQLServer, SQLServerPedia / 2 Comments

Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already know SQL Server uses Statistic Objects in a database to estimate the cardinality of queries. The cardinality estimation is the input for the generation of the physical Execution Plan of a given T-SQL query. Data changes over time, data distribution …

Statistics Enhancements in SQL Server 2012 + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.