Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the
.NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus
was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also
written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further
information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at
http://twitter.com/Aschenbrenner.

SQLMCM Training – Day 17

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...

2011-08-25

666 reads

SQLMCM Training – Day 16

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...

2011-08-24

635 reads

SQLMCM Training – Day 15

by Klaus Aschenbrenner

Klaus Aschenbrenner

The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...

2011-08-23

621 reads

Chance to win a free seat in my Performance Troubleshooting Workshop in London!

by Klaus Aschenbrenner

Klaus Aschenbrenner

As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting
Workshop" from September 12 – 14 in Central London. You...

2011-08-21

965 reads

SQLMCM Training – Day 11

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Jonathan presented on Replication and Paul about Database Snapshots, and his
baby called "CHECKDB" – he has been married with CHECKDB...

2011-08-19

923 reads

SQLMCM Training – Day 10

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...

2011-08-18

614 reads

SQL MCM Training – Day 9

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...

2011-08-17

957 reads

SQL MCM Training – Day 8

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...

2011-08-16

739 reads

MCM Training – Day 6 & 7

by Klaus Aschenbrenner

Klaus Aschenbrenner

My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...

2011-08-15

545 reads

SQL MCM Training – Day 5

by Klaus Aschenbrenner

Klaus Aschenbrenner

Today I've not taken too much notes, because the whole afternoon was about the Management
Data Warehouse and Multi-Instance Management. But...

2011-08-13

1,376 reads

Blogs

From Planning to Practice: Setting Up Your FinOps Framework

As someone who works in DevOps, I’m always focused on creating systems that are...

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers