Step by Step how to setup Service Broker in Single Database
This article describes step by step how to create Service Broker objects and set up a basic conversation between the Initiator and Target from new author Jayakumar Krishnan.
The ROI for PASS 2009
A few of the reasons why you might want to attend the PASS Summit this November.
Auto Generate an Hourly SQL Server Profiler Trace File
I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.
How to Calculate Data Warehouse Reliability
This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Celko's SQL Stumper: The Data Warehouse Problem
Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!
Importing Data and New Hardware (Database Weekly)
Steve Jones looks at some of the interesting news this week in the SQL Server world.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
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