SQL Saturday #119 – One week to go
One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...
2012-05-11
727 reads
Blog Posts
SQLRally 2012–Thursday
Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...
2012-05-11
709 reads
Tech Days 2012 in Kosovo
Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...
2012-05-11
1,851 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,411 reads
#SQLRally Women in Technology Panel of WIN AND AWESOMENESS
Best. Luncheon. EVAR.
I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...
2012-05-10
705 reads
“Query cost (relative to the batch)” <> Query cost relative to batch
OK, so that is quite a contradictory title, but unfortunately it is true. There is a common misconception that the query with...
2012-05-10
2,339 reads
Command line to configure windows firewall for SQL server access
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,813 reads
Denali — Day 10: Sequence object
Denali – Day 10: Sequence object
Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...
2012-05-10
1,272 reads
DQS Composite Domains and Value Combinations
As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...
2012-05-10
1,149 reads
DQS Composite Domains and Value Combinations
As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...
2012-05-10
778 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