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,555 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,484 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,283 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,065 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,584 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,495 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,969 reads
2003-07-08
6,869 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,772 reads
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
2002-09-23
17,560 reads
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
By Chris Yates
In today’s data-driven world, observability is not an optional add-on but a foundational principle....
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, Our old server is on its last legs, and I'm transitioning to a...
Comments posted to this topic are about the item Docker Advice for SQL Server...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers