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.

Vote for my precon workshop for PASS SQLRally

by Klaus Aschenbrenner

Klaus Aschenbrenner

I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...

2010-10-25

617 reads

Slides & Samples for my SQLbits workshop & session

by Klaus Aschenbrenner

Klaus Aschenbrenner

As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.

Have fun!

-Klaus

2010-10-04

407 reads

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

536 reads

Test Posting

by Klaus Aschenbrenner

Klaus Aschenbrenner

From Klaus Aschenbrenner….

2010-09-10

450 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,099 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,795 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,197 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,227 reads

Blogs

Fabric Mirroring doesn’t start copying Rows

By Koen Verbeeck

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Read the latest Blogs

Forums

Breaking SQL Server for disaster recovery practice

Hey all. I understand if this gets taken down due to the subject matter...

Creating a JSON Document I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document I

Who is Irresponsible?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who is Irresponsible?

Visit the forum

Question of the Day

Creating a JSON Document I

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers