>>>They can very easily take a grandparent->parent->child operation that would take 1000s of calls to the database in your scenario and turn it into one query.

In a long career...

This solution is based on the premise that security is important enough to take the time to implement. If time is more important than preventing unrestricted access to the...

Browser is IE 6 - Windows 2000 Server SP4 -- this is my machine for maintaining legacy applications.

My standard for application design is NOT to have to step outside to...

Thank you, Phil Factor! I will be sure to keep the link to NET reflector where I can find it quickly. Now, can you explain those windows? ...

What is the name for the window with horizontal scroll bar in which the code is presented? Text of article -- window with code -- more article text --...

If your databases have many concurrent sessions and/or queries that touch millions of records, would you give up process threading on 8-processor machine to go to a VM where your...

So application developer A writes the CTE -- or the derived table -- then application developer B writes it slightly differently a month later in another application. Modularity? ...

The CTE is the way programmers get around not having database permission to create a view. Application programmers and "architects" who think "who needs a DBA?" write queries from...

The people responsible for architecting the "solutions" for a business should be about the business' data primarily and about the tools/technology secondarily. (I was a statistical data analyst before...

I think using Excel as the interface for selects from SQL Server is so much better than programming a dinky new interface. I'll save this article as a guide...

"... arguing that code reuse doesn't work.." -- I'm not sure whether that refers to stored procs useful for only one application in a database that supports more than one...

Thank you, previous poster.

I would bet the author of the app that creates slow-running SQL who knows where (1) says "I would never let **users** run ad hoc queries against...

Which job role does the ER diagramming? The DBA job title **started** with ER diagramming 25+ years ago. Why should the DBA hand over ER diagramming to a...

Of course a DBA works at the logical level. That's what ER diagramming is. Application developers who aren't at all familiar with ER diagramming? No wonder... ...

A good DBA **is** the data architect because she understands ER, DBMS performance, and SQL Server sysadmin.

What? says the app developer, commit to a specific DBMS platform? ...