FlyClear, Privacy, and Time
Recently I signed up for the FlyClear program (www.flyclear.com), a registered traveler program. Over the past year I've been travelling...
2008-05-15
710 reads
Blog Posts
Midlands PASS May Meeting - Speaker Brian Knight
Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...
2008-05-15
636 reads
The Little Things
This year I've been lucky enough to have been offered some prizes or promotions from a few different companies for...
2008-05-15
1,199 reads
A Display Challenge
I've grown to like the presenter view in Powerpoint 2007; let's me navigate easily, and more important, lets me easily...
2008-05-13
451 reads
The CLR
Some very interesting responses to my CLR editorial today including some good details that I haven't seen elsewhere. I'm still...
2008-05-13
910 reads
Visiting Boston This Week
I get busy and usually forget to post when I'm out and about, but for once I've remembered. I'll be...
2008-05-11
455 reads
Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,818 reads
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,258 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,872 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
391 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