Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.
2004-02-02
17,566 reads
As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.
2003-12-19
9,495 reads
Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.
2003-12-02
12,291 reads
Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.
2003-10-13
6,075 reads
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
2003-10-08
8,594 reads
Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.
2003-09-17
12,505 reads
Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!
2003-08-12
9,986 reads
2003-07-08
6,878 reads
Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.
2003-03-30
18,816 reads
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
2002-09-23
17,599 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item The New Wave of Security...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers