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.

StreamInsight sample from my 24HOP session

by Klaus Aschenbrenner

Klaus Aschenbrenner

As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...

2010-09-17

525 reads

Test Posting

by Klaus Aschenbrenner

Klaus Aschenbrenner

From Klaus Aschenbrenner….

2010-09-10

443 reads

Unique and non-unique non-clustered indexes on a non-unique clustered index

by Klaus Aschenbrenner

Klaus Aschenbrenner

In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...

2010-09-07

4,084 reads

Unique and non-unique non-clustered indexes on a unique clustered index

by Klaus Aschenbrenner

Klaus Aschenbrenner

In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...

2010-08-31

9,782 reads

Unique/Non-Unique Clustered Indexes

by Klaus Aschenbrenner

Klaus Aschenbrenner

In the last blog post I have talked about unique/non-unique clustered indexes on a heap
table. A table without a clustered...

2010-08-19

8,182 reads

Unique and non-unique SQL Server indexes on a heap table

by Klaus Aschenbrenner

Klaus Aschenbrenner

In the upcoming weblog postings I want to work out the differences between unique
and non-unique indexes in SQL Server. I...

2010-08-18

3,209 reads

Blogs

A New Word: Apolytus

apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts

By Tracy McKibben

If you've ever wrestled with complex SQL code, you know the drill. Hours spent...

Check your regions people

By Koen Verbeeck

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...

Read the latest Blogs

Forums

Principal owns a service?

By Brandie Tarvin

This is one I haven't seen before. I'm trying to drop a database user...

Issues backing up Analysis Services databases - silent failures

I have a PowerShell script that I use to automate the backup of Analysis...

Read Only Replica in SQL Server Standard

By Stewart "Arturius" Campbell

Comments posted to this topic are about the item Read Only Replica in SQL...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers