A Fan and a Friend
I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group...
2010-03-25
686 reads
Blog Posts
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
652 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
530 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,083 reads
Measuring Transactional Replication Latency Without Tracer Tokens
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,092 reads
Powerscripting Podcast 2
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,921 reads
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,061 reads
Red Gate and Hyperbac
Imagine my surprise when I arrived at the Red Gate offices Monday morning to find Jeff Aven at the office....
2010-03-25
2,571 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,125 reads
SQL Server 2008 Activity Monitor
For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or...
2010-03-25
2,868 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers