Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

2016-04-07

Removing stuff you don't need

So I start this series of updated old opinions and the MSDN blog change interface so there are no longer links to monthly archives except the last three months of posts. There is some logic to it I guess since it keeps the archive list shorter but I wish they made it configurable... Anyway; this time it is time to talk about some posts from July 2008 which can be found on this page.

2015-07-02

TOP not only for SELECT

I actually never considered the case that the TOP clause in SQL can be used for other tings than SELECT. But is it really a realistic use-case?

2014-03-27

Protecting your resource identifiers

In a lot of older web applications as well as newer RESTful services I've seen it fairly common to have identifiers such as user and order IDs just being an auto incremented primary key from the database. This approach has the problem of revealing your total number of users/orders in a certain time period. Information your competitors could use against you!