How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,372 reads
Klaus Aschenbrenner
2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)
Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community
Summit in Seattle last year. Since this...
2010-12-10
1,446 reads
Announcing the SQLDoctor
Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.
The concept of the SQLDoctor...
2010-11-17
566 reads
Slides & Samples for my SQLPASS sessions
As announced in both of my session you can find my slides & samples here for download:
Building FILESTREAM
solutions with SQL Server...
2010-11-15
660 reads
I’m speaking for the Performance Virtual Chapter of PASS
On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides...
2010-11-02
598 reads
I’m starting my own SQL Server Consulting business!
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,535 reads
Vote for my precon workshop for PASS SQLRally
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 from my SQLdays 2010 sessions and workshop
As announced in my workshop and in my sessions at the SQLdays 2010 last week in Rosenheim/Germany,
you can download my...
2010-10-25
469 reads
Slides & Samples for my SQLbits workshop & session
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
406 reads
StreamInsight sample from my 24HOP session
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
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers