Category: SQL rss

Posts

01 June / / SQL / Azure
20 February / / SQL

Creating successful SQL indexes is an art. I was reminded of this recently when I was looking at the indexing of a set of reporting tables, with each table expected to accommodate 100 million record.

19 September / / SQL

Long story short - be careful when using Linq that you don’t include calculated fields in your where clauses, or if you do make sure you know how the query is being executed.

13 August / / SQL / Azure

I was recently converting a website to have a responsive design using Bootstrap. The content is served from an Azure SQL database and I needed to make a copy of the database so I could update the content in a test environment first.