Daily SQL Server 2008 New Feature – Day 2
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-07
739 reads
Blog Posts
Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,304 reads
DBAs – soon to disappear??
Heres a thought
With all the monitoring tools and performance gauging software available on the market these days, will there ever...
2010-05-07
595 reads
Denver SQL Server User’s Group Meeting on Thursday, May 20, 2010
The Denver SQL Server User’s Group will be having their May meeting next Thursday, May 20. As always, the meeting...
2010-05-07
500 reads
Log Shipping Problem
Log Shipping Issue (encountered by Abi Chapagai May 7th)
I had set up log shipping between two servers few weeks ago....
2010-05-07
7,602 reads
My experience while writing for SQL Server Standard magazine
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
820 reads
Reminder – SQLSaturday #38 in Jacksonville Tomorrow
It’s the third time for Jacksonville, hosting SQLSaturday #38 tomorrow at the University of North Florida. It’s about an hour...
2010-05-07
288 reads
SET clause in SQL Server (2008/2005)
SET clause in SQL Server uses in combination with other clauses to change the current behavior of the SQL Server...
2010-05-07
5,432 reads
SQL Server 2008 Performance Tuning Webcast
I recently gave a presentation on SQL Server Performance Tuning via Live Meeting. I discussed how you could use the...
2010-05-07
1,055 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,249 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