SQL Maintenance Plans - Under the Covers!
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
2002-05-21
9,323 reads
Articles
Designing a Flexible Task Management Database
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,367 reads
SQL Security Resource Center Opens
SQLServerCentral.com is proud to launch it's first Resource Center for security. It's a one-stop shop for anything related to SQL Server security. All content is user-contributed and contains links to content throughout the web.
2002-05-20
78 reads
Freeware Product : ASPReport
It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
125 reads
Understanding Your Identity
Is the Identity property part of a transaction? I always thought so, but decided to test it and see what happens.
2002-05-16
4,574 reads
2002-05-15
2,962 reads
How Dynamic SQL Can Be Static SQL Part 2
This article shows you how to use the CASE function to design single query solutions that have changing results depending on the values you assign to variables. These techniques are extremely useful as alternatives to dynamic SQL.
2002-05-14
10,834 reads
Version Control for Stored Procedures
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
2002-05-10
13,464 reads
Get Your Free DTS Poster
SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05
2002-05-10
3,336 reads
2002-05-08
3,253 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