A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
563 reads
James Serra's Blog
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,277 reads
SSIS package runs fine until put in a job
I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets...
2011-05-04
792 reads
What to blog about?
As I mentioned in my first post, I thought it would be real difficult to think of things to blog...
2011-05-02
562 reads
Antivirus solutions that are free
So my sister called me the other day to tell me she has a message on her laptop that said...
2011-04-29
1,648 reads
What name should I call myself?
In creating this blog, I was thinking about using some catchy name for myself. Something with “DBA” in it. However,...
2011-04-27
734 reads
Welcome To Machine
Hello World. Stardate 1513.1. After reading that, if you know what I am referring to, you are a tech-head and...
2011-04-25
721 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