Looking Back – PASS Summit 2009 Day 3
I started Wednesday planning on going to the Quest sponsored breakfast (plus presentation about DMVs) but when I bailed when...
2009-11-11
701 reads
Blog Posts
PASS Summit 2009 – Fun
I’m not a big party guy, and in fact, more than a few people can attest to the fact that...
2009-11-11
811 reads
Planning a Longer Break Soon
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
480 reads
Speaking at the .NET User Group meeting
When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory...
2009-11-11
287 reads
Troubleshooting SQL Server Database Mirroring Problems with Best Practices: Requirements, and the 64-bit Benefit
As mentioned in previous disaster recovery posts and article, during my current mandate I have been tasked with what will...
2009-11-11
11,945 reads
Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,590 reads
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 reads
Looking Back – PASS Summit 2009 Day 2
Tuesday started early for me because I had to be at the bloggers table in time for the opening remarks...
2009-11-10
637 reads
PASS Summit 2009 – Overall Event
I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some...
2009-11-10
697 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...
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