Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
819 reads
Blog Posts
Why SQL Server is using so LESS memory
Today I want to talk about a phenomenon regarding memory management in SQL Server.
A few weeks ago I had a...
2011-11-04
7,200 reads
An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,468 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
4 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,265 reads
DDL Auditing presentation – feedback
Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than...
2011-11-03
774 reads
Dimensional Modeling Financial Data in SSAS pt2
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,268 reads
Find Recently Run Queries
If you have ever closed a query window by accident only to wish you could get back your work an...
2011-11-03
3,993 reads
Recording SQL Server Configuration Settings.
(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I....
2011-11-03
1,417 reads
SQL Server 2012: Business Intelligence Edition
Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for...
2011-11-03
2,717 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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