Advanced Medical Solutions Group (United Kingdom)

We've created a solid database structure, but just as a database is useless without tables, so a table is useless without data. We've been using the table editor to add data to tables, but it's time to introduce the power of the T-SQL language. We'll look at how we can add data to our tables, edit it, and how we can remove it. We'll even do a little bit of querying, which will take us nicely into the next chapter.

The last chapter taught you pretty much all you need to know to start creating stored procedures. We’ll enhance that knowledge in this chapter by introducing user-defined data types (UDT for short) and taking a detailed look at set-based logic. It’s one of the most important things you need to understand as a database developer, and once you understand it your database development skills will accelerate—fast!

Whew! We’ve certainly traveled a few roads together. We’ve taken a very basic—and poor—database structure and transformed it into a robust, well-defined database that could be used as the basis of any contact-based system you care to develop. Now that the database is out of the way, there are a few other things SQL Server offers worth taking a look at. This will be a bit brief, but you can use the overview as a springboard to find out about the things that sound interesting. Okay, let’s roll!

What do you think of when you hear the word "transaction"? I think of somebody who either buys or sells something to someone else. That's not quite what a transaction is in SQL Server, but as we'll see, this example will help us understand how transactions can be used to ensure our data stays consistent. Time to transact. . . .

SQL Server contains numerous system objects that greatly enhance the T-SQL language and your productivity. There are too many to mention here, but some of the more commonly used objects are briefly outlined, along with most of the functions/procedures we’ve seen throughout this book.

To test the antimicrobial effectiveness of a silver alginate dressing on opportunistic pathogens, namely meticillin-sensitive Staphylococcus aureus (MSSA) and meticillin-resistant Staphylococcus aureus (MRSA), Klebsiella spp., Enterococcus faecalis, Enterococcus faecium, Pseudomonas aeruginosa, Escherichia coli, Enterobacter sakazakii, Enterobacter cloacae, Serratia marcescens, Chryseobacterium indologenes, Proteus vulgaris and Acinetobacter baumannii. In total, 40 microorganisms were isolated from patients attending three burn centres in the US and evaluated for their susceptibility to a silver alginate wound dressing, employing a corrected zone of inhibition assay, conducted on Mueller Hinton agar (MHA). The sizes of the corrected zones of inhibition varied between and within genera. For example, all Acinetobacter baumannii strains were found to be sensitive to ionic silver at pH 7, with a mean of 2.8mm, compared with 3.5mm at pH 5.5. The silver alginate dressing also demonstrated activity on all strains of Enterobacter and Escherichia coli, with susceptibility to the silver alginate dressing enhanced at pH 5.5. For Enterococcus spp. the average corrected zone of inhibition at pH 7 was 3.6mm, versus 4.9mm at pH 5.5. All strains of Pseudomonas aeruginosa were found to be sensitive to the silver alginate dressing. The average corrected zone of inhibition was 6.9mm at pH 7, compared with 8mm at pH 5.5. For MRSA and Staphylococcus aureus, it ranged from 4.5mm to 7.5mm at pH 7. When the pH was decreased to 5.5, the corrected zone of inhibition increased. This study demonstrates the activity of a silver alginate dressing on a wide range of burn isolates, including antibiotic-resistant bacteria, isolated from three different burn centres in the US. It also highlights the possible importance of pH and its potential effects on antimicrobial performance and microbial susceptibility. However, more extensive testing is required to substantiate this. SLP is employed by Advanced Medical Solutions Ltd.