Blog

• Presentation Materials – Introduction to Test Driven Development for SQL Server

  

  2011-06-15 - Presentations

  This one-day class introduces the concepts of Test Driven Development in SQL Server.
  [more…]

• Presentation Materials – SQL Server Performance Monitoring Basics

  

  2011-06-09 - Presentations

  SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to [more…]

• Presentation Materials – Mining XML Query Plans

  

  2011-06-08 - Presentations

  Execution plans contain a lot of information that can guide you in your performance tuning process. Since SQL 2005 it is possible to retrieve the execution plans stored in the cache using DMVs and DMFs. However, as they are stored in XML format it can be cumbersome and difficult to extract the information you need.
  In this session, you will learn how the XML query plan is structured and how to use SQL Server’s built-in XQuery language to extract information. Examples include indexes that the optimizer indicates would increase performance if implemented and queries that use table scans or nested loop joins. [more…]

• Determine the Uptime of a SQL Server Instance

  

  2010-12-17 - General

  Every once in a while it is helpful to know the time that has passed since a SQL Server instance was last restarted. This information is particularly helpful when dealing with accumulating dynamic management views like sys.dm_db_index_usage_stats. If you do [more…]

• Identifying Test Cases #3

  

  2010-10-04 - General

  ReviewIn the previous two posts, we discussed some ways to look at code and pick out the test cases. These included finding the boundary test cases, input and output classes and special value testing. This time we’re going to take [more…]

• Identifying Test Cases #2

  

  2010-06-15 - General

  Last time, in Identifying Test Cases #1, we looked at some simple examples of identifying test cases for SQL statements. This time, we’re going to look at a more complex example in the form of a database view. Our ExampleSuppose [more…]

• Identifying Test Cases #1

  

  2010-06-08 - General

  It takes a lot of practice to write test cases for SQL code, and much of that practice happens on the job. One of the most important aspects in writing test cases is simply identifying what test cases to write. [more…]

• Claim your blog on Technorati.com

  

  2010-03-06 - Off Topic

  If you are writing your own blog, you might be interested in this information: Technorati.com is one of the most famous blog directories out there. To increase visibility of your blog, it is a good idea to claim it with [more…]

• Index Views: IndexPhysical

  

  2010-02-26 - General

  With this post I am going to start a series about queries that I find helpful while researching indexes and index issues. In fact, because I use them often, I encapsulated them in views. The first one is SATools.IndexPhysical: CREATE [more…]

• Faking Views

  

  2009-11-09 - General

  We’ve seen FakeTable in tSQLt in action in a few demos now. Did you know that you can use FakeTable to fake a view? You use FakeTable on a table when you want to test a procedure (or function or [more…]