2004-02-24
3,027 reads
Robert Marda
- Interests: Sailing, camping, computers, reading and writing sci-fi and fantasy books.
Uses For Derived Tables
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
2004-02-06
17,749 reads
Auditing Through Triggers
In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.
2004-01-16
16,691 reads
Review of SQL Compare v3
Regular columnist Robert Marda had some extra time so we got him to take a look at the latest upgrade to SQL Compare - for those of you aren't familiar with it, it is a tool that will let you compare two databases to see the differences, then optionally sync one to the other.
2004-01-15
10,180 reads
Documenting Stored Procedures
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
2003-10-20
18,632 reads
Stored Procedure Development Cycle
This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.
2003-09-03
11,028 reads
What Your SP Can Return
Return values from stored procedures (not output params, true return values) probably aren't used as often as they should be. Robert gives you some good examples of how to use them.
2003-08-05
9,871 reads
Does Your SP Choke on Errors?
Should your stored procedure continue when it hits an error? Or keep executing? What errors will cause a stored procedure to quit executing auotmatically? Regular columnist Robert Marda has at least some of the answers, we think you'll find this interesting.
2003-06-26
7,374 reads
Handling The Text Data Type
Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.
2003-05-07
27,571 reads
Block the DBA?
Can you block a DBA from performing certain actions on a server if he has sysadmin rights? The real answer is no, but this article shows you how to block an unknowledgable DBA from performing certain actions.
2003-01-28
6,869 reads
Blogs
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Forums
How Many Can Be the Greatest
Comments posted to this topic are about the item How Many Can Be the...
How to process images and analyze charts with AI
Comments posted to this topic are about the item How to process images and...
Patching the Patch
Comments posted to this topic are about the item Patching the Patch
Question of the Day
How Many Can Be the Greatest
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers