Editorials

SQLServerCentral Editorial

Unstructured Data

I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.

You rated this post out of 5. Change rating

2007-11-01

134 reads

SQLServerCentral Editorial

Mining or Profiling

The more data you have, the better you should be able to predict something. Or at least that's one of the things that I learned while studying economics. If we could actually gather enough data about someone or some system, we could determine what the most likely outputs of the system will be. In the […]

You rated this post out of 5. Change rating

2007-10-29

86 reads

SQLServerCentral Editorial

What's Fair

If you read my recent editorial called Get Some Help, you realize that I didn't get any World Series tickets from the sale on the Colorado Rockie's web site. Not to berate the subject, but some friends and I had an interesting debate on how the situation was handled and what could be done differently.

You rated this post out of 5. Change rating

2007-10-26

59 reads

SQLServerCentral Editorial

Mini-Me

Will the next version of Windows be a "Mini-Me" version of Vista? Who knows, and it's too early to tell, but apparently there's a mini-kernel version of Windows 7, the one after Vista, which fits into 25MB on disk. That's a touch lower than the 4GB that Vista takes up. Granted it's not a full […]

You rated this post out of 5. Change rating

2007-10-25

140 reads

SQLServerCentral Editorial

Get Some Help

The vast majority of us never work on high volume systems. And I mean high volume systems, like backing a web server that gets millions of hits in a few minutes, which might result in tens of millions of database queries in the same amount of time.

(1)

You rated this post out of 5. Change rating

2007-10-24

316 reads

SQLServerCentral Editorial

A Matter of Degree

So we had an interesting debate on college degrees and how much weight to give them in an interview recently. Near the end someone mentioned they were curious what types of degrees people had as well as those the worked with. There were some interesting comments, and I decided that this might make a nice Friday poll.

You rated this post out of 5. Change rating

2007-10-19

134 reads

Blogs

RANK() vs DENSE_RANK(): #SQLNewBlogger

By

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

Read the latest Blogs

Forums

Fun with JSON

By ateraa

Comments posted to this topic are about the item Fun with JSON

Creating JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON II

Engineer Lessons

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Engineer Lessons

Visit the forum

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)
GO

See possible answers