Category Archives: best practices

Good Business Intelligence depends on a good Data Warehouse

Good BI, Good DW There are certain components that are essential for a successful Business Intelligence implementation and in this post I want to emphasize the importance of the data warehouse.  It’s obviously a foundational component and doing it right requires choosing the right DW model and implementing a quality design. My Baseball Woes I [...]

T-SQL Tuesday and Best Practices – SQL is a Set-Based Language

This month’s T-SQL Tuesday#20 – T-SQL best Practices is a tall order to write about.  Best practices can cover coding style, documentation, performance, and so many other areas that whole books can and have been written about them.  When I consider the poor practices I’ve seen in T-SQL code I think about the basic flaws [...]

Follow

Get every new post delivered to your Inbox.

Join 206 other followers