Browse by Tags

• Database Design
• Oracle
• SQL Server
• Tribal SQL

• Book Review: Tribal SQL,Performance Tuning With SQL Trace and Extended Events

  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... Posted Tuesday, February 18, 2014 9:51 AM by Alexander Kuznetsov | 3 Comments Filed under: Book Review, Tribal SQL

• Book Review: Tribal SQL, Chapter 1.

  "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... Posted Saturday, February 8, 2014 5:49 PM by Alexander Kuznetsov | 2 Comments Filed under: Book Review, Tribal SQL

• Book Review: Pro SQL Server 2008 Relational Database Design and Implementation

  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... Posted Monday, September 24, 2012 12:56 PM by Alexander Kuznetsov | 2 Comments Filed under: Database Design, Book Review

• Book Review: Oracle Database Administration for Microsoft SQL Server DBAs

  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... Posted Monday, September 27, 2010 2:26 PM by Alexander Kuznetsov | 3 Comments Filed under: SQL Server, Book Review, Oracle