Browse by Tags

Tara Kizer wrote this chapter, and it is relevant for us developers. Tara briefly explains how to use the GUI, the Profiler, and states that it can heavily impact the performance on the server. Then she explains how to set up a server-side trace which Read More...

"Tribal SQL" is an interesting book, so I will be reviewing some, although not all, of its chapters. Quoting from the introduction, "This is a book for DBAs, for things you think they really ought to know". As an agile developer, I clearly do not belong Read More...

Investing in proper database design is a very efficient way to cut maintenance costs. If we expect a system to last, we need to make sure it has a good solid foundation - high quality database design. Surely we can and sometimes do cut corners and save Read More...

Working in mixed database environments is a very interesting challenge, both for DBAs and developers. If we already have experience with SQL Server, and need to work with Oracle, our SQL Server experience may be an advantage - we already have a good handle Read More...