This is the last article in a series about unit testing SQL Server with tSQLt: Introduction Anatomy of a tSQLt test Practical considerations Dealing with transactions The problem In my experience, most code is fine to be tested with tSQLt. However, code that involves transactions will get tangled up in the transaction that tSQLt uses … Continue reading Dealing with transactions in tSQLt
Practical considerations with tSQLt tests
This is the third article in a series on tSQLt: Introduction Anatomy of a test Practical considerations Dealing with transactions Getting organised One stored procedure under test is likely to need several stored procedures to test it properly. This means that the number of stored procedures in your database will increase greatly. (This is one … Continue reading Practical considerations with tSQLt tests
Anatomy of a tSQLt test
This is the second in a series of articles on tSQLt: Introduction Anatomy of a test Practical considerations Dealing with transactions Splitting into files and running tests tSQLt organises test cases into test suites. A test case is a stored procedure whose name starts with the word test. A test suite is a schema that … Continue reading Anatomy of a tSQLt test
Introduction to unit testing SQL Server stored procedures with tSQLt
This article is the first in a short series on tSQLt: Introduction Anatomy of a tSQLt test Practical considerations Dealing with transactions Introduction This is the introduction to the introduction! tSQLt lets you unit test stored procedures (including functions) on SQL Server. For why unit testing is a good idea, see my article on unit … Continue reading Introduction to unit testing SQL Server stored procedures with tSQLt
Is Computing a Science?
There's the term Computer Science, which puzzles me - is this field a science? Before I go on at probably great length, I feel it's important to say a few things to set the context. The most important one to me is: it doesn't matter. You can be good or bad at it whatever you … Continue reading Is Computing a Science?
Why bother testing?
There have been quite a few posts here about testing, and I expect that there will be several more, but so far I haven't addressed a fundamental question: Why bother testing? It's something that's good for the soul but you don't (usually) get paid for shipping tests, just for the production code and documentation. To … Continue reading Why bother testing?
Trying to not get too ranty about documenting software architecture
This article is my thoughts on a video about documenting software architecture: https://www.youtube.com/watch?v=kv8XedJTEww A summary of the video is: Domains other than software architecture, e.g. maps or electrical circuits, do a good job of capturing useful and important information in a way that communicates this well – this is mostly in pictures. Software architecture does … Continue reading Trying to not get too ranty about documenting software architecture
Testing a Web API
If you write a Web API (I’m using this to mean any API that you call via HTTP, such as a REST API using the Microsoft Web API framework), the world it’s part of is: It’s likely that while you’re developing, Client machine = Web server machine = Database machine, but this might not be … Continue reading Testing a Web API
A video with some practical security stuff
Another good Gotocon video, although the first few minutes are a bit bumpy until the speaker gets into the main part of the talk. The key points for me: Think about what security and risk mean for your system Add nasty strings from Fuzz DB to your existing tests Read OWASP Prepare for attacks and … Continue reading A video with some practical security stuff
Visualisations and the stories behind them
For me, the most important part of a visualisation isn't the visualisation at all. The most important part is the reaction it provokes, which should be equivalent to: Oh yes, now I get it. Actually, you often want things to continue on from this, so you get Oh yes, now I get it. Therefore ... … Continue reading Visualisations and the stories behind them
Random Tech Thoughts 