Klaus Aschenbrenner

SQL Server Indexing Day, 18. Jänner 2012 in Wien

10/04/2011 08/04/2014 / By Klaus Aschenbrenner / .NET German, Conferences, SQLServer

Sie wollen SQL Server Abfragen um 100% oder gar 1000% beschleunigt haben? Gleichzeitig wollen Sie Hardware– und Lizenzkosten Ihrer SQL Server Anwendungen und deren Infrastruktur senken? Ein Wunschdenken? – Keineswegs! Mit einer gut indizierten SQL Server Datenbank können Sie Geschwindigkeitsvorteile von mehreren 100% für bestimmte Abfragen gewinnen. Als positiven Seiteneffekt senken Sie die Hardwareanforderungen an …

SQL Server Indexing Day, 18. Jänner 2012 in Wien + read more

SQLMCM Training – Day 18

08/26/2011 08/04/2014 / By Klaus Aschenbrenner / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today we covered the topics Full Text Search, Change Data Capture, Change Tracking, and Service Broker. I have taken no notes on Service Broker, because I have well documented that topic a few years ago here. Full Text Search Fulltext Index is changed automatically in the background (by default) Fulltext Catalog is a container for …

SQLMCM Training – Day 18 + read more

SQLMCM Training – Day 17

08/25/2011 08/04/2014 / By Klaus Aschenbrenner / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know these concepts very well, my study notes for today are very sparse. Auditing SQL Trace has too much drawbacks from Auditing Separate program Column Level GRANT overrides a DENY Auditing audits changes to Auditing Auditing Targets can’t be shared Auditing uses …

SQLMCM Training – Day 17 + read more

SQLMCM Training – Day 16

08/24/2011 08/04/2014 / By Klaus Aschenbrenner / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting data. It was really hard content, and sometimes it was really hard to follow, because of too much PowerPoint slides. I already miss Paul’s whiteboard drawings… 😉 Here are my study notes. SQL Server Setup SQL Server VSS Writer Needed for …

SQLMCM Training – Day 16 + read more

SQLMCM Training – Day 15

08/23/2011 08/04/2014 / By Klaus Aschenbrenner / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia / 2 Comments

The whole last 3 days I’ve spent almost every minute with reviewing the material from the last 2 weeks (around 38 hours in total…). Today Bob Beauchemin joined us, and talks the whole week about SQL Server Development, Security, PowerShell, and some esoteric technologies like SQLCLR, Service Broker, and CDC/Change Tracking. Don’t expect too much …

SQLMCM Training – Day 15 + read more

SQLpassion Performance Tuning Training Plan – Signup